Rep-0501 / Ora-12154

[khoshtip_uk]

I HAVE INSTALLED ORACLE DEVELOPER SUITE, AND TRYING TO CONNECT TO MY DATABASE THROUGH ORACLE FORM / AND REPORT BUILDER BOTH OF THEM !! BUT EVERYTIME I GET ERROR:
REP-501 UNABLE TO CONNECT TO SPECIFIED DATABASE
ORA-12154 TNS:COULD NOT RESOLVE THE CONNECT IDENTIFIER SPECIFIED,

NOTE MY DATABASE IS UP AND RUNNING AND IM ABLE TO CONNECT TO IT THROUGH SQL*PLUS,
BOTH THE DATABASE AND DEVELOPER SUITE ARE INSTALLED ON THE SAME MACHINE,

[davey23uk]

developer has its own tnsname file - you must modfy that

[khoshtip_uk]

ok its done, im connected,

Can someone recommend me some well presented,easy and straight forward tutorial for oracle developer(form/report) and Discovery, im oracle dba and have good undrestanding of oracle back end but need to get use to those tools asap.

[cuarticox]

hi! got the same problem here, but i dont know what i have to modify! plz help... thx

[davey23uk]

the tnsnames.ora file

[cuarticox]

yeap, but i don't know what to modify there, i have this:

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = whatever) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)

thx!

[davey23uk]

put in the entry for your database

[cuarticox]

DONE!!! thx man! i had N problems with this, got oracle enterprise 11g and developer suite 10g on VISTA =s now i only have the problem that everyone has with the error "the nmefwmi.exe stopped working adn was closed" gotta wait for an update... Thx again!!! at least have my DB connected!

[gencom1]

The same tnsnames.ora thing is happening to me, sqlplus runs but not forms/reports

[davey23uk]

then change the tnsnames.ora for developer just like the others did