aspose file tools*
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
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: 1716
    
  14

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.
 
 
subject: Cannot connect to oracle 10g database server for first time through sqlplus