Home » RDBMS Server » Networking and Gateways » Unkown Service Name
Unkown Service Name [message #367875] Fri, 17 November 2000 12:31 Go to next message
Larry Ellison
Messages: 6
Registered: November 2000
Junior Member
Hi there!
I've got a software that places an Oracle database when installing. I would like to manage this DB via Java Server Pages (JSP), but I do not know the service name.

I've serched in the listener.ora, tsnames.ora and files like these, but the unique strange thing I find is: 'extproc'. There is no clue of my DB Oracle SID.

I am able to access the DB via SVRMGR (browsing users, tablenames, ...) because I know the SYSTEM USER name and password, and internal password too.

+) How could I access my DB via ODBC (or JDBC)?
+) Shall I be able to find my DB service name?

Thanks in advance,

=================
LARRY ELLISON
Re: Unkown Service Name [message #367896 is a reply to message #367875] Thu, 07 December 2000 13:24 Go to previous message
kavita
Messages: 7
Registered: November 2000
Junior Member
hi,

You can connect to db if you are making connection from the same machine without any entry in tnsnames.ora file.
Say, your server is Sun machine and client is installed on NT then, if you want to connect from NT there should be entry in tnsnames.ora file on NT. On server that is Sun machine listener should be started by making entries in listener.ora.

For ODBC connection.Make entry in tnsnames.ora file and use that service name.
eg : entry in tnsnames.ora
mydb=(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= test)(Port= 1521))
(CONNECT_DATA = (SID = ORCL))
)

Use this mydb while making ODBC connection.

Listener.ora file entry should be :
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= ORCL))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host=test )(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= test.)
(ORACLE_HOME= )
(SID_NAME = ORCL)
)

After saving this file.
lsnrctl start
this will start listener.
Previous Topic: Vulnerability in Listener.
Next Topic: Listener password
Goto Forum:
  


Current Time: Thu Mar 28 15:57:56 CDT 2024