Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28547: connection to server failed, probable Net8 admin error

427828Dec 15 2006 — edited Mar 2 2007
Hi 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....
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2007
Added on Dec 15 2006
6 comments
1,730 views