-
oraenv/dbhome/sqlplus errors
Dear DBA's,
I have a 2 node 10g RAC running on AIX 5.3. I'm having some issues with the oraenv/dbhome/sqlplus. When i try to use these features to access my database i get the following errors:
(oracle@lbdbora1) /home/oracle > . oraenv
ORACLE_SID = [labtest1] ?
dbhome[4]: 0403-057 Syntax error at line 4 : `(' is not expected.
ORACLE_HOME = [] ? $OH
(oracle@lbdbora1) /home/oracle > sqlplus
ksh: sqlplus: not found.
(oracle@lbdbora1) /home/oracle > sqlplus / as sysdba
ksh: sqlplus: not found.
(oracle@lbdbora1) /home/oracle >
I've done some research & can't seem to find out what the problem is. Can anyone help me?
Regards,
divroro12
-
You are getting a korn shell error message.
I would check oraenv shell script and look very carefully at line #4.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Do you mean the dbhome script or the oraenv script, b/c the line 4 error is as follows:
dbhome[4]: 0403-057 Syntax error at line 4 : `(' is not expected.
Regards,
divroro12
-
Check your environmental variables, you are gonna find they are not set therefore oraenv failed to do it.
That's why you are getting sqlplus:not found error message, because of you do not have set your ORACLE_HOME, which is part of what oraenv is supposed to do.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
I just checked my environmental variables & compared it with that of a similar system that's working perfectly; all looks good...
Regards,
divroro12
-
If this is the case you should be able to run sqlplus with no problems.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Just tried again...here're the results:
(oracle@lbdbora1) /home/oracle > pwd
/home/oracle
(oracle@lbdbora1) /home/oracle > . oraenv
ksh: oraenv: not found.
(oracle@lbdbora1) /home/oracle >
Regards,
divroro12
-
Here's my environment...
(oracle@lbdbora1) /home/oracle > env
_=/usr/bin/env
SBLOG=/obacktrack/log
LANG=en_US
LOGIN=oracle
PATH=$OH/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbi
n:.:/usr/lbin:/bmc/sqlbacktrack/obacktrack/bin://u01/app/oracle/product/10.2.0_d
b/OPatch
ORACLE_BASE=/u01/app/oracle
OH=/u01/app/oracle/product/10.2.0_db
ORACLE_ASM_HOME=/u01/app/oracle/product/10.2.0_asm
LC__FASTMSG=true
OL=/u01/app/oracle/local
OB=/u01/app/oracle
EDITOR=vi
LOGNAME=oracle
ORACLE_CRS_HOME=/u01/crs/oracle/product/10.2.0
MAIL=/usr/spool/mail/oracle
DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
ORACLE_HOME_LISTENER=/u01/app/oracle/product/10.2.0_asm
ORACLE_SID=labtest1
LOCPATH=/usr/lib/nls/loc
OS=/u01/app/oracle/local/scripts
PS1=($USER@$HOST) $PWD >
DTBASE=/bmc/sqlbacktrack
HOST=lbdbora1
ORACLE_LOCAL=/u01/app/oracle/local
USER=oracle
AUTHSTATE=compat
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
DSMI_LOG=/usr/tivoli/tsm/client/logs
HOME=/home/oracle
TERM=ansi
OASM=/u01/app/oracle/product/10.2.0_asm
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=$OH
PWD=/home/oracle
TZ=EST5EDT
OCRS=/u01/crs/oracle/product/10.2.0
AIXTHREAD_SCOPE=S
DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
Regards,
divroro12
-
Here's the oracle user's profile:
(oracle@lbdbora1) /home/oracle > cat .profile
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH
if [ -s "$MAIL" ] # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
EDITOR=vi; export EDITOR
export HOST=`hostname`
PS1='($USER@$HOST) $PWD > '
export PS1
alias bdf='df -m'
alias ll='ls -laF'
alias lt='ll -t | pg'
#alias rm='rm -i'
alias mv='mv -i'
alias cp='cp -i'
alias cls='clear'
ORACLE_ASM_HOME=/u01/app/oracle/product/10.2.0_asm
ORACLE_HOME_LISTENER=/u01/app/oracle/product/10.2.0_asm
ORACLE_HOME=/u01/app/oracle/product/10.2.0_db
ORACLE_BASE=/u01/app/oracle
ORACLE_CRS_HOME=/u01/crs/oracle/product/10.2.0
ORACLE_SID=labtest1
export ORACLE_ASM_HOME ORACLE_HOME_LISTENER ORACLE_HOME ORACLE_BASE
export ORACLE_CRS_HOME ORACLE_SID
export ORACLE_LOCAL=/u01/app/oracle/local
export AIXTHREAD_SCOPE=S
PATH=$ORACLE_HOME/bin:$PATH:/usr/lbin
export PATH
OH=$ORACLE_HOME
export OH
OB=$ORACLE_BASE
export OB
OASM=$ORACLE_ASM_HOME
export OASM
OCRS=$ORACLE_CRS_HOME
export OCRS
OL=$ORACLE_LOCAL
export OL
OS=/u01/app/oracle/local/scripts
export OS
SBLOG=$DTBASE/obacktrack/log
export SBLOG
#SQL BackTrack Stuff
DTBASE=/bmc/sqlbacktrack
export DTBASE
DT_OBACKTRACK_HOME=DTBASE/obacktrack
PATH=$PATH:$DTBASE/obacktrack/bin
export PATH
PATH=$PATH:/$OH/OPatch
export PATH
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64
export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt
export DSMI_LOG=/usr/tivoli/tsm/client/logs
Regards,
divroro12
-
So... /home/oracle/oraenv does not exists anymore?
What happened in between 8:58 AM and 11:13 AM ?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|