| change the name of orapwd.ora file on HP UX [message #60024] |
Sat, 10 January 2004 04:05  |
Subir
Messages: 13
Registered: November 2002
|
Junior Member |
|
|
Hi,
I have installed Oracle on HP UX. I created one database and in the parameter file the remote_login_passwordfile was commented. The database has been created successfully. But I am not able to connect with userid sys as sysdba from remote machine because the remote_login_passwordfile parameter has been commented. And I noticed orapwd.ora file does not exist in oracle_homedbs directory. So I created one password file named orapwd[[ORACLE_SID]].ora , because i need to create 2 more databases in this server. Then I set the remote_login_passwordfile parameter value as EXCLUSIVE. But when I restarted the database it is not getting started. It is searching the password file orapwd.ora not the one which i have created.
So can anyone pl tell me what to do, so that oracle should look for the "orapwd[[ORACLE_SID]].ora" instead of orapwd.ora.
Thanks in adv.
|
|
|
|
| Re: change the name of orapwd.ora file on HP UX [message #60030 is a reply to message #60024] |
Sun, 11 January 2004 03:55  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Hi
the general file naming convention for password file on Unix platforms is 'ORAPW[[ORACLE_SID]]'. for eg, orapwDB1 and is stored in $ORACLE_HOME/dbs. Its always a good idea to specify the complete path when creating the password file using orapwd utility.
HTH
Thiru
|
|
|
|
| Re: change the name of orapwd.ora file on HP UX [message #60058 is a reply to message #60030] |
Mon, 12 January 2004 22:34 |
Subir
Messages: 13
Registered: November 2002
|
Junior Member |
|
|
Thanks Thiru !!!
I have created one password file orapw[[SID_NAME]].ora
But the problem is that, when i start the database it is looking for the file without sid name.(orapw.ora)
So tell me what I should change so that the oracle should read the file orapw[[SID_NAME]].ora not orapw.ora file
|
|
|
|
| Re: change the name of orapwd.ora file on HP UX [message #60065 is a reply to message #60058] |
Tue, 13 January 2004 03:54 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Subir,
could you pls post the screenshot of your session here for better understanding. I generally name the password files on Solaris as orapw[[ORACLE_SID]] without the .ora extension . Adding the extension doesnt work.
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>echo $ORACLE_SID
AUX2
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>ls -l orapw*
-rwSr----- 1 oracle dba 1536 Jan 9 16:14 orapwAUX2
-rwSr----- 1 oracle dba 1536 Jan 7 14:49 orapwdbatest
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>s
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Jan 13 08:47:38 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL> show parameter remote_login
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
-- Lets rename the password file , so that it has the .ora extension
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>mv orapwAUX2 orapwAUX2.ora
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>s
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Jan 13 08:48:37 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 336679728 bytes
Fixed Size 455472 bytes
Variable Size 117440512 bytes
Database Buffers 218103808 bytes
Redo Buffers 679936 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01990: error opening password file
'/ora1/oracle/app/oracle/product/9.2.0/dbs/<B>orapw</B>'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
-- Lets rename the file back to its original name
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>mv orapwAUX2.ora <B>orapwAUX2</B>
AUX2@samgdeab06:/ora1/oracle/app/oracle/product/9.2.0/dbs>s
SQL*Plus: Release 9.2.0.3.0 - Production on Tue Jan 13 08:50:05 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 336679728 bytes
Fixed Size 455472 bytes
Variable Size 117440512 bytes
Database Buffers 218103808 bytes
Redo Buffers 679936 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
-Thiru
|
|
|
|
| Re: change the name of orapwd.ora file on HP UX [message #60103 is a reply to message #60065] |
Thu, 15 January 2004 18:54 |
Subir
Messages: 13
Registered: November 2002
|
Junior Member |
|
|
Hi Thiru,
I have tried both with and without specifying .ora extension along with that orapw[[SID_NAME]] file. But I am getting the same error both the times that you have written when you start the database with orapw[[SID_NAME]].ora file at your end.
- Subir
|
|
|
|
| Re: change the name of orapwd.ora file on HP UX [message #60130 is a reply to message #60103] |
Sat, 17 January 2004 05:30 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Subir,
Could you post the screenshot of your session here. As shown in my demo, orapw[[ORACLE_SID]] works fine on Solaris Server. I do not have a HP-UX server to confirm this.
Here's an extract from the Admin Guide for Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris
"filename: Name of the file where password information is written. The name of the file must be orapwsid and you must supply the full pathname. Its contents are encrypted and not user-readable. This parameter is mandatory. The password file is typically created in the $ORACLE_HOME/dbs directory "
-Thiru
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
