Error when start sqlplus or svrmgrl under 817
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Error when start sqlplus or svrmgrl under 817

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    42

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your environment is screwed, sort out ORACLE_HOME, ORACLE_SID, NLS_LANG and such like

  3. #3
    Join Date
    Jan 2002
    Posts
    42
    Could you give more details on how? It is HP server and running 9.2.0.6 and 8.1.7.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    which oraenv
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jan 2002
    Posts
    42
    The default ORACLE_HOME is 9.2.0.6

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    source oraenv or coraenv (depending on shell) to setup correct environment.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Jan 2002
    Posts
    42
    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.

  8. #8
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    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

  9. #9
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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
  •  



Click Here to Expand Forum to Full Width