Create Database

Creating Database..

1..Unique instance name that i have like "ansi74"

2.c:\>set ORACLE_SID=ansi74

3. Copy init.ora file and rename that with initANSI74.ora
location:c:\oracle\ora81\database\initANSI74.ora
contents of this file: IFILE=c:\init.ora

4.Paaword File creation.

c:\orapwd file=c:\oracle\ora81\database\PWDansi74.ora password=singh entries=5

5.start instance

>> connect sys as sysdba
>> startup nomount pfile=c:\oracle\ora81database\initANSI74.ora

6. Create data base with this command that below..

create database "ANSI74"
maxlogfiles 10
maxinstances 5
maxlogmembers 10
maxdatafiles 30
maxloghistory 100
logfile
group 1
'c:\pritpal\disk3\redo01.rdo' size 100k,
group 2
'c:\pritpal\disk4\redo02.rdo' size 100k
datafile
'c:\pritpal\disk5\system01.dbf' size 25m;



Init.ora
********
remote_login_passwordfile = exclusive

ok then

i have abc database and also pwdABC.ora(password file)


? Way oracle look for my OLD PASSWORDFILE.
? Way not new Password file that is pwdANSI74.ora(in same desti)

Because
? I have set ORACLE_SID=ansi74

error>>
ORA-01991:invalid password file c:\oracle\ora81\database\PWDabc.ora .

before i had this error:

The environment variables ORA_sid_PWFILE and ORA_PWFILE are not set.

Give reply.

Did you create a service?

You can use DBAssist to create a set of scripts to create your database. That also creates the service for you. Also, type oradim in command line to get a list of info for using oradim to create the service. Good luck! You will learn a lot by creating the db yourself!

The password file should be in $ORACLE_HOME/dbs directory and named orapwsid
I guess Oracle is looking at wrong password file.
HTH

Oooops.. just realised we are talking windows here. The correct location for Windows is $ORACLE_HOME/database and name pwdsid.ora
Make sure the service is running. And for known issues with password file go through this document.
How to Avoid Common Flaws and Errors Using Passwordfile

When u have DB Configuration Asst to create a database for u why u are messing with other files.As said by DBA_ADMIN use this tool to create a new DB.

Quote:

---

Originally posted by akhadar
When u have DB Configuration Asst to create a database for u why u are messing with other files.As said by DBA_ADMIN use this tool to create a new DB.

---

I don't know about others but I don't really like to do the things with GUIs.