ORA-03113 when connecting NOT via tns alias

[JtheRipper]

Hi there,

I am receiving the dreaded ORA-03113 error when I try to connect to my database as user A as follows:
. oraenv MYDB
sqlplus "usr/pwd"

but when I connect as follows:
sqlplus "usr/pwd@MYDB"
I can connect to the database.

As the ORACLE user I can connect to the database using both methods mentioned above.

Any ideas on what might cause this problem?

Thanks,
J.

 

[SantaMufasa]

J,

Since you didn't mention, I am presuming that you are trying to connect to an instance on a Unix platform. If that is the case, could you please post the results for the following Unix commands:

echo $ORACLE_HOME
echo $ORACLE_SID

(if Solaris): cat /var/opt/oracle/oratab
(all others): cat /etc/oratab

Hopefully, we will get to the bottom of this.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[JtheRipper]

Hi,

Sorry for not giving enough info...

Yes, it is on a Solaris platform.
Here is the information you requested:

echo $ORACLE_HOME
/app1/oracle/product/817std

echo $ORACLE_SID
spunchem

cat /var/opt/oracle/oratab
spunchem:/app1/oracle/product/817std:Y
gulf:/app1/oracle/product/817std:Y
volcano:/app1/oracle/product/817std:Y
*:/app1/oracle/product/9.2.0:N
rmandb:/app1/oracle/product/817std:Y
test:/app1/oracle/product/817std:Y

I found a funny "workaround" last night for this, if I set the TWO_TASK variable = to ORACLE_SID, then everything works. But it is more of a workaround to me than a solution so any more ideas will be appreciated.

Thanks,
J.

 

[JtheRipper]

Hi,

I managed to sort out this problem by relinking the oracle executable.

Thanks for the interest in this thread.

J.

 

[SantaMufasa]

Thanks, J, for the update...that is a fascinating resolution that I wouldn't have thought of.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.