can we connect developer 6i with oracle 10g

[hafizmzahid]

hi
i have install oracle 10 g on machince name rec and developer 6i on other machince name trn can some one told me that how i can establish a connection between developer 6i and oracle 10g
ok
thanks

[debasisdas]

Hi
hafizmzahid

Welcome to TSDN

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.
It will help Experts in the forum in solving/underestanding your problem in a better way.

[debasisdas]

I hope u know how to establish connection of Developer 6i with prior version of oracle.
The process is same.
In your case both the systems shopuld be in LAN and in the conection string passthe name of the database that u have created along with username and password. System /machine name not required.

[hafizmzahid]

sir
both systems are on line developer 6 configuration assistance is not working so i have to do it manuall so please help me. this developer can connect with oracel 8 locally or remotely but i want to connect develoer 6 with oracle 10g.
thanks for time and considration

[maoonbila]

Hi,

There are some things you need to consider.

1. both machines are on the network
2. Listener should be configured and listening/running
3. configure tns file on the machine having 10g Database
(TNS file name be configured using Oracle Network Utility or manually)
4. The the connectivity using the created TNS service on Database machine locally, if working then copy it to the machine with developer


1. Both Machines communication check
Machine A's Command Prompt
to check the local machine TCP/IP Configuration

C:\> ping machineA

Now check the communication status of second machine to first machine
C:\> ping machineB

2. Listener on Database Machine

Launch Command Prompt and invoke lsnrctl utility

C:\> lsnrctl

check the listener is running properly and on which port it is listening
LSNRCTL> services

if not running
LSNRCTL> start

3. As you have mentioned the Net services are not working on your Dev machine you can use the database's machine Oracle network services to create/configure TNS file on the database machine and then copy to the Dev machine's (Developer home\network\admin folder)

OR

Manually
the file located in Oracle Home\product\network\admin\tnsname.ora
you can add these entries to a TNS file,decide the tns service string(the connect string you need to provide for connection i.e. HOST)( (like I am just using o on system) anyway

o =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wks1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MYDB)
)
)

PROTOCOL is on which the Listener is configured
HOST machine name where your database resides
PORT on which port the listener is listening

Normally above mentioned PROTOCOL and PORT are the default configurations of an Oracle database servers since version 7.3

I hope it will help you out

take care

[debasisdas]

Do as suggested in the previous post.

Here with this i have attached a sample file for your reference.

U need to make changes to your TNSNAMES.ORA File accordingly.

Hope your problem is solved from this.