Home » Infrastructure » Linux » ORACLE_HOME path (Oracle 10g, Red hat Linux)
ORACLE_HOME path [message #345847] Fri, 05 September 2008 01:23 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
When i connect the server machine through putty and want to use DBCA that time it gives me following error message
[oracle@unixmachine ~]$ dbca
-bash: dbca: command not found

So set the following paths
ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db_1; export ORACLE_HOME

PATH=$ORACLE_HOME/bin:$PATH; export PATH

So it works for me.

But when i relogin through putty and tried to use DBCA it again shows the error message. So need to set above paths again.

Please tell me where i can set the above paths so that there is need to set those paths again and again.

Thanks,

[Updated on: Fri, 05 September 2008 01:25]

Report message to a moderator

Re: ORACLE_HOME path [message #345872 is a reply to message #345847] Fri, 05 September 2008 03:17 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi
you need to set this variable in your oracle accounts '.profile' file, do you know how to do this?

from your /home/oracle directory type in

ls -a

this will give a list of the '.' files there should be a 'profile' file. edit this and add your required line.

you should also set ypour ORACLE_SID variable in this file.

regards

Alan

[Updated on: Fri, 05 September 2008 03:18]

Report message to a moderator

Re: ORACLE_HOME path [message #345885 is a reply to message #345847] Fri, 05 September 2008 03:47 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I do not find any .profile file in the current directory.

DO i need to create it?
Please tell me.


oracle@Linuxmachine ~]$ ls -a
.              .eggcups           .kde                     .rhn-applet.cache
..             .emacs             .mailcap                 .rhn-applet.conf
\              .esd_auth          .metacity                .rhopenoffice1.1
10gR2_db       .fonts.cache-1     .mime.types              .sversionrc
.gconf    .mozilla            .thumbnails
.bash_history  .gconfd            .nautilus                .torarc
.bash_logout   .gnome             .openoffice-install-log  .tora.tse
.bash_profile  .gnome2            .openoffice-lock         .Trash
.bashrc        .gnome2_private    oracle                   .viminfo
.canna         .gstreamer-0.8     oraInventory             .Xauthority
.config        .gtkrc             pro.txt                  .xemacs
Desktop        .gtkrc-1.2-gnome2  .qt                      .zshrc
.dmrc          .ICEauthority      .recently-used



Thanks

[Updated on: Fri, 05 September 2008 03:47]

Report message to a moderator

Re: ORACLE_HOME path [message #345887 is a reply to message #345885] Fri, 05 September 2008 03:48 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
ok you need to look in the '.bash_profile'

I now see that you are using Linux.

you should have something similar too
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db10g; export ORACLE_HOME
ORACLE_SID=emrep; export ORACLE_SID
OPATCH=$ORACLE_HOME/OPatch
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
OMS_HOME=$ORACLE_BASE/product/10.2.0/oms10g; export OMS_HOME


this is taken from my system so you need to make sutable changes.

I also notice that you have installed you ORACLE_HOME under you oracle login path

i.e. /home/oracle/etc/etc

this is generally not best practice.


regards

Alan

[Updated on: Fri, 05 September 2008 04:10]

Report message to a moderator

Re: ORACLE_HOME path [message #345897 is a reply to message #345847] Fri, 05 September 2008 04:09 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks Alan,
It works. Smile
Re: ORACLE_HOME path [message #345903 is a reply to message #345847] Fri, 05 September 2008 04:16 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Now

1. DBCA is working
2. sqlplus system/test123 is also working

Thanks,

[Updated on: Fri, 05 September 2008 04:26]

Report message to a moderator

Re: ORACLE_HOME path [message #345913 is a reply to message #345903] Fri, 05 September 2008 04:33 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

no problem

Alan
Re: ORACLE_HOME path [message #345918 is a reply to message #345847] Fri, 05 September 2008 04:51 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Sorry to disturb you all again.
But i cannot able to access Oracle enterprise console.

Please tell me requisites/configrables to start the OEMCTL
Does the command is right?

oracle@linux:~> oemctl start oms
-bash: oemctl: command not found
oracle@linux:~>


Thanks,

[Updated on: Fri, 05 September 2008 04:51]

Report message to a moderator

Re: ORACLE_HOME path [message #345982 is a reply to message #345918] Fri, 05 September 2008 08:05 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi
I think the command is

emctl start dbconsole

regards

Alan
Previous Topic: OC4J instance runs but closes right after running
Next Topic: Need help
Goto Forum:
  


Current Time: Fri Mar 29 06:11:33 CDT 2024