Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 8.1.5 and 8.1.6 Problem...
Oracle 8.1.5 and 8.1.6 Problem... [message #8567] Sun, 31 August 2003 23:50 Go to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi experts,

Please help me.

I have installed Oracle Enterprise Edition 8.1.5 on a stand alone PC under windows 98. Installation has been done perfectly when I go for SQL by entering scott/tiger it is telling some times no adopter, some time NO Listener even I have given Service Name and Databse name configured Lisener and done everything. But still I could not able to get SQL prompt.

This is happening with Oracle Personel Edition 8.1.6 also the same. I tried by Admininstration, Programmer, Client and Custom. Still I could not able to solve the problem.

After installing is there any opetion to open database like in Oracle 8.0.

Please give the solution.....

I will be thankful.

Syed Muzzammil
Re: Oracle 8.1.5 and 8.1.6 Problem... [message #8575 is a reply to message #8567] Mon, 01 September 2003 05:19 Go to previous messageGo to next message
Gilbey
Messages: 87
Registered: March 2002
Member
Your net8 configuration was not successful.Just try to configure your net8 thru net8 configuration assistant utility which comes with oracle itself.
Try to find out whether ur listener has started or not by doing the follwing:
1]At command prompt type sqlplus
2]SQL> This will be shown to you.
3]Connect to internal/oracle
4]type lsnrctl and press enter
5]LSNRCTL> This will be shown to you
6]Then type status.This will give you the status of the listener.

Try to do the above and let me know as what is the problem you are getting now.

Gilbey
Re: Oracle 8.1.5 Problem... [message #8581 is a reply to message #8575] Mon, 01 September 2003 10:55 Go to previous messageGo to next message
Muzzammil
Messages: 99
Registered: February 2003
Member
Hi,

I have configured Net8 and Listener also

When I type sqlplus Ener user-name is comming

When I type internal/oracle its giving error as
ORA-12560: TNS:protocol adapter error

I tried to find the file lsnrctl in whole drives but I could not find.

I don'nt know whats happening, it is connecting well to the server database but not to local machine.

Please solve this problem..

Thanks

Syed Muzzammil
Re: Oracle 8.1.5 Problem... [message #8583 is a reply to message #8581] Mon, 01 September 2003 19:59 Go to previous message
ctg
Messages: 146
Registered: July 2002
Senior Member
c: SET ORACLE_SID=INSTANCE_NAME
c: sqlplus /nolog
SQL> connect internal/oracle

Also check in the services (under start->settings->control panel
look under services, you should have one called OracleServiceINSTANCENAME
make sure this service is started.
Previous Topic: getting previous commands on SQL prompt
Next Topic: Usage of max function
Goto Forum:
  


Current Time: Wed Apr 17 23:14:05 CDT 2024