Thread: ORA-28547 on oracle 10g/solaris9/sun cluster


Permlink Replies: 2 - Pages: 1 - Last Post: Dec 7, 2004 1:30 AM Last Post By: dinotoa
dinotoa

Posts: 12
Registered: 10/08/98
ORA-28547 on oracle 10g/solaris9/sun cluster
Posted: Dec 6, 2004 12:43 PM
Click to report abuse...   Click to reply to this thread Reply
I get an error ORA-28547 each time I try to connect to the running instance of from a host different than the one oracle is running on.
The listener.ora is as follows:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = IMA)
(ORACLE_HOME = /opt/oracle/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-lh)(PORT = 1521))
)
)
)

the tnsnames.ora:

IMA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-lh)(PORT = 1521))
(CONNECT_DATA =
# (SERVER = DEDICATED)
# (SERVICE_NAME = IMA)
(SID = IMA)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

and the sqlnet.ora:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

any idea of what's wrong? A ps -ef reports this process running:

oracleIMA (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

can PROTOCOL=beq be the cause of the mess?
Please help!!
Thanks in advance
oradba

Posts: 7,814
Registered: 09/15/00
Re: ORA-28547 on oracle 10g/solaris9/sun cluster
Posted: Dec 6, 2004 1:34 PM   in response to: dinotoa in response to: dinotoa
Click to report abuse...   Click to reply to this thread Reply
In the block
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = IMA)
(ORACLE_HOME = /opt/oracle/app/oracle/product/10.1.0/db_1)
(PROGRAM = extproc)
)
)

you have to remove line (PROGRAM = extproc)

This line belongs to an external procedure call, not to a database instance, here's a simple example:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\server)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = Oracle.wkawollek.de)
(ORACLE_HOME = C:\Oracle\Server)
(SID_NAME = ORACLE)
)
)
dinotoa

Posts: 12
Registered: 10/08/98
Re: ORA-28547 on oracle 10g/solaris9/sun cluster
Posted: Dec 7, 2004 1:30 AM   in response to: oradba in response to: oradba
Click to report abuse...   Click to reply to this thread Reply
Thank you very much, it works now!!
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums