Home » Developer & Programmer » Forms » connect error (oracle 10g)
connect error [message #294345] Thu, 17 January 2008 05:07 Go to next message
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 129 times)
Re: connect error [message #294347 is a reply to message #294345] Thu, 17 January 2008 05:09 Go to previous messageGo to next message
farooq112
Messages: 90
Registered: September 2006
Location: cairo
Member
i forget file
  • Attachment: tnsnames.ora
    (Size: 0.32KB, Downloaded 163 times)
Re: connect error [message #294372 is a reply to message #294345] Thu, 17 January 2008 06:24 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Post the tnsnames.ora file with code format.
Re: connect error [message #294376 is a reply to message #294347] Thu, 17 January 2008 06:46 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
There is no tns entry for the sid /service_name orcl in the above uploaded file.

By
Vamsi
Re: connect error [message #294384 is a reply to message #294345] Thu, 17 January 2008 07:14 Go to previous messageGo to next message
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)
)
)

Re: connect error [message #294385 is a reply to message #294384] Thu, 17 January 2008 07:22 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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
Re: connect error [message #294387 is a reply to message #294345] Thu, 17 January 2008 07:35 Go to previous messageGo to next message
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
Re: connect error [message #294400 is a reply to message #294387] Thu, 17 January 2008 08:01 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
then?

By
Vamsi
Re: connect error [message #294436 is a reply to message #294345] Thu, 17 January 2008 11:24 Go to previous messageGo to next message
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)
)
)
Re: connect error [message #294509 is a reply to message #294345] Thu, 17 January 2008 18:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: connect error [message #294823 is a reply to message #294345] Sat, 19 January 2008 13:26 Go to previous message
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
Previous Topic: Migrate form 6i to form9i
Next Topic: D2KWUTIL.PLL make form slow to respond
Goto Forum:
  


Current Time: Mon Dec 05 21:23:03 CST 2016

Total time taken to generate the page: 0.11578 seconds