Oracle on Solaris
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle on Solaris

Hybrid View

  1. #1
    Join Date
    Dec 2001
    Posts
    8
    Hi guys/gals,

    I installed Oracle 8i on Solaris, and had my database up and running. someone shut down the box, and my db has crashed. I can't seem to get it started up again. when I try to log into the db using sqlplus, I get the error message ORA-1034 ORACLE NOT AVAILABLE. I've run the tnslsnr binary, and the oracle binary, but still no luck. any ideas? is there something, that I'm overlooking?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Are your environment variables setup correctly? Did you run dbstart ? Do you see any oracle processes?
    http://technet.oracle.com/docs/produ...de_sun_817.pdf
    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."

  3. #3
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    What happens if you connect internal in either SQLPLUS or SVRMGRL and startup?
    any errors?
    ORA-1034 suggests the database has not been started.

    ps -ef | grep ora
    will show what processes are running for Oracle.
    if you see none, startup the database.
    if you see some, shutdown (normal or abort) and startup

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
    setenv ORACLE_SID database_name   -- if it were to be C shell
    
    export ORACLE_SID=databasename
    
    export ORACLE_HOME= .../product/...
    export PATH= $ORACLE_HOME/bin:$PATH
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib
    
    First start the listeners
    $> lnsrctl start
    $> lsnrctl status
    
    Now start the database 
    
    $> svrmgrl
    SVRMGR> connect internal
    SVRMGR> shutdown immediate        -- To confirm a shutdown had taken place
    SVRMGR> startup mount
    SVRMGR> recover database;
    SVRMGR> alter database open;
    SVRMGR> exit
    
    $> sqlplus username/password@servicename
    SQL>
    Remember when you set the environment depending on your shell you have to use either export or setenv

    To get the list of all SIDs on solaris checl

    $> less /var/opt/oracle/oratab

    Home this would help you.

    Before proceeding, check your alert_sid.log for error messages

    Sam

    [Edited by sambavan on 12-03-2001 at 03:15 PM]
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Dec 2001
    Posts
    8

    thanks for your replies

    thanks everyone, I'll follow the steps and update you with my progress. as luck would have it, I'm running the kshell, so I've been setting the variables, and then running export. ie.

    ORACLE_SID=PLAT2001
    export ORACLE_SID

  6. #6
    Join Date
    Dec 2001
    Posts
    8

    new info

    ok, I went to server manager and here's the output:

    SVRMGR> connect internal
    Message 701 not found; No message file for product=SVRMGR, facility=MGR
    Error while trying to retrieve text for error ORA-12571

    am I skipping something else? or are my environment variables set up improperly?

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Your environment variables are not setup correctly.

    Make sure you have set:
    ORACLE_HOME
    ORACLE_SID
    LD_LIBRARY_PATH
    PATH

    variables correctly. The easiest way to set these variables is via the oraenv script.

    . 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."

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