DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Not able to shutdown the database

  1. #1
    Join Date
    Apr 2007
    Location
    india
    Posts
    11

    Not able to shutdown the database

    I am trying to shutdown one of my database on which Oracle Retail application is running.but oracle not recognising this command.it is giving following error.

    [oracle@ssipl-srvr-030 ~]$ export ORACLE_HOME=/u01/app/oracle/product/9.2.0
    [oracle@ssipl-srvr-030 ~]$ export ORACLE_SID=RWMSLDB
    [oracle@ssipl-srvr-030 ~]$ sqlplus "/ as sysdba"

    SQL*Plus: Release 8.0.6.0.0 - Production on Tue Aug 26 13:59:49 2008

    (c) Copyright 1999 Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.7.0 - Production

    SQL> shutdown
    unknown command "shutdown" - rest of line ignored.

    I found one thing in this error that at the time of login oracle giving two different version.
    1-SQL*Plus: Release 8.0.6.0.0
    2-Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

    When i checked listener it is showing this things:

    [oracle@ssipl-srvr-030 ~]$ lsnrctl status LISTENER

    LSNRCTL for Linux: Version 8.0.6.3.0 - Production on 26-AUG-2008 14:02:15

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))
    TNS-12224: TNS:no listener
    TNS-12541: TNS:no listener
    TNS-12560: TNSrotocol adapter error
    TNS-00511: No listener
    Linux Error: 2: No such file or directory
    Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=XXXXXXX))
    TNS-12618: TNS:versions are incompatible
    [oracle@ssipl-srvr-030 ~]$

    Please tell me how i have to resolve this problem.

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    you are using 8i binaries to shutdown 9i database.
    Use proper 9i binaries to shutdown your database.
    Rgds
    Parag

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Wink Path

    You need to set the correct 9i binaries in the PATH environment variable.

    PHP Code:
    export PATH=$ORACLE_HOME/bin:$PATH 
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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