ORA-28547: connection to server failed, probable Net8 admin error
427828Dec 15 2006 — edited Mar 2 2007Hi all. I use Oracle 10G. My listener.ora is below
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.26)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = sened)
(ORACLE_HOME = C:\Oracle\OraHome)
(PROGRAM = extproc)
)
)
I have database with name sened
And my tnsnames is below:
SENED =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.26)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sened)
)
)
When I start Windows, I can enter as sysdba . But when I issue "shutdown immediate", after that I can't connect as sys. And get this error:
ORA-28547: connection to server failed, probable Net8 admin error
And I stop my listener the I start it, it gives error:
SQL> host lsnrctl start
Service "sened" has 1 instance(s).
Instance "sened", status UNKNOWN, has 1 handler(s) for this service...
Why my database's status is UNKNOWN??
Thanks....