OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA-12514

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-12514 [message #53851]

Tue, 15 October 2002 01:21

Rob
Messages: 70
Registered: January 2000

Member

I have installed Oracle 8.1.7 Enterprise edition on a Windows 2000 server.

When I'm attempting to set up the connection to the database via Net8 Configuration Assistant and then attempting to test I keep getting...

Connecting...ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
The test did not succeed.

Some of the information you provided may be incorrect.
Press Back to review the information provided for net service name, or Change Login to change username.

The service name and server are correct, I can verify the service name by what is in the init.ora file.

I'm not sure what else I can check to see if a problem lies somewhere ? any help would be appreciated.

Report message to a moderator

Re: ORA-12514 [message #53853 is a reply to message #53851]

Tue, 15 October 2002 02:06

shine_noor
Messages: 2
Registered: October 2002

Junior Member

Hello,

Did you check that your listener is started ? Your file listener.ora (under $ORACLE_HOME/network/admin) is OK ? your tnsnames.ora file is OK ...

Hope his helps

NOOR...
http://www.islamway.com/eng/html/invitation.php

Report message to a moderator

Re: ORA-12514 [message #54978 is a reply to message #53851]

Sat, 21 December 2002 16:16

Lee
Messages: 56
Registered: May 1999

Member

I trying to retrieve text for error ORA-12514 in adodb-oci8.inc.php on line 114 and I cannot connect to DEMO.

Report message to a moderator

Re: ORA-12514 [message #55911 is a reply to message #53851]

Mon, 24 February 2003 04:56

Gunjan
Messages: 1
Registered: February 2003

Junior Member

TNS-Listner colud not resolve service_name given in connect descriptor

Report message to a moderator

Re: ORA-12514 [message #125931 is a reply to message #53851]

Thu, 30 June 2005 00:52

dawnb
Messages: 1
Registered: June 2005

Junior Member

Could you please rename the file E:\oracle\ora81\network\ADMIN\sqlnet.ora and then try again?

Good luck!

Report message to a moderator

Re: ORA-12514 [message #125933 is a reply to message #125931]

Thu, 30 June 2005 00:56

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI Dawnb

I hv a query... how this renaming of sqlnet.ors file going to help in this case?
Pls elaborate a bit on same....

Regds
Girish

Report message to a moderator

Re: ORA-12514 [message #126115 is a reply to message #53851]

Fri, 01 July 2005 01:45

rodionov
Messages: 6
Registered: June 2005

Junior Member

check and try to recreate your Locat net service name, naming methods, listener configuration.

Also try to use tnsping utility from windows command line. Here it's format:

tnsping <instance name>

Report message to a moderator

Previous Topic:	revoking privieleges from public
Next Topic:	ORA-04067 error when exporting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 07:17:05 CST 2025