| Unkown Service Name [message #367875] |
Fri, 17 November 2000 12:31  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
