Oracle Database Discussions

Hi,

I have Oracle 112.0.3 running on Linux 5.5

but when application trying to launch it is getting ORA 28575 message for unable to open RPC i have following tns and listner.ocr:

listener.ora:
l
istener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = servername)(PORT = 1521))
)
)


SID_LIST_LISTENER =
(SID_LIST =

(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/orapl10/ORA10G)
(PROGRAM = extproc)
(ENVS=EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/orahome/lib:/apps/im201
2/arcsde10/sdeexe100/lib)
)

(SID_DESC =
(GLOBAL_DBNAME = test1)
(ORACLE_HOME = /orahome)
(SID_NAME = test1)
)
(SID_DESC =
(GLOBAL_DBNAME = test2)
(ORACLE_HOME = /orahome)
(SID_NAME = test2)
)

(SID_DESC =
(GLOBAL_DBNAME = test3)
(ORACLE_HOME = /orahome)
(SID_NAME = test3)
)

)


ADR_BASE_LISTENER = //base


tnsnames:
tnsnames.ora
# Generated by Oracle configuration tools.

test1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
)
)

test2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test2)
)
)

test3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test3)
)
)

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



please help