OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ORAPWD

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORAPWD [message #74596]

Mon, 17 January 2005 00:03

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

I have 2 databases (Oracle 9i database) in my machine.

I have illustrated using example

Parameter files & configuration files are stored under this directory
D:oracleadminDatabase1 for database1
D:oracleadminDatabase2 for database2

Datafiles, Logfiles and control files are stored:
D:oracleoradataDatabase1 for database1
D:oracleoradataDatabase2 for database2

Can anyone tell me where I should create the password file (using orapwd utility) for each database separately?

Regards,
Anand

Report message to a moderator

Re: ORAPWD [message #74597 is a reply to message #74596]

Mon, 17 January 2005 00:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

should be in $ORACLE_HOME/dbs

Report message to a moderator

Re: ORAPWD [message #74598 is a reply to message #74597]

Mon, 17 January 2005 02:36

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Thanks for the reply,
Can you tell me whether I need to create this directory?

One more thing, can you tell me how to find Oracle Home directory?

Thanks
Anand

Report message to a moderator

Re: ORAPWD [message #74599 is a reply to message #74598]

Mon, 17 January 2005 04:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Can you tell me whether I need to create this directory?
It should be precreated.
$ORACLE_HOME/dbs in unix
$ORACLE_HOME/database in windows ( not sure...).
anyhow,
there would a directory in $ORACLE_HOME that already has init< sid >.ora or orapwd< sid >.ora
Create your new orapwd file there!.

>>One more thing, can you tell me how to find Oracle Home directory
it is the directory with which the oracle is installed.

in your case mostly should be

D:oracleora92

to make sure check sqlplus.exe is in

D:oracleora92bin
if so, then your ORACLE_HOME is D:oracleora92.
You can also check your ENVIRONMENT variables and registry.

Report message to a moderator

Re: ORAPWD [message #74603 is a reply to message #74599]

Mon, 17 January 2005 19:31

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Thanks for your reply again.
You rightly said that (for windows) under ORACLE_HOME
there is a directory called database. I was able to locate a file PWD<sid>.ora

I did the following:
1) connect sys/password as sysdba;
I was able to connect.

2) I deleted the PWD<sid>.ora file under ORACLE_HOME/database directory.

3) connect sys/password as sysdba;
It gave me this error (possibly because the password file has been deleted)
SQL> connect sys/password as sysdba;
ERROR:
ORA-01031: insufficient privileges

4)Then I created the password file :
d:oracleora91database>orapwd file=PWD<sid>.ora password=diffpassword entries=10

5)connect sys/diffpassword as sysdba;
It gives me the same error:
SQL> connect sys/password as sysdba;
ERROR:
ORA-01031: insufficient privileges

CAN THIS BE EXPLAINED?
The parameter REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE

Thank you once again
Anand

Report message to a moderator

Re: ORAPWD [message #74604 is a reply to message #74603]

Wed, 19 January 2005 06:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

remove all entries in sqlnet.ora
try again.
And, never recreate the passwordfile when the database is alive.
do a clean shutdown.
recreate the passwordfile.
start the database.

Report message to a moderator

Re: ORAPWD [message #74638 is a reply to message #74604]

Mon, 24 January 2005 23:41

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

Hi,
Thanks. Now it works. Can you please tell me why it is necessary to remove all entries in SQLNet.Ora file?

The contents of sqlnet.ora file is :

# SQLNET.ORA Network Configuration File: #D:oracleora91networkadminsqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

Thank you in advance
Anand

Report message to a moderator

Re: ORAPWD [message #74640 is a reply to message #74638]

Tue, 25 January 2005 01:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Because in most cases, the options / parameters that are specified in sqlnet.ora are not USED.
Like Names directory.
You are not using it, but have it enabled.

Report message to a moderator

Previous Topic:	How to repeat columns
Next Topic:	internal error code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 20:07:31 CST 2024