ORA-01034: ORACLE not available
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORA-01034: ORACLE not available

  1. #1
    Join Date
    Jan 2001
    Posts
    32

    Unhappy

    hi all

    I have Oracle 8i Installed, with Solaris 5.7, Generic_106541-15 patch. I try log on and send me an error. I'm at the server and is an user that is not a ower of the oracle's software.

    $ sqlplus system

    SQL*Plus: Release 8.1.6.0.0 - Production on Mon Apr 30 16:34:21 2001

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

    Enter password:
    ERROR:
    ORA-01034: ORACLE not available


    Enter user-name:

    the database is up and it lend remote conections, the environment is

    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/8.1.6
    ORACLE_SID=siebel
    ORACLE_TERM=vt100

    siebel is the name of the instance and database.

    what can i do?





  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    do a ps -ef|grep siebel and see whether the instance is up and running. IF so then check your listener

    lsnrctl services
    lsnrctl status


    to see whether the listener is up and running. Then if the database is not up then do

    svrmgrl
    SVRMGR> CONNECT internal
    SVRMGR> startup
    SVRMGR> exit

    If the listeners are not running then

    lsnrctl start


    Then try connecting to the instance that you want to connect to. In the mean time make sure that you have a service name entry defined on tnsnames.ora file present under $ORACLE_HOME/network/admin/

    IF not modify the tnsnames.ora file and add an entry into it and then try connecting to the instance.


    BTW if it was a fresh install then your sys password would be change_on_install and your system password would be manager

    Good luck,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Posts
    32
    I verify the processes of the database with ps -ef | grep siebel and the database is running, the listener is up and the services of the listener is up too.

    what can i do else?



  4. #4
    Join Date
    Apr 2001
    Location
    santa clara
    Posts
    41
    -your environment doesnt have LD_LIBRARY_PATH and PATH pointing to $ORACLE_HOME/lib and $ORACLE_HOME/bin respectively

    Without these environment settings, can you cd to $ORACLE_HOME/bin and type sqlplus system/manager@siebel. This should work assuming your database is up.

  5. #5
    Join Date
    Apr 2001
    Location
    santa clara
    Posts
    41
    Next if none of those work, it could be that you are having too many oracle instances running.
    Do a ps -ef | grep oracle and check to see if there are other instances besides siebel .
    If there are many instances, you need to shut them down and have only the one you are using up and running to be able to use sqlplus

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