oraenv/dbhome/sqlplus errors
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: oraenv/dbhome/sqlplus errors

  1. #1
    Join Date
    Nov 2006
    Posts
    158

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Nov 2006
    Posts
    158
    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

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  5. #5
    Join Date
    Nov 2006
    Posts
    158
    I just checked my environmental variables & compared it with that of a similar system that's working perfectly; all looks good...
    Regards,

    divroro12

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  7. #7
    Join Date
    Nov 2006
    Posts
    158
    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

  8. #8
    Join Date
    Nov 2006
    Posts
    158
    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

  9. #9
    Join Date
    Nov 2006
    Posts
    158
    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

  10. #10
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
  •  


Click Here to Expand Forum to Full Width