wood burning stoves*
The moose likes JDBC and the fly likes Cannot connect to oracle 10g database server for first time through sqlplus Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Cannot connect to oracle 10g database server for first time through sqlplus" Watch "Cannot connect to oracle 10g database server for first time through sqlplus" New topic
Author

Cannot connect to oracle 10g database server for first time through sqlplus

Vinod Vijay
Ranch Hand

Joined: Sep 13, 2011
Posts: 137

Hi, I have installed oracle 10g db server on my laptop. Whenever I start my laptop and try to connect to my database, it does not get connected. I tried through oracle sql plus and even through command prompt by opening sql client by sqlplus/ command. I get following error message:-

C:\Users\Rajiv>sqlplus/
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly


To work with my db, everytime I need to connect through isqlplus first on browser. On iSQLPlus, I can get connect easily. Once I do intialization there on iSQLPlus then I can go back to Oracle sqlplus or through on command prompt and it works. I think some small issue would be there, some loading of library or some connection which iSQLPlus can make but not rest and once iSQLPlus does then that 'something' remains there until I turn off my computer.

Any idea my friends


Vinod Vijay Nair
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1621
    
  13

You might want to search on the Oracle TechNet for this error message e.g. the last few posts under this thread may be relevant.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Cannot connect to oracle 10g database server for first time through sqlplus
 
Similar Threads
java.sql.SQLException: Io exception: The Network Adapter could not establish the conn
how to start oracle from command line
Unable to establish a network connection
SP2-1503 SP2-0152 SQL*Plus and Microsoft Vista
accept command in .sql file not working from ant