How? Connect from ORACLE Developer to ORACLE Database????

Hi ALL

H r u?

Just I'll write how you can connect ORACLE database with ORACLE Developer?

When u use SQL Plus and don't have any problem, and u wanna install developer(Forms & Reports), u cannot connect to the same Database.

The first:

You must have the same NLS_LANGUAGE in two home (DB, Dev).

How?

Go to Registry Editor: Start -> Run -> regedit ->

Search about "NLS_LANG" and change its value to "AMERICAN_AMERICA.AR8MSWIN1256" to you can write and retrieve Arabic, and search another time else "not found".

The second:

Search about file "tnsnames.ora", we will found more than one file.

You'll find it in

\NET80\ADMIN or

\NETWORK\ADMIN depend on ver.

= ORACLE Database Dir., or ORACLE Dev. Dir., or Another ORACLE ...

In this file will find statement like this:

1- ORA10 =

2- (DESCRIPTION = (ADDRESS_LIST =

3- (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))

4- )

5- (CONNECT_DATA =

6- (SERVICE_NAME=ORCL)

7- )

8- )

1-Connect string SID: use it to connect to database scott/tiger@ORA10 , you can write anything.

3-somehost : IP Address or computer name where have database.

6-Service_Name: name of database.

Add a copy of previous text and change some data and save it and try to connect to the database.

Note: Save Original file before you change.

If you want to connect from all ORACLE Application to the same database you will have the same content of " tnsnames.ora" file.

Each ORACLE Application have "tnsnames.ora" file.

In another version you will see another schema but the same concept, please try it and return me what the result.

Good Luck.