Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2008
    Posts
    27

    Unanswered: 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
    Regards,

    divroro12

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Looks like a corrupt dbhome file.

    There is a syntax error at line 4 in dbhome and your ORACLE_HOME is not being set which in turn means your PATH isn't set properly and the system cannot find sqlplus.

    .

  3. #3
    Join Date
    Jan 2008
    Posts
    27
    Exactly; i finally figured out the numerous issues in the dbhome file.
    Thanks...
    Regards,

    divroro12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •