to set ORACLE_HOME & ORACLE_SID [message #323615] |
Thu, 29 May 2008 00:31  |
ravindragdm
Messages: 25 Registered: May 2008 Location: Bangalore
|
Junior Member |
|
|
HI
please provide me the steps in setting ORACLE_HOME & ORACLE_SID
Whether we have to logged in as SUPERUSER while seeting these?
after setting these two, whether these two should reflect in LISTENER.ORA?
Any advice would be greatly appreciated..
|
|
|
Re: to set ORACLE_HOME & ORACLE_SID [message #323622 is a reply to message #323615] |
Thu, 29 May 2008 00:55   |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Quote: | please provide me the steps in setting ORACLE_HOME & ORACLE_SID
|
$ export ORACLE_HOME=/location/of/oracle/installed/products
$ export ORACLE_SID="your database service name"
Quote: | Whether we have to logged in as SUPERUSER while seeting these?
|
No, you have to logged in as oracle owner and to make these variables persistent,you need to edit a file in /home/oracle
.profile.OPen it in vi editor and set variables there.
This will make the variables permanent after booting.
Quote: | after setting these two, whether these two should reflect in LISTENER.ORA?
|
No
[Updated on: Thu, 29 May 2008 00:58] Report message to a moderator
|
|
|
Re: to set ORACLE_HOME & ORACLE_SID [message #323626 is a reply to message #323615] |
Thu, 29 May 2008 01:07   |
ravindragdm
Messages: 25 Registered: May 2008 Location: Bangalore
|
Junior Member |
|
|
Hi
While starting the oracle listener in SUN OS 5.10..Iam getting the foillowing message,,,Can anyone provide the workaround for the same.
Any advice would be greatly appreciated.Below were message what iam getting...
bash-3.00$ ./lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 28-MAY-2008 16:39:1
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Message 1053 not found; No message file for product=network, facility=TNSTNS-12541:
Message 12541 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-00511: Message 511 not found; No message file for product=network, facility=TNS
Solaris Error: 146: Connection refused
bash-3.00$ ./lsnrctl start
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 28-MAY-2008 15:53:04
Copyright (c) 1991, 2005, Oracle. All rights reserved. Message 1070 not found; No message file for roduct=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
Note: ORACLE_HOME & ORACLE_SID ..are correct.
|
|
|
|
|
|
Re: to set ORACLE_HOME & ORACLE_SID [message #323652 is a reply to message #323615] |
Thu, 29 May 2008 02:37   |
ravindragdm
Messages: 25 Registered: May 2008 Location: Bangalore
|
Junior Member |
|
|
HI
bash-3.00# pwd
/u01/app/oracle/product/product/10.2.0/Db_1/bin
bash-3.00# env|grep ORACLE_HOME
ORACLE_HOME=/u01/app/oracle/product/product/10.2.0/Db_1
bash-3.00# env|grep ORACLE_SID
ORACLE_SID=REMEDY
bash-3.00# env|grep TNS_ADMIN
TNS_ADMIN=/u01/app/oracle/product/product/10.2.0/Db_1/network/admin
bash-3.00# env|grep PATH
MANPATH=/usr/dt/man:/usr/man:/usr/openwin/share/man
DTHELPSEARCHPATH=/u02/profile/.dt/help/oracle-172.19.18.77-0/%H:/u02/profile/.dt/help/oracle-172.19.18.77-0/%H.sdl:/u02/profile/.dt/h elp/oracle-172.19.18.77-0/%H.hv:/u02/profile/.dt/help/%H:/u02/profile/.dt/help/%H.sdl:/u02/profile/.dt/help/%H.hv:/usr/dt/appconfig/h elp/%L/%H:/usr/dt/appconfig/help/%L/%H.sdl:/usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/dt/appconfig/help/C/%H.sd l:/usr/dt/appconfig/help/C/%H.hv
HELPPATH=/usr/openwin/lib/locale:/usr/openwin/lib/help
PATH=u01/app/oracle/product/product/10.2.0/Db_1/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb
DTAPPSEARCHPATH=/u02/profile/.dt/appmanager:/usr/dt/appconfig/appmanager/%L:/usr/dt/appconfig/appmanager/C
XFILESEARCHPATH=/usr/openwin/lib/locale/%L/%T/%N%S:/usr/openwin/lib/%T/%N%S
DTDATABASESEARCHPATH=/u02/profile/.dt/types,/usr/dt/appconfig/types/%L,/usr/dt/appconfig/types/C
XMICONSEARCHPATH=/u02/profile/.dt/icons/%B%M.pm:/u02/profile/.dt/icons/%B%M.bm:/u02/profile/.dt/icons/%B:/usr/dt/appconfig/icons/%L/% B%M.pm:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/% B%M.bm:/usr/dt/appconfig/icons/C/%B
XMICONBMSEARCHPATH=/u02/profile/.dt/icons/%B%M.bm:/u02/profile/.dt/icons/%B%M.pm:/u02/profile/.dt/icons/%B:/usr/dt/appconfig/icons/%L /%B%M.bm:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C /%B%M.pm:/usr/dt/appconfig/icons/C/%B
bash-3.00# echo $PATH
u01/app/oracle/product/product/10.2.0/Db_1/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb
----------------------------------------------------------------
this is message iam getting while starting lsnrctls start:
bash-3.00# ./lsnrctl start
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 29-MAY-2008 13:05:20
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/product/10.2.0/Db_1/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /u01/app/oracle/product/product/10.2.0/Db_1/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Solaris Error: 13: Permission denied
Listener failed to start. See the error message(s) above...
-------------------------------------------------------------
please do needful..
[Updated on: Thu, 29 May 2008 02:57] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: to set ORACLE_HOME & ORACLE_SID [message #324021 is a reply to message #323901] |
Fri, 30 May 2008 05:16   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Quote: |
ya.IS there any problem with this?
|
Not when you know what you are doing.
But since you NEVER mentioned that you didn't install as user "oracle" when somebody told you to "log in as oracle", and you even said "I was already logged in as ORACLE.." then I really doubt that is the case.
So since Oracle is installed in a NON-STANDARD way, there is very likely no chance for you to find any help regarding that installation without first telling us how exactly oracle is installed, and if there are any other things in the installation that are non-standard.
[Updated on: Fri, 30 May 2008 05:20] Report message to a moderator
|
|
|
Re: to set ORACLE_HOME & ORACLE_SID [message #324028 is a reply to message #324021] |
Fri, 30 May 2008 06:00   |
ravindragdm
Messages: 25 Registered: May 2008 Location: Bangalore
|
Junior Member |
|
|
HI all,
I regret for my mistake.
Installed Oracle with user remedy.
Any advice would be gratly appreciated.
$ env|grep ORACLE_HOME
ORACLE_HOME=/u01/app/oracle/product/product/10.2.0/Db_1
$ env|grep ORACLE_SID
ORACLE_SID=REMEDY
$ env|grep TNS_ADMIN
TNS_ADMIN=/u01/app/oracle/product/product/10.2.0/Db_1/network/admin
$ env|grep PATH
DTAPPSEARCHPATH=/u01/app/oracle/product/product/10.2.0/Db_1/.dt/appmanager:/usr/
dt/appconfig/appmanager/%L:/usr/dt/appconfig/appmanager/C
DTDATABASESEARCHPATH=/u01/app/oracle/product/product/10.2.0/Db_1/.dt/types,/usr/
dt/appconfig/types/%L,/usr/dt/appconfig/types/C
DTHELPSEARCHPATH=/u01/app/oracle/product/product/10.2.0/Db_1/.dt/help/suntkc-172
.19.18.77-1/%H:/u01/app/oracle/product/product/10.2.0/Db_1/.dt/help/suntkc-172.1
9.18.77-1/%H.sdl:/u01/app/oracle/product/product/10.2.0/Db_1/.dt/help/suntkc-172
.19.18.77-1/%H.hv:/u01/app/oracle/product/product/10.2.0/Db_1/.dt/help/%H:/u01/a
pp/oracle/product/product/10.2.0/Db_1/.dt/help/%H.sdl:/u01/app/oracle/product/pr
oduct/10.2.0/Db_1/.dt/help/%H.hv:/usr/dt/appconfig/help/%L/%H:/usr/dt/appconfig/
help/%L/%H.sdl:/usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/
dt/appconfig/help/C/%H.sdl:/usr/dt/appconfig/help/C/%H.hv
HELPPATH=/usr/openwin/lib/locale:/usr/openwin/lib/help
MANPATH=/usr/dt/man:/usr/man:/usr/openwin/share/man
PATH=u01/app/oracle/product/product/10.2.0/Db_1/bin:/usr/sbin:/usr/bin:/usr/dt/b
in:/usr/openwin/bin:/usr/ucb
XFILESEARCHPATH=/usr/openwin/lib/locale/%L/%T/%N%S:/usr/openwin/lib/%T/%N%S
XMICONBMSEARCHPATH=/u01/app/oracle/product/product/10.2.0/Db_1/.dt/icons/%B%M.bm
:/u01/app/oracle/product/product/10.2.0/Db_1/.dt/icons/%B%M.pm:/u01/app/oracle/p
roduct/product/10.2.0/Db_1/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/
dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/ic
ons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B
XMICONSEARCHPATH=/u01/app/oracle/product/product/10.2.0/Db_1/.dt/icons/%B%M.pm:/
u01/app/oracle/product/product/10.2.0/Db_1/.dt/icons/%B%M.bm:/u01/app/oracle/pro
duct/product/10.2.0/Db_1/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt
/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icon
s/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B
$ pwd
/
$
---------------------------------------------------------------
LSNRCTL
--------------------------------------------------------------
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 30-MAY-2008 16:17:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Message 850 not found; No message file for product=network, facility=NL
LSNRCTL> status
Message 1053 not found; No message file for product=network, facility=TNSTNS-12541: Message 12541 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-00511: Message 511 not found; No message file for product=network, facility=TNS
Solaris Error: 146: Connection refused
LSNRCTL> start
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
LSNRCTL>
Please do needful
with warm regards
|
|
|
|
|