This content has been marked as final. Show 5 replies
May I get this solution as soon as possbile...
Its so urgent..!!!
I have installed oracle 10g and developer suite.. I am trying to create forms now.But its error out: TNS: could not resolve the connect identifier specified!!!
I forgot the Data base name.. How can I know the database name??
You will find the DB name in the listener.ora file in ORACLE_HOME..\product\..\serverNETWORK\ADMIN folder.
Look for something like DEFAULT_SERVICE_LISTENER = (XE). Here XE is the SID.
If you can connect to the database in SQLPlus or something similar then query the V$DATABASE view.
Search for TNsnames.ORa in your pc, then copy this file to where your forms default folder.
This will solve your issue
I didnot get. I tried both of the above two solutions...
Can you suggest me any other alternatives???
I want the database name which I am using?? I am unable to connect to SQL*PLUS also..
I have installed oracle 10g and developer suite..I'm sorry, but you are going to have be more specific as what you installed!
If you installed Oracle Database 10g Express Edition then it is not (by default) configured to allow a connection through SQL*Plus. It is primarily configured to open a connection through the "Go To Database Homepage" url/link in the Start Menu => Oracle Database 10g Express Edition => Go To Database Homepage. In order to connect to the database from SQL*Plus (which is included with Oracle Developer Suite 10g) you will need to run the Net Configuration Assistant to configure your TNSNAMES.ora and SQLNET.ora files. Go to Start Menu => Oracle - DevSuiteHome1 => Configuration and Migration Tools => Net Configuration Assistant to run the assistant. After you run the assistant, test to make sure can connect through SQL*Plus before you attempt to connect through Forms.
Hope this helps,