Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Running SQLPLUS without ORACLE DB
sgtpepper
post Jun 6 2012, 10:28 AM
Post #1


Newbie
*

Group: Possible Spammers
Posts: 1
Joined: 6-June 12
Member No.: 47,273



Hallo,

this may be a simple questions but I am not a DBA administrator but rather a penetration tester. I have installed an Express edition of Oracle 11 database on one host (Windows 7) and want to access to from another host (Backtrack Linux based on Debian) from SQL*PLUS Instant client.

While I managed to resolve multiple issues with shared libraries, I am still not able to run the sqlplus command as Oracle. I get the following errors:
oracle@evil:~/instantclient$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly


I followed the installation manual by Oracle and also created Oracle user with 2 env. variables set to:
LD_LIBRARY_PATH=/opt/Oracle/instantclient/lib
ORACLE_HOME=/opt/Oracle

Note that I only installed SQPLUS client on Linux and there is no DB running. The version of sqlplus is 11.2.0.3.0

On different forums people advised to set other variables according to the DB installed but I have none.
All I want is to run sqlplus with the IP address, SID, port and username.

Is it feasible to have only SQL*PLUS client installed or am I still missing something else?

Thanks for any hints.


Go to the top of the page
 
+Quote Post
burleson
post Jun 6 2012, 01:04 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,544
Joined: 26-January 04
Member No.: 13



Hi,


SP2-1503: Unable to initialize Oracle call interface

Cause: Indicates a library used by SQL*Plus to communicate with the database failed to initialize correctly.

Action: Check that the Oracle environment or registry entries are consistent and correct. If using the SQL*Plus Instant Client make sure the SQL*Plus and Oracle libraries are from the same release. Make sure you have read access to the libraries.

http://www.dba-oracle.com/t_sp_1503_unable...l_interface.htm

*************************************************
>> Express edition of Oracle 11 database on one host (Windows 7)

Verify that the Oracle service and the Oracle listener processes are running.

You should see an oracle.exe process from the Windows server.

Before you try accessing Oracle from a client, try accessing Oracle from the server itself.

You can invoke sqlplus directly from the macghine where Oracle resides.


Get that working first!


Also, try these steps:

http://www.dba-oracle.com/t_troubleshootin...vity_errors.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 2nd October 2014 - 05:23 AM