Home » Infrastructure » Unix » to set ORACLE_HOME & ORACLE_SID (SUN OS 5.10)
to set ORACLE_HOME & ORACLE_SID [message #323615] Thu, 29 May 2008 00:31 Go to next message
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 Go to previous messageGo to next message
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

icon14.gif  Re: to set ORACLE_HOME & ORACLE_SID [message #323626 is a reply to message #323615] Thu, 29 May 2008 01:07 Go to previous messageGo to next message
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 #323631 is a reply to message #323615] Thu, 29 May 2008 01:33 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Do you have a listener file ?
Post it

Check in $ORACLE_HOME/network/admin

Also set one more environment variable in the .profile

export TNS_ADMIN=$ORACLE_HOME/network/admin
Re: to set ORACLE_HOME & ORACLE_SID [message #323643 is a reply to message #323615] Thu, 29 May 2008 02:11 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
HI
this is the message iam getting and the log is attcahed to post

28-MAY-2008 12:52:02 * service_update * REMEDY * 0
28-MAY-2008 12:57:21 * service_update * REMEDY * 0
WARNING: Subscription for node down event still pending
28-MAY-2008 12:58:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=SUN-TKC2)(USER=root))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
28-MAY-2008 12:58:28 * service_update * REMEDY * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SUN-TKC2)(PORT=1521)))
28-MAY-2008 12:58:46 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=SUN-TKC2)(USER=root))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * stop * 0

Please do needful
Re: to set ORACLE_HOME & ORACLE_SID [message #323647 is a reply to message #323615] Thu, 29 May 2008 02:21 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Have you set the PATH variable correctly?
export PATH=$ORACLE_HOME/bin:$PATH

Post
$ env | grep ORACLE_HOME
$ env | grep TNS_ADMIN
$ env | grep ORACLE_SID
$ env | grep PATH
Re: to set ORACLE_HOME & ORACLE_SID [message #323652 is a reply to message #323615] Thu, 29 May 2008 02:37 Go to previous messageGo to next message
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 #323663 is a reply to message #323615] Thu, 29 May 2008 03:11 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
You are logging as root.
Why?

You should log in as oracle owner "oracle".
and then set the environment and try.
Re: to set ORACLE_HOME & ORACLE_SID [message #323668 is a reply to message #323663] Thu, 29 May 2008 03:28 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi
can you help in how would i know which user is logged in?

and steps to change the user?

Please do needful for this as iam starter of Oracle Administartor.
Re: to set ORACLE_HOME & ORACLE_SID [message #323673 is a reply to message #323615] Thu, 29 May 2008 03:42 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
boot your machine and log in as oracle.
oracle is the owner of the oracle software.
Re: to set ORACLE_HOME & ORACLE_SID [message #323675 is a reply to message #323673] Thu, 29 May 2008 03:45 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
ya,
i was already logged in as ORACLE..
Re: to set ORACLE_HOME & ORACLE_SID [message #323678 is a reply to message #323615] Thu, 29 May 2008 03:50 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Do you now see a $ prompt?

$ lsnrctl start
Re: to set ORACLE_HOME & ORACLE_SID [message #323697 is a reply to message #323678] Thu, 29 May 2008 04:55 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
no..
it was # prompt
Re: to set ORACLE_HOME & ORACLE_SID [message #323726 is a reply to message #323615] Thu, 29 May 2008 05:56 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
post
ls -ltr $ORACLE_HOME
Re: to set ORACLE_HOME & ORACLE_SID [message #323741 is a reply to message #323726] Thu, 29 May 2008 06:16 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi,this is the output i got..

# ls -ltr $ORACLE_HOME
total 178
-rwxrwxr-x 1 remedy oinstall 0 Jun 7 2005 root.sh.old
-rwxrwxr-x 1 remedy oinstall 68 Apr 8 20:45 oraInst.loc
-rwxrwxr-x 1 remedy oinstall 38 Apr 8 20:46 install.platform
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:46 assistants
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:46 clone
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:46 crs
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 demo
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 diagnostics
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 has
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:46 javavm
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 jre
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:46 md
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:46 nls
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:46 odbc
drwxrwxr-x 5 remedy oinstall 512 Apr 8 20:46 olap
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:46 oracore
drwxrwxr-x 8 remedy oinstall 512 Apr 8 20:46 ord
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:46 owm
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:46 perl
drwxrwxr-x 8 remedy oinstall 512 Apr 8 20:46 precomp
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 slax
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 sqlj
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 tg4ifmx
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 tg4ingr
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 tg4sybs
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 tg4tera
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:46 uix
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:46 wwg
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:46 plsql
drwxrwxr-x 2 remedy oinstall 512 Apr 8 20:46 mesg
drwxrwxr-x 6 remedy oinstall 512 Apr 8 20:47 xdk
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:48 jdbc
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:48 relnotes
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:48 jdk
drwxrwxr-x 4 remedy oinstall 512 Apr 8 20:48 OPatch
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:48 oui
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:48 mgw
drwxrwxr-x 2 remedy oinstall 1536 Apr 8 20:48 jlib
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:48 cdata
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:48 css
drwxrwxr-x 9 remedy oinstall 512 Apr 8 20:48 sqlplus
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:48 opmn
drwxrwxr-x 10 remedy oinstall 512 Apr 8 20:48 ctx
drwxrwxr-x 2 remedy oinstall 512 Apr 8 20:49 config
drwxrwxr-x 13 remedy oinstall 512 Apr 8 20:49 ldap
drwxrwxr-x 13 remedy oinstall 512 Apr 8 20:49 srvm
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:49 racg
drwxrwxr-x 13 remedy oinstall 512 Apr 8 20:49 sysman
drwxrwxr-x 4 remedy oinstall 3584 Apr 8 20:49 lib32
drwxrwxr-x 13 remedy oinstall 512 Apr 8 20:50 network
drwxrwxr-x 3 remedy oinstall 5632 Apr 8 20:50 lib
drwxrwxr-x 2 remedy oinstall 512 Apr 8 20:50 instantclient32
drwxrwxr-x 7 remedy oinstall 512 Apr 8 20:50 hs
-rwxrwxr-x 1 remedy oinstall 9549 Apr 8 20:50 root.sh
drwxrwxr-x 14 remedy oinstall 512 Apr 8 20:50 rdbms
drwxrwxr-x 15 remedy oinstall 512 Apr 8 20:50 oc4j
drwxrwxr-x 12 remedy oinstall 512 Apr 8 20:50 inventory
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:50 log
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:51 flash_recovery_area
drwxrwxr-x 3 remedy oinstall 512 Apr 8 20:54 SUN-TKC2_REMEDY
drwxrwxr-x 5 remedy oinstall 512 Apr 8 20:56 install
drwxrwxr-x 7 remedy oinstall 512 Apr 8 21:00 cfgtoollogs
drwxrwxr-x 4 remedy oinstall 512 May 27 15:54 admin
drwxr-x--- 3 root root 512 May 27 15:54 oradata
drwxrwxr-x 2 remedy oinstall 512 May 27 17:02 dbs
drwx------ 2 root root 512 May 28 13:09 Mail
drwxrwxr-x 2 remedy oinstall 5632 May 28 16:47 bin
Re: to set ORACLE_HOME & ORACLE_SID [message #323747 is a reply to message #323615] Thu, 29 May 2008 06:23 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Did you install oracle as user remedy?
Re: to set ORACLE_HOME & ORACLE_SID [message #323901 is a reply to message #323747] Fri, 30 May 2008 00:09 Go to previous messageGo to next message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
ya.IS there any problem with this?

[Updated on: Fri, 30 May 2008 00:10]

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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 Go to previous messageGo to next message
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
Re: to set ORACLE_HOME & ORACLE_SID [message #324036 is a reply to message #324028] Fri, 30 May 2008 06:14 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Two things I see :

1. There seems to be a missing / at the beginning of the variable PATH.

2. Is the ORACLE_SID really REMEDY too?

I believe the best thing to do would be to un-install everything and then re-install Oracle by following the installation instructions to the letter.
Re: to set ORACLE_HOME & ORACLE_SID [message #324040 is a reply to message #324036] Fri, 30 May 2008 06:26 Go to previous message
ravindragdm
Messages: 25
Registered: May 2008
Location: Bangalore
Junior Member
hi
i added / to path..
ORACLE_SID is REMEDY..correct..



IAM very happy to say that oracle database is started..

THANK you all..

[Updated on: Fri, 30 May 2008 06:33]

Report message to a moderator

Previous Topic: How to delete files from a folder, which is older then 10 days?
Next Topic: log file creation
Goto Forum:
  


Current Time: Tue Apr 16 18:15:37 CDT 2024