I created a New Database with name DBAsma on Win2000/8.1.6 It worked fine.
I changed the entries in TNSnames, and Listener for the New database and then I used SQL *Plus to login it woked even for both Databases.
This morning I started the Machine again and tried to login, but it gives me error from TNS .
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asmacomp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DBAsma)(C ID=(PROGRAM=C:\Documents and Settings\Administrator.ASMACOMP\Desktop\Ezsql.exe)(HOST=ASMACOMP)(USER=Administrator))))
TNS for 32-bit Windows: Version 18.104.22.168.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 22.214.171.124.0 - Production
Time: 16-MAY-2001 09:31:56
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
If I use Dos and set the Oracle_Sid=DBAsma and hen start Svrmgr and login as Internal it login to DBAsma.
In registry the Oracle_Sid = DBQais (Which is the Other Database) In services Listener is running Automatic.