Michael's step could look long, but that is the only way to fix the
problem I think. Just comment (#) remote_login.... and take comment off
the next time you bounce the database.
Sabina.
"Michael Porter "
<oracledba-ezmlmshield-x70336845.[Email address protected]
06/29/2006 02:45 PM
To
"LazyDBA Discussion" <[Email address protected]
cc
Subject
RE: orapassword file
Have you tried?
1) stop db
2) make sure your init.ora does NOT have the password file parmaeter
defined.
3) start db
4) create your orapw file, making sure you have file=orapwYOUR_SID
specified.
5) stop db
6) add password parm to init.ora
7) try and start db
M
>>> "Yvonne Tingstad "
<oracledba-ezmlmshield-x80708388.[Email address protected] 6/29/2006 2:20
PM >>>
I thought of that but it is set when I execute echo $ORACLE_SID. I've
tried deleting the password file and recreating it a few times as well
as resetting my environment however it still looks for the default
password file of orapw not orapwSID
-----Original Message-----
From: Joseph Crook
[mailto:oracledba-ezmlmshield-x82019942.[Email address protected]
Sent: Thursday, June 29, 2006 12:10 PM
To: LazyDBA Discussion
Subject: Fwd: orapassword file
Are you sure that you have ORACLE_SID set? It sounds like it is null.
joe
>>> "Yvonne Tingstad "
<oracledba-ezmlmshield-x3398217.[Email address protected] 06/29/06
1:05
PM >>>
I am trying to create a test db and it is telling me that the password
file doesn't exist. I've created a orapwSID password file in the
$ORACLE_HOME/dbs/ directory just as I have all of the others with the
same file permissions. The strange thing this time is that it is
looking
for $ORACLE_HOME/dbs/orapw file rather then orapwSID file...any ideas?
I'm using Oracle 9.2.0.7 on AIX 5.3
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the Baytex Energy Helpdesk at [Email address protected]
**********************************************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page