ORACLE_SID not defined ???? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: ORACLE_SID not defined ????

  1. #11
    Join Date
    Jun 2005
    Location
    Nearby Washington, DC
    Posts
    14
    I am at a showstopper ...cannot get the Enterprise Manager up on the local machine. When attempting to start emctl I still get errors ORA-27101. And even though I define the ORACLE_SID, somehow it always comes back to the error "The ORACLE _SID is not defined."

    When I try to start the listener I get error
    "No message file for product=network, etc."

    Anybody?

  2. #12
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your ORACLE_HOME and or ORACLE_SID arent defined correctly

  3. #13
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by davey23uk
    your ORACLE_HOME and or ORACLE_SID arent defined correctly

    Hardcode them in the oracle user .profile.

  4. #14
    Join Date
    Jun 2005
    Location
    Nearby Washington, DC
    Posts
    14
    OK. Back at it everybody! To this point I am close to accessing the isqlplus from my web browser. From web browser I type:
    http://192.xxx.x.xx:5560/isqlplus
    and get the following error messagge:
    ORA-12162 - TNS - net service name is incorrectly specified.

    Here's what's currently in my tnsnames.ora file:

    ORCL =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jacob) (PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = orcl)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )
    ---------------------------------------
    Here's my listener.ora file:
    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME=jacob.aspsftwre)

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (GLOBAL_DBNAME=jacob.aspsftwre)
    (ORACLE_HOME=/export/ORACLE_HOME)
    (SID_NAME=jacob)))
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = tcp) (HOST=jacob) (PORT = 1521))
    )
    )
    So, what do you think?

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you are trying to connect to a database called ORCL - you dont have a database called ORCL do you

  6. #16
    Join Date
    Jun 2005
    Location
    Nearby Washington, DC
    Posts
    14
    OK I modified my tnsnames.ora file to read as follows:

    jacob.aspsftwre =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jacob) (PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = jacob)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )
    I tried to start isqlplus again, but still get the TNS error #12543.

    In my /etc/hosts file this is what I have:
    127.0.0.1 localhost
    10.10.10.10 jacob loghost
    Could this be a problem? I think the correct IP address needs to be written here for the server, right? If so, how do I modify this file? I'm unable to write directly to it. Is there a shell script that makes the changes to this file?

  7. #17
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    do you not have a dba or SA around to help you with these things

  8. #18
    Join Date
    Jun 2005
    Location
    Nearby Washington, DC
    Posts
    14
    Yeah I'm flyin this baby alone. Hey, I'm trying to start the LISTENER. When I'm logged in as oracle user, it denies me permission. If I switch to root I get alot of missing Message errors and it too fails to start it. I think I need to add the oracle user to the dba group, but I can't find any documentation on exactly how you do that. I'm thinkin this might be what's preventing me from starting the listener. Can you give me a hint ...anyone?
    Bill

  9. #19
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    post the exact command and errors and details about the user

  10. #20
    Join Date
    Jun 2005
    Location
    Nearby Washington, DC
    Posts
    14
    As oracle user:
    $ /export/ORACLE_HOME/bin/lsnrctl start LISTENER
    ld.so.1: /export/ORACLE_HOME/bin/lsnrctl: fatal: /export/ORACLE_HOME/lib/libclntsh.so.10.1: Permission denied
    Killed
    $

    ------------------------------------------------------------------------

    As root:
    -bash-3.00# /export/ORACLE_HOME/bin/lsnrctl start LISTENER

    LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 20-OCT-2006 09:42:19

    Copyright (c) 1991, 2005, Oracle. All rights reserved.

    Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
    TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
    TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
    Solaris Error: 2: No such file or directory
    -bash-3.00#

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