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
Oracle LazyDBA home page