Link to home
Start Free TrialLog in
Avatar of yitz99
yitz99

asked on

ora-12541: TNS:no listener

I hate it when I can't get anyone to listen to me, but that is never a problem here at EE.

As practice for the Arch and Admin exam, I created a new database on my local system by the name of 'yitz'.  Now I can't seem to connect to 'yitz' or to 'school', as I get this error.

What is it?  How do I solve it??

Avatar of yitz99
yitz99

ASKER

I can connect as system/manager without specifying the name of the service.

The service 'OracleOraHome81TNSListener' cannot startup from the windows services window.

If I attempt to start from the 'lsnrctl' console, it returns:
System parameter file is C:\oracle\ora81\network\admin\listener.ora
Log messages written to C:\oracle\ora81\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPR
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C11U20.jccopenu.ac
ORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C11U20.jccopenu.ac
ORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []
Avatar of yitz99
yitz99

ASKER

I can connect as system/manager without specifying the name of the service.

The service 'OracleOraHome81TNSListener' cannot startup from the windows services window.

If I attempt to start from the 'lsnrctl' console, it returns:
System parameter file is C:\oracle\ora81\network\admin\listener.ora
Log messages written to C:\oracle\ora81\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPR
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C11U20.jccopenu.ac
ORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C11U20.jccopenu.ac
ORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
NL-00051: internal error code, arguments: [302], [1], [], [], [], [], []
Avatar of Printaporn
Printaporn
Hi yitz99,

I think you have syntax problem in your listener.ora.
try copy it from sample file.

HTH
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image
I agree, please post the listener.ora file
Avatar of Intikhab
Intikhab
Hi
R u sure ur database is completly created.
and Ur SID Name is yitz.
try to rem #sqlnet.authentication_services=(NTS) from sqlnet.ora file.

file path c:/Oracle_home/Network/admin/sqlnet.ora

then execute lsnrctl start from command line.
or install agin net8 services.
before intalling rem #sqlnet.authentication_services=(NTS) from sqlnet.ora file.

i think it will help u

IA.


ASKER CERTIFIED SOLUTION
Avatar of Intikhab
Intikhab
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yitz99
yitz99

ASKER

I suppose you could have shortened the answer to RTFM.

Stay healthy!