Scenario: You have one Oracle database with 3 different SID for different purposes: DR (disaster recovery), UAT (User Acceptance Testing) and SIT (System Integration Testing). You are tasked to configure the Database to open one port for each of the SID to control access. Piece of cake, you will only need to edit two oracle configuration files to achieve it. Safar Ki Dua Mp3 Free Download more. Technical details: The following configuration has been tested on Oracle 10GR2 that was installed on AIX 5.3ML6. Assumptions: The three SID in the Oracle database are named DRDB, UATDB and SITDB. Host name (machine name) is ORACLEDB01 and Global Database name is ORACLEDB. We willl create 3 listeners with the following configuration: Listener name: LISTENER Port: 1521 (default listener port) SID: DRDB Listener name: LISTENER1 Port: 1522 SID: UATDB Listener name: LISTENER2 Port: 1523 SID: SITDB First of all, back up the two files in case we need to restore the original configuration.

The next step is to stop the running listener. Get into your oracle shell (for my case, I need to su - oracle) and stop the activated listener by typing lsnrctl stop. Now, you will need to located two files with the name tnsnames.ora and listener.ora. If you are using unix like me, you can type in: find / -name '*.ora' In my case, the relevant files are located at: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Next, edit tnsnames.ora and it should look something like this: # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

TNSNAMES. Ethical Issues In Business Donaldson 8th Edition. ORA is a SQL*Net configuration file that defines databases addresses for establishing connections to them. This file normally resides in the ORACLE HOME.