Connecting to Oracle database

UNIX Solaris
1

Hi guys, long time no typing :smiley:

I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box.
Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I want to connect to database from Windows box I get ORA-12505 erroe (listener rejected connection). I enter correct parametars, one guy raccomanded me to use TSA channel but I don't know how to setup that channel or even basic Oracle database administration. I'm not DBA :stuck_out_tongue:

Does anyone know how to access database ?

Thanks

All best for holidays

2

Check your tnsnames.ora file in Windows and verify if the entry is present for the Oracle Database that your are trying to connect. You can compare the TNS entry in Windows with the one in local. Make necessary change if any. Once done check if you can successfully tnsping to the DB instance from Windows.

1 Like
3

Thanks