Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can start sqlplus from another user than oracle

Status
Not open for further replies.

marco17

IS-IT--Management
Oct 23, 2006
28
FR
Hi !

I'm trying to setting up a development system on AIX 5.3.

I'v backup/restore oracle distrib (10.1.0.5) and databases.

Witch the oracle user i can connect with sqlplus system/manager. But with and another user i can't.
i've got this messages
Could not load program oracleDBREFNL:
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

The user i try to work with belongs to the unix DBA group
LIBPATH and LD_LIBRARY_PATH are set to ORACLE_HOME/lib

I can read and touch the libjox10.a file witch this user.

oracle exe have a sticky bit on user and group.

I already compare the environement of oracle user and environment of this user ( comparing the result of env command) whitout any result.

If i try sqlplus system/manger@SID it works fine.

What else can i look at ?

Any idea appreciated, is getting me crazy...
 
Solved yesterday.
ldd command tells me why it doesn't works !
On each of our productions systems
oracle is installed under /<host name>/oracle/.....
and there is a link /oracle -> /<host name>/oracle
We never use the real path but we use the path given by the link (/oracle/... ) for ORACLE_HOME, ORACLE_BASE, etc ...
But for one distribution the initial install has been done using the real path.
ldd $ORACLE_HOME/bin/oracle on the production system shows that oracle use a library knowne as /<host name>/oracle/...
So it doesn't work when we copy this distribution on, another system.



 
but it works when being connected with the oracle user.
And i don't know why... ;)
Anyway, now it works with all users :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top