TCPS setup won't work
430004Feb 12 2005 — edited Apr 12 2006Hello,
I am running a Oralce 9i Database and I am trying to setup, that my client (I just have one client because I am studying for the OCP) connects to the database via TCPS.
So I set up my listener to "speak" TCPS:
TNSLSNR for Linux: Version 9.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/9.2.0.x/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/9.2.0.x/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dbserver)(PORT=2484)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.1.0 - Production
Start Date 10-FEB-2005 20:18:51
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /u01/app/oracle/product/9.2.0.x/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/9.2.0.x/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dbserver)(PORT=2484)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "db01" has 1 instance(s).
Instance "db01", status UNKNOWN, has 1 handler(s) for this service...
Ok and I set up the tnsnames.ora file on the client this way:
DB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = dbserver)(PORT = 2484))
)
(CONNECT_DATA =
(SERVICE_NAME = db01)
)
)
If I am trying to connect to the db "db01" then I get the following error.[No firewall between the client and the database. I also have performed a complete installation of the Oracle software on the client and the server.[/b]
Error:
ORA_28759:Failed to open file
[b]I also get the error when I am using sqlplus when I am running sqlplus on the server and want to connect to the db "db01".
I have looked here in the forum and also in the Internet but it seems like that I am pretty much the onliest one which is having this problem.