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!

TCPS setup won't work

430004Feb 12 2005 — edited Apr 12 2006
Hello,

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2006
Added on Feb 12 2005
14 comments
12,643 views