Problem connecting to database, Plz help!!!

From: Paul <alienn_at_rocketmail.com>
Date: Thu, 28 Mar 2002 05:32:06 GMT
Message-ID: <qVxo8.20164$IN3.7247532_at_kent.svc.tds.net>

Hi All,
I have a problem connecting to a database from developer account (oradev) which has $ORACLE_HOME variable set to developer 6i home dir, however if I set $ORACLE_HOME to a Database home the connection works fine, but this way I can't start d6i forms/reports. I know that it's not a tnsnames problem. I've set $TNS_ADMIN to point to the tnsnames.ora from the Database path.
(Below you may find env. vars of oradev account and the error message from
sqlplus)
Any clue?

Thank you all in advance,

Paul

• from oraenv -------------------- ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/6i ORACLE_SID=ora1 CLASSPATH=.:/u01/app/oracle/product/9.0.1/jdbc/lib/classes111.zip:/u01/app/o racle/product/9.0.1/JRE:/u01/app/oracle/product/9.0.1/jlib:/u01/app/oracle/p roduct/9.0.1/rdbms/jlib:/u01/app/oracle/product/9.0.1/network/jlib LD_LIBRARY_PATH=.:/u01/app/oracle/product/9.0.1/lib:/u01/app/oracle/product/ 6i/lib:/lib:/usr/lib:/usr/local/lib ORA_NLS33= NLS_LANG=american ORACLE_TERM=xterm TNS_ADMIN=/u01/app/oracle/product/9.0.1/network/admin TWO_TASK=ora1 ORACLE_AUTOREG=/u01/app/oracle/product/6i/guicommon6/tk60/admin -----etc bashrc [oradev_at_localhost oradev]$ sqlplus scott/tiger_at_ora1 SP2-0642: SQL*Plus internal error state 2165, context 1804:0:0 Unable to proceed

SQL*Plus: Release 9.0.1.0.0 - Production on Wed Mar 27 22:50:14 2002

(c) Copyright 2001 Oracle Corporation. All rights reserved.

[oradev_at_localhost oradev]$

---

Received on Thu Mar 28 2002 - 06:32:06 CET