I have oracle database running on address xx.xx.xx.xx
I know login, password and initial catalog
I am trying to set up new connection in Oracle SQL Developer so I can access this database to take a look at it. In order to do that, I need to know SID or Service Name.
Long time ago I would run TNSPing.exe to get service name, but this program is not available any more. Oracle is not distributing it.
Is there a way to access this info somewhere?
'Cause you've said that you have "I know login, password and initial catalog". Then I said:
Get Oracle SID:
$ ps -ef | grep pmon
; (or$ cat /etc/oratab
- format:ORACLE_SID:ORACLE_HOME
)Get Service Name:
$ cat $ORACLE_HOME/network/admin/tnsnames.ora
. With tnsnames.ora format, you can cat SERVICE_NAMEIn order to execute tnsping, you can install Oracle Client appropriate to your machine.