Create Database

[OCDBA]

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.