ORACLE_SID not defined ????

Printable View

10-12-2006, 02:38 PM
mayewil

ORACLE_SID not defined ????

I am trying to start the dbconsole on Oracle 10g installed on Solaris . I type /export/ORACLE_HOME/bin/emctl start dbconsole
I get the response "ORACLE_SID not defined" I have defined it in my home .profile file as follows:
ORACLE_SID=Jacob export $ORACLE_SID
Is my syntax correct?
Also I was advised to define it in the .bashrc file. I cannot find any .bashrc file, so I created one and entered the following:
ORACLE_HOME = /export/ORACLE_HOME export $ORACLE_HOME
ORACLE_SID =Jacob export $ORACLE_SID

Can anyone offer some help?
10-12-2006, 02:56 PM
LKBrwn_DBA

Incorrect syntax, use:

PHP Code:

ORACLE_SID=Jacob; export ORACLE_SID

:rolleyes:

PS: Remove the .bashrc file.
10-13-2006, 08:57 AM
mayewil

Re: ORACLE_SID not defined ???

Hey thanks for the followup. I removed the .bashrc file and cleaned up the .profile syntax as you suggested. However, I am still getting the error the same as before. Still says that the ORACLE_SID is not defined and that I need to define it. It is too vague an error message and shoule inform someone like me just where the heck I should define it!@#$%^& Other than in the .profile file, what about the oratab file? When I orifinally looked at it yesterday there was no definitions written to it, so I manually entered the following:
$ORACLE_SID:$Jacob:Y:
Any other suggestions?
Bill
10-13-2006, 09:14 AM
waitecj

The oratab file should read:

$ORACLE_SID:$ORACLE_HOME:Y|N

e.g:

MY_DB:/u01/app/oracle/10.2.0_MY_DB:N

Once it is in there:

. oraenv

to set your SID.
10-13-2006, 12:22 PM
mayewil

I ran the oraenv shell script . What I get when I attempt to start the dbconsole is an error msg stating: No message file for product=network, facility = TNS and this is repeated for all three: TNS-12560, TNS-00515 and TNS-12545.
I found some previous postings on this forum and how it was dealt with => reconfiguring the LISTENER was one idea that worked for someone.
My attempts at fixing anything wrong with the listener.ora file have not gained me anything. I've referenced Oracle's doc for 10g R2 for guidance.
Also, attempting to start dbconsole, this is what I get:
jacob# ../bin/emctl start dbconsole
OC4J Configuration issue. /export/ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_jacob_Jac
ob not found.
I'll take any advice, hunches, explanations. Thanks. Bill
10-13-2006, 12:33 PM
davey23uk

your ORACLE_HOME is not specificed or specified incorrectly

whats the contents of your oratab file and how did you 'run' it
10-13-2006, 12:53 PM
mayewil

Here's what's written to my oratab file:

Jacob:/export/ORACLE_HOME_Jacob:N
10-13-2006, 01:14 PM
mayewil

I executed the oratab.sh from /var/opt/oracle directory. It appears to execute OK (though no output).
10-13-2006, 02:28 PM
davey23uk

Quote:

Originally Posted by mayewil

Here's what's written to my oratab file:

Jacob:/export/ORACLE_HOME_Jacob:N

that doesnt match what you have written elsewhere

Quote:

Originally Posted by mayewil

Here's what's written to my oratab file:

Jacob:/export/ORACLE_HOME_Jacob:N

I executed the oratab.sh from /var/opt/oracle directory. It appears to execute OK (though no output).

it should be . oraenv
10-17-2006, 08:40 AM
mayewil

OK Thanks. I ran . oraenv The response I got was something along the lines of ORACLE_SID....[root] ?
I then entered the ORACLE_SID I want to assign. After that I looked at my environment settings and noticed that the ORACLE_SID is now displaying what I want it to. I then attempted to start the dbconsole and it looks like now I'm dealing with a config issue with enterprise manager.
10-18-2006, 02:08 PM
mayewil

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?
10-18-2006, 02:18 PM
davey23uk

your ORACLE_HOME and or ORACLE_SID arent defined correctly
10-19-2006, 12:37 AM
pareshjavkar

Quote:

Originally Posted by davey23uk

your ORACLE_HOME and or ORACLE_SID arent defined correctly

Hardcode them in the oracle user .profile.
10-19-2006, 11:22 AM
mayewil

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?
10-19-2006, 12:15 PM
davey23uk

you are trying to connect to a database called ORCL - you dont have a database called ORCL do you
10-19-2006, 02:35 PM
mayewil

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?
10-19-2006, 02:44 PM
davey23uk

do you not have a dba or SA around to help you with these things
10-20-2006, 08:18 AM
mayewil

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
10-20-2006, 08:58 AM
davey23uk

post the exact command and errors and details about the user
10-20-2006, 09:46 AM
mayewil

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#
12-07-2008, 08:44 AM
Energ jobs

ORACLE_SID not defined ????

You will need to set either the TWO_TASK or ORACLE_SID environment
variables to the correct values for your database. Consult Oracle
documentation for more details. Test your setting by connecting to
the database using an Oracle tool such as sqlplus. Once you can do
that then you can test DBD::Oracle knowing that it should work.The supplied test will connect to the database using the value of theORACLE_USER environment variable so you should set that to the correct
value before starting the test. Please read README.login.
12-07-2008, 01:55 PM
PAVB

Did you notice thread was more than two years old?