-
Error when start sqlplus or svrmgrl under 817
There are error messages below when started sqlplus and svrmgrl under 8.1.7. Also why it started 'Oracle9i Enterprise Edition Release 9.2.0.1.0 ' when I issued svrmgrl under 8.1.7?
1. SQLPLUS>
ERROR:
ORA-01821: date format not recognized
SP2-0152: ORACLE may not be functioning properly
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jun 27 09:43:20 2005
2. SVRMGRL>
Oracle Server Manager Release 3.1.7.0.0 - Production
Message 4505 not found; No message file for product=SVRMGR, facility=MGR
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
-
your environment is screwed, sort out ORACLE_HOME, ORACLE_SID, NLS_LANG and such like
-
Could you give more details on how? It is HP server and running 9.2.0.6 and 8.1.7.
-
-
The default ORACLE_HOME is 9.2.0.6
-
source oraenv or coraenv (depending on shell) to setup correct environment.
Jeff Hunter
-
We are using Korn shells, I have checked oraenv in each /817 or /920 oracle bin directory, they are the default script, I am a newbie here, could you tell me where and how to change the environment to allow the new DB run on 817? Thanks.
-
ORACLE_SID=8.1.7
export ORACLE_SID
Set the above at the command prompt and try to start 8.1.7 and do the same for 9.2.0.6
Regards
anandkl
anandkl
-
need to do the oracle_home as well!
just do
. oraenv (note the dot)
then enter the name of the oracle sid when its asks you and you environment should then be set
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|