2006-06-18 06:57:18 · 2 answers · asked by zainul531 1 in Computers & Internet ➔ Programming & Design
The oracle listener on your unix box listens for connections to come in to a database on the unix box.
In order to configure your unix box as a client of a database on a windows box, you need to put an entry in the tnsnames.ora file that defines the location of that database. Hopefully, you already have an entry in that file can can simply copy it, change the host name, connection name, and database identifier (service name or sid), and maybe port if not 1521 .
A frequent problem when configuring a tnsnames entry is the tendency of oracle to put a 'domain name' in the front of the connection name. This must match the entry in the sqlnet.ora, if it is being used. Keep this format for your new entry, if so.
If your question is twisted, and you really want to configure your listener for listening, use netca . There is a link to all oracle documentation in my sources. You may have to register, but the site is free.
2006-06-19 02:24:25 · answer #1 · answered by oohhbother 7 · 0⤊ 0⤋
1. on unix server, set your database environment variables like ORACLE_HOME and ORACLE_SID
2. Modify $ORACLE_HOME/network/admin/listener.ora file with correct hostname and port number listener should listen to.
3. Start listener using lsnrctl utility
lsnrctl start
4. Add an entry in your windows desktop to tnsnames.ora file that point to database on unix
5. Connect to SQL*PLUS using connect string you just added.
2006-06-21 03:28:11 · answer #2 · answered by justboyfriend 1 · 0⤊ 0⤋