Home » Infrastructure » Windows » Cannot connect to Database in Oracle 9i
Cannot connect to Database in Oracle 9i [message #101086] Fri, 23 April 2004 05:07 Go to next message
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

 
Re: Cannot connect to Database in Oracle 9i [message #101194 is a reply to message #101086] Tue, 15 June 2004 03:19 Go to previous messageGo to next message
zen
Messages: 3
Registered: June 2004
Junior Member
change SQLNET.AUTHENTICATION_SERVICES= (NTS)
to SQLNET.AUTHENTICATION_SERVICES= (NONE)
Re: Cannot connect to Database in Oracle 9i [message #101222 is a reply to message #101086] Thu, 24 June 2004 18:22 Go to previous message
Wendy
Messages: 4
Registered: April 2001
Junior Member
not sure what else you can do, but i had the same problem at school once and connected via terminal server and it worked.
Previous Topic: Database configuration assistant error: 9i on XP
Next Topic: ORA-012541 TNS No Listener
Goto Forum:
  


Current Time: Thu Mar 28 18:42:48 CDT 2024