Skip to Main Content
Forums

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

oracle forms and report builder - tns issues

n2813Jun 4 2014 — edited Jun 7 2014

Dear all,

I have installed weblogic server (10.3.5) and oracle forms and report developer 11g as well.

The location of the weblogic middleware server is in C:\oracle\Middleware (This path also contains oracle 9i)

The forms and reports has been installed in C:\oracle\Middleware\Oracle_FRHome1

I am on windows xp 32 bit operating system

I am already using oracle 11g which is in

D:\app\user\product\11.2.0

My oracle is working fine both the 9i and 11g versions.

When i try to connect oracle using oracle forms and report i am unable to do so

I have already copied the tnsnames.ora of the 11g database and copied into my forms and report developer.

Still it says ORA- 12154 :TNS : could not resolve the correct identifier specified.

Am i missing something .

Experts please advice.

Thanks in Advance ...

Comments

sfr.farhan

Copy TNS file at following location and check.

C:\Oracle\Middleware\Oracle_FRHome1\network\admin\tnsnames.ora

C:\Oracle\Middleware\asinst_1\config\tnsnames.ora

n2813

Thanks Farhan

I have already done this .. But still the same error.

n2813

Any other suggestions please ..

andrewmy

Look for all the places where tnsnames.ora is located on your PC - do a file search from Windows.

Replace all of them with your latest one. One of them is directing the connection, if you get them all then it cant escape you.

You may have environment variables like TNS_ADMIN set in your system or registry

n2813

Had tried everything but still couldn't figure it out.

Paul M. 
ORA- 12154 :TNS : could not resolve the correct identifier specified.

This error is "local" to your Forms/Reports Home, that is a tnsnames.ora is not found where it should be, or there is some (syntax) error within it, or the connection string specified is not present in it.

My oracle is working fine both the 9i and 11g versions.

So you have 9i and 11g databases active on your machine ? Then I assume there is a 11g active listener, and both DBs are registered with it. To confirm this, post the result, from 11g DB Home, of

C:\>lsnrctl stat

Also post your tnsnames.ora.

Apart from what you've already done, and what suggested by others, did you try the Easy Connect Naming Method ?

1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2014
Added on Jun 4 2014
#forms, #moved-from-devops
6 comments
4,121 views