Oracle 8.1.5 and 8.1.6 Problem... [message #8567] |
Sun, 31 August 2003 23:50 |
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 |
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 |
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 |
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.
|
|
|