Hi ,
I have manually modified the file spfile.ora of Oracle10g v.2. After restarting the database service (control panel->windows service) whereas the database has been started successfully , i could not connect to it:
"ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
The same message is displayed also when i deleted the line i had added beforehand in the spfile.ora file.
Executing the lsnrctl program to see what's going on....
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date 25-JAN-2007 18:17:10
Uptime 0 days 0 hr. 1 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\oracle\product\10.2.0\database10g\network\admin\lis
tener.ora
Listener Log File C:\oracle\product\10.2.0\database10g\network\log\liste
ner.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
The listener supports no services
The command completed successfully
What should i do...????
Thanks , a lot
Simon