sqlplus dos not work with <SID>adm

[Fugla]

Hi
I get the following error when I try to connect to the database.
at-yx-sap02:u02adm 7> sqlplus

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 20 09:14:35 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter user-name: system/manager
Could not load program oracleU02:
Dependent module libjox10.a(shr.o) could not be loaded.
Could not load module libjox10.a(shr.o).
System error: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

But if I try to connect via sqlnnet it works.
at-yx-sap02:u02adm 9> sqlplus system@U02

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Nov 20 09:20:15 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options

Does anybody know why I got this problem.
My problem is that I can not run jos from DB13 in SAP.

 

[LKBrwnDBA]

Incorrect version of Oracle Home?


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Fugla]

Hi
I have checked Oracle home and it looks ok. otherwise I would not be able to log on with "sqlplus system@U02"!

Why can I connect to the databas with command "sqlplus system@U02" and not "sqlplus system"?

Does anybody know ?

 

[SantaMufasa]

Fugla,

I'm guessing that you are running under some form of *nix operating system, right?

If true, could you please post the contents of these items:[ul][li]$ORACLE_HOME[/li][li]$ORACLE_SID[/li][li]$LOCAL[/li][li]The contents of "/etc/oratab"[/li][li]The entries for "U02" from your tnsnames.ora file[/li][li]The results of your doing a "status" command from within Oracle's "lsnrctl" utility[/li][/ul]

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”

 

[hoinz]

It seems you are working with an ERP system from SAP.

Simple answer in this case:
sqlplus is not supposed to work with user <sid>adm.
Try user ora<sid> instead.

 

[Fugla]

Hi
Yes it is a SAP system and I'm not able to run backup or DBcheck from DB13.

 

[hoinz]

In this case you better had asked in SAP forum, but anyway:

Most probably permissions (owner and s-bit) of your brbackup and brconnect programs are not set properly.
Owner should be ora<sid>, and permissions like rwsrwxr-x.
Have a look at SAP note 113747, btw.

hope this helps