Unable to Connect to DB
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: Unable to Connect to DB

  1. #1
    Join Date
    Feb 2001
    Posts
    290
    Hello All,
    I am having a database running on UNIX, when I am trying to do SVRMGRL , i couldnt connect , it is saying me that ORACLE is not available , I have changed the ORACLE_SID to 'PROD' , i did see that through $echo ORACLE_SID... ( PROD is the database, which is running on this UNIX machine )
    and everything seems to be alright , but I am unable to connect , but the datbase is running.

    Anybody have some voice ????


  2. #2
    Join Date
    Jan 2000
    Location
    *
    Posts
    37
    Is your oracle home set correctly and your other environment variables?

  3. #3
    Join Date
    Sep 2000
    Posts
    96
    Is your listener up and running?

  4. #4
    Join Date
    Feb 2001
    Posts
    290
    Listener is running
    exported the ORACLE_HOME to a right path and ORACLE_SID
    to PROD, the database to which i would like to talk to

    But still unable to connect , any idea ???

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Are you able to get into svrmgrl prompt? Post the error meassage you get when you issue connect.

    Sanjay

  6. #6
    Join Date
    Aug 2001
    Posts
    147
    Originally posted by mrvajrala
    Listener is running
    exported the ORACLE_HOME to a right path and ORACLE_SID
    to PROD, the database to which i would like to talk to

    But still unable to connect , any idea ???
    try tnsping PROD to verify the database is running if you can't then you should look at the entries in TNSNAMES.ORA file or maybe your listener use the wrong tnsnames.ora file

  7. #7
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    are u able to connect to svrmgrl as internal...
    anandkl

  8. #8
    Join Date
    Feb 2001
    Posts
    290

    Angry

    ps -ef | grep ora_smon | grep -v grep
    Gives me oracle 1034 1 0 Feb 14 ? 1:35 ora_smon_prod

    echo $ORACLE_SID
    gives me DFLT

    echo $ORACLE_HOME
    /db01/app/oracle/product/8.1.7 ( Actual Home )

    lsnrctl status
    prod has 1 service handler(s)

    did the following

    export ORACLE_SID=PROD
    echo $ORACLE_SID
    PROD

    tnsping PROD

    TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 19-FEB-2002 09:15:00

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

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=aauxci03)(PORT=1521))
    OK (10 msec)


    aauxci03:/db01/app/oracle> svrmgrl

    Oracle Server Manager Release 3.1.7.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.2.0 - Production

    SVRMGR> connect internal;
    Connected.
    SVRMGR> select * from v$database;
    select * from v$database
    *
    ORA-01034: ORACLE not available
    SVRMGR>



    I think I have tried to answer all of the above questions, and you can see the ERROR, which i am getting in the process.

    Everything is alright , but i am unable to connect to database,
    would anybody help me to connect to my puppy???

    Thanks,
    Madhu






  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    echo $ORACLE_SID
    gives me DFLT

    The database running is not prod it is DFLT :-)

    Maybe if you startup the prod database ...

    Regards

    Angel

  10. #10
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    I have nil exp in unix, but i think .....
    1. your instance is in nomount stage
    or
    2. your db creation script didin't have the catalog.sql or catproc.sql.. the data dictionary views....

    cheers...

    tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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