| Cannot connect to Database in Oracle 9i [message #101086] |
Fri, 23 April 2004 05:07  |
Dillon
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
I am using Oracle 9i Developer on Windows XP Professional and experiencing some problems connecting to the database in Forms Builder. I have no problems connecting to SQL*Plus but when i m using FORMS BUILDER and i tried to connect, I specified my database as 'orcl' and it prompted me this error msg. "ORA-12514. TNS:Listerner could not resolve SERVICE_NAME given in connect descriptor." Please Help as i have an assignment due next week!
i also have Oracle 9i Personal database installed on my machine and in their directories too, there are another set of sqlnet.ora, tnsnames.ora & listener.ora files. do i have to edit those as well?
I have included sqlnet.ora, tnsnames.ora & listener.ora
# SQLNET.ORA Network Configuration File: C:OracleOradevNETWORKADMINsqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
TRACE_LEVEL_CLIENT = USER
# TNSNAMES.ORA Network Configuration File: C:OracleOradevNETWORKADMINtnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
# LISTENER.ORA Network Configuration File: C:OracleOradevNETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:OracleOradev)
(PROGRAM = extproc)
)
)
TRACE_LEVEL_LISTENER = USER
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
