| ORACLE_HOME path [message #345847] |
Fri, 05 September 2008 01:23  |
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  |
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 |
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 |
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 #345918 is a reply to message #345847] |
Fri, 05 September 2008 04:51 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
