OraFAQ Forum: Forms » connect error

Home » Developer & Programmer » Forms » connect error (oracle 10g)

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

connect error [message #294345]

Thu, 17 January 2008 05:07

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

hi everyone

i need help

when connect form orcle

show message ora-12154:tns:could not resolve service name

same one tel me edite file could tnsname but
i dont know what con i do this file

pls check my attach

Attachment: trible.JPG
(Size: 82.47KB, Downloaded 524 times)

Report message to a moderator

Re: connect error [message #294347 is a reply to message #294345]

Thu, 17 January 2008 05:09

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

i forget file

Attachment: tnsnames.ora
(Size: 0.32KB, Downloaded 977 times)

Report message to a moderator

Re: connect error [message #294372 is a reply to message #294345]

Thu, 17 January 2008 06:24

varu123
Messages: 754
Registered: October 2007

Senior Member

Post the tnsnames.ora file with code format.

Report message to a moderator

Re: connect error [message #294376 is a reply to message #294347]

Thu, 17 January 2008 06:46

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

There is no tns entry for the sid /service_name orcl in the above uploaded file.

By
Vamsi

Report message to a moderator

Re: connect error [message #294384 is a reply to message #294345]

Thu, 17 January 2008 07:14

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

hi varu123 and vamsi kasina
thank u for replay my topic
now
this cod file TNSNAMES.ORA tele me no what can i do

not
my database name orcl
and user name scott

# TNSNAMES.ORA Network Configuration File: D:\oracledvd\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
)

Report message to a moderator

Re: connect error [message #294385 is a reply to message #294384]

Thu, 17 January 2008 07:22

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Replace the current entry.
or
copy paste and entry and change it.
or
ask your dba for the tns entry
or
if you have unix box access, then type the command "tnsping orcl"

I think your sid might be orcl. What is your hostname and port?

By
Vamsi

Report message to a moderator

Re: connect error [message #294387 is a reply to message #294345]

Thu, 17 January 2008 07:35

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

thank you man

me name host = farooq

and about databse this databdase oracle dufalt name orcl

i used windows

Report message to a moderator

Re: connect error [message #294400 is a reply to message #294387]

Thu, 17 January 2008 08:01

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

then?

By
Vamsi

Report message to a moderator

Re: connect error [message #294436 is a reply to message #294345]

Thu, 17 January 2008 11:24

varu123
Messages: 754
Registered: October 2007

Senior Member

if your database is on the same machine,whats the need to give database name.
just give username and password.
or
add the following at top of your tnsnames.ora file

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = orcl)
)
)

Report message to a moderator

Re: connect error [message #294509 is a reply to message #294345]

Thu, 17 January 2008 18:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'tnsnames' and you will find that the general wisdon is to effectively use only one 'tnsnames.ora' file. Either by having all others point to the first via an 'ifile' entry or by use the environment variable 'TNS_ADMIN' to point to the 'active' 'tnsnames.ora' file.

David

Report message to a moderator

Re: connect error [message #294823 is a reply to message #294345]

Sat, 19 January 2008 13:26

farooq112
Messages: 90
Registered: September 2006
Location: cairo

Member

really many thanks my frinds

David and vamsi kasina and vamsi kasina and varu123

i do

thanks man

Report message to a moderator

Previous Topic:	Migrate form 6i to form9i
Next Topic:	Migration from forms CUI to 10gDS GUI.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 00:14:47 CST 2025