Re: instant client RH EL 4.4 sqlplus
Date: Tue, 27 May 2008 13:49:15 -0700 (PDT)
On May 27, 4:38 am, kbloomfi..._at_yahoo.com wrote:
> Am trying to configure instant client 10_2 on RH EL 4.4.
> So have set LD_LIBRARY_PATH, PATH and ORACLE_HOME to the dir where the
> unzipped instant client lives.
> However cannot seem to connect to remote DB using sqlplus like so:
> sqlplus user/password_at_IPAddress:1521/FRED
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software
> But if I invoke sqlplus user/password_at_FRED on the remote box this
> works purfect.
> I guess I am missing something, but not being an expert I am not sure
> Anyone care to advise?
I'm wondering if your ipaddress is properly specified - put in two slashes after the @ sign?
Also, can you connect with the oracle style connection string like in
sqlplus user/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=ipaddress) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=FRED))) In the past I recall that I had trouble, then tried it again following the directions exactly, including putting the tnsnames.ora in the instant client directory, and it suddenly all worked. But that was a different version and platform.
-- @home.com is bogus. Welcome to California. Now go back to Chicago. http://www.signonsandiego.com/news/business/20080527-9999-1b27mega.html word: cainitteReceived on Tue May 27 2008 - 15:49:15 CDT