Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

newbie help urgent plzz??

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
can some one help me i installed oracle 8 i and when i run SQL it giving me error after i put password and user these are the errors

1: PROTOCOL ADAPTER ERROR
2: NO LISTNER



------------
please help me how to solve these problems???
 
Are you running ORacle 8i Server or Client? Sounds like you don't have the right information in your ORA files (TNSNAMES.ORA and/or SQLNET.ORA, listener.ora)- did you create a sample database or are you trying to connect to a remote db? Is there a DBA working with you? He/She should be able to get you the file information you need for your connectivity. Otherwise try using NetConfig ORacle tool. Check in Drive:\oracle\ora8i\network\admin\ for your ORA files. Also, if you are running a local db, you need to make sure your listener is up. Go to Services and look for a service named something like ORacleOrahomeTNSListener. It needs to be started (note it reads your listener.ora file so that must be there to work). If you are running OracleLite, you need to use LSNRCTL to start/stop it as it does not appear in your services menu. Hope that helps,
Kimberly
 
i didnt make any database or anything i just installed oracle 8i the new one and then i click on test so it giving me error no adapet protocol...or no listner can u help me like this

Adapter error:
how to solve pro


NO LISTNER error:
how to solve description goes here..


plz plz plz
 
i didnt make any database or anything i just installed oracle 8i the new one and then i click on test so it giving me error no adapet protocol...or no listner can u help me like this

Adapter error:
how to solve pro


NO LISTNER error:
how to solve description goes here..


plz plz plz
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top