8i/9i cross version sqlplus connection problem

From: Ulrich Gayer <ugayer_at_gmx.de>
Date: Tue, 29 Jul 2003 11:25:14 +0200
Message-ID: <bg5eib$l1hme$1@ID-12871.news.uni-berlin.de>

Hello,

I've got Oracle 8.1.7.4 and 9.2.0.2 installed on a HP-UX 11i box.

Two databases:

GEPJ4 (Oracle 9i)
GEPT4 (Oracle 8i)

My problem is that I don't manage to connect to the 9i db *without password* using a Oracle 8 sqlplus or vice versa. I use the Unix user "oracle", member of groups "oinstall" (primary group) and "dba" (secondary group)

Is this possible at all?

This works fine:

connect with Oracle 9 sqlplus to Oracle 9 db:

ORACLE_HOME=/db/oracle/product/9.2
SHLIB_PATH=$ORACLE_HOME/lib
ORACLE_BASE=/db/oracle
export ORACLE_HOME ORACLE_BASE SHLIB_PATH ORACLE_SID ORACLE_SID=GEPJ4
PATH=/usr/ccs/bin:/usr/bin:/usr/contrib/bin:$ORACLE_HOME/bin:/etc:/usr/local/bin sqlplus "/ as sysdba"

connect with Oracle 8 sqlplus to Oracle 8 db:

ORACLE_HOME=/db/oracle/product/8.1.7
SHLIB_PATH=$ORACLE_HOME/lib
ORACLE_BASE=/db/oracle
export ORACLE_HOME ORACLE_BASE SHLIB_PATH ORACLE_SID ORACLE_SID=GEPT4
PATH=/usr/ccs/bin:/usr/bin:/usr/contrib/bin:$ORACLE_HOME/bin:/etc:/usr/local/bin sqlplus "/ as sysdba"

This does *not* work:

connect with Oracle 9 sqlplus to Oracle 8 db:

ORACLE_HOME=/db/oracle/product/9.2
SHLIB_PATH=$ORACLE_HOME/lib
ORACLE_BASE=/db/oracle
export ORACLE_HOME ORACLE_BASE SHLIB_PATH ORACLE_SID ORACLE_SID=GEPT4
PATH=/usr/ccs/bin:/usr/bin:/usr/contrib/bin:$ORACLE_HOME/bin:/etc:/usr/local/bin sqlplus "/ as sysdba"
"Connected to an idle instance."

connect with Oracle 8 sqlplus to Oracle 9 db:

ORACLE_HOME=/db/oracle/product/8.1.7
SHLIB_PATH=$ORACLE_HOME/lib
ORACLE_BASE=/db/oracle
export ORACLE_HOME ORACLE_BASE SHLIB_PATH ORACLE_SID ORACLE_SID=GEPJ4
PATH=/usr/ccs/bin:/usr/bin:/usr/contrib/bin:$ORACLE_HOME/bin:/etc:/usr/local/bin sqlplus "/ as sysdba"
"Connected to an idle instance."

Other symptoms:

sqlplus "system/xxxx_at_GEPJ4" works using Oracle 8 sqlplus sqlplus "system/xxxx_at_GEPT4" works using Oracle 9 sqlplus

but

sqlplus "system/xxxx"
ORA-27101: shared memory realm does not exist HP-UX Error: 2: No such file or directory

and

sqlplus "/@GEPJ4 as sysdba"
ORA-01031: insufficient privileges
(Probaby a nonsense syntax at all)

listener.ora:

     (SID_DESC =


       (GLOBAL_DBNAME = GEPJ4.foo.bar)

       (ORACLE_HOME = /db/oracle/product/9.2)

       (SID_NAME = GEPJ4)

     )
     (SID_DESC =


       (GLOBAL_DBNAME = GEPT4.foo.bar)

       (ORACLE_HOME = /db/oracle/product/8.1.7)

       (SID_NAME = GEPT4)

     )

tnsnames.ora:
GEPT4 =
(DESCRIPTION =

     (ADDRESS_LIST =


       (ADDRESS = (PROTOCOL = TCP)(HOST = foohost)(PORT = 1521))

     )
     (CONNECT_DATA =


       (SID = GEPT4)

       (SERVICE_NAME = GEPT4.foo.bar)

       (ORACLE_HOME = /db/oracle/product/8.1.7)

     )

)

GEPJ4 =
(DESCRIPTION =

     (ADDRESS_LIST =


       (ADDRESS = (PROTOCOL = TCP)(HOST = foohost)(PORT = 1521))

     )
     (CONNECT_DATA =


       (SERVER = DEDICATED)

       (SID = GEPJ4)

       (SERVICE_NAME = GEPJ4.foo.bar)

       (ORACLE_HOME = /db/oracle/product/9.2)

     )

)

Any idea?

Ulrich Received on Tue Jul 29 2003 - 04:25:14 CDT