Printable View
:confused: 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,
:confused:
developer has its own tnsname file - you must modfy that
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.
hi! got the same problem here, but i dont know what i have to modify! plz help... thx
the tnsnames.ora file
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!
put in the entry for your database
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!
The same tnsnames.ora thing is happening to me, sqlplus runs but not forms/reports
then change the tnsnames.ora for developer just like the others did
i use net config Assistant of oracleDB set service_name as orcl
then i use net config Assistant of DevSuit set service_name as orcl Too
that make me go through this problem.
done..
i use net config Assistant of oracleDB set service_name as orcl
then i use net config Assistant of DevSuit set service_name as orcl Too
that make me go through this problem.
you're an idiotQuote:
Originally Posted by pdisease
Hi
I have the same issue. I modified the tnsnames.ora file. Im still getting the same error.
Pls help
It is possible that you don't have the same problem. Given that the original post is 6.5 years old, and the software has probably changed during that time. You should start by explaining exactly what you installed, what you are trying to get working, any errors that you might have received. You should definitely look for the alert log, since this will tell you the status of your database.Quote:
Originally Posted by Aishwarya
In any event you should not just hijack a dead thread and ask people to post on that thread. You should have started a new thread.