Re: How can I know my "Host:Port:Sid"

From: Huaping Luo <huaping_at_pollux.cs.uga.edu>
Date: 12 May 1998 17:29:04 GMT
Message-ID: <6ja0t0$bkk$1@cronkite.cc.uga.edu>

In article <355798f9.8521623_at_newshost.us.oracle.com>, guile_at_escape.com says...
>
>On 11 May 1998 22:53:46 GMT, huaping_at_pollux.cs.uga.edu (Huaping Luo)
>wrote:
>
>>I have a Oracle database.Recently, I want to connect to my Oracle database
>>through JDBC thin driver (v7.34). However, if I use the JDBC thin driver,
>>I must provide "Host:Port:Sid". How can I know my port number and sid number
>>because my current system administrator doesn't know them. The system administrator
>>who installed ORACLE has left for other job.
>>
>>Please help.
>>
>>Thanks in anticipation.
>>
>> Huaping Luo
>>
>
>Look in your $ORACLE_HOME/network/admin/listener.ora file.

Thanks for your help, but I still have some troubles in figuring out the port number. Is port number= IPC or 33EA1F7011CF8A6B ?

Any help will be extremely appreciated.

Here is the file "listener.ora"

---

LISTENER=
 (ADDRESS_LIST=
  (ADDRESS=
   (PROTOCOL=IPC)
     (KEY=sid1)
  )
 )

STARTUP_WAIT_TIME-LISTENER=0
CONNECT_TIMEOUT-LISTENER=10 SID_LIST_LISTENER=
 (SID_LIST=
   (SID_DESC=

     (SID_NAME=sid1)
     (ORACLE_HOME=/oracle)

   )
 )

TRACE_LEVEL_LISTENER = OFF
PASSWORD_LISTENER = (33EA1F7011CF8A6B) OPS_DOLLAR_LOGIN_ALLOWED

---

  Received on Tue May 12 1998 - 12:29:04 CDT