Help - Search - Members - Calendar
Full Version: Running SQLPLUS without ORACLE DB
Oracle DBA Forums > Oracle > Oracle Forum
sgtpepper
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.


burleson
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.