Network, Oracle

Changing Listener Port Number for Database Connection Requests

To change the listener port number for database connection requests to 1522:To change the listener port number for database connection requests to 1522:
Stop the listener.
See “Stopping and Starting the Listener” for instructions.
Open the file listener.ora with a text editor.
Table: Location of the listener.ora File shows the location of this file on each platform.
Location of the listener.ora File
Platform LocationLinux
cd $ORACLE_HOME/network/admin/vi listener.ora
Windows
c:\oracledba\app\oracle\product\10.2.0\server\NETWORK\ADMIN\

Locate the following section of the file:
LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))      (ADDRESS = (PROTOCOL = TCP)(HOST = dberman)(PORT = 1521))    )  )
Note that the line indicated in bold may or may not be present in the file.
Change the text (PORT = 1521) to (PORT = 1522).
Save the modified listener.ora file.
Start the listener.
See “Stopping and Starting the Listener” for instructions.
Start SQL Command Line and connect to the database as user SYSTEM.
See “Connecting Locally with SQL Command Line” for instructions. You must supply the SYSTEM password. You set this password upon installation (Windows) or configuration (Linux) of Oracle Database dba.
Enter the following two commands:
ALTER SYSTEM SET LOCAL_LISTENER = “(ADDRESS=(PROTOCOL=TCP)(HOST=dberman.mydomain.com)(PORT=1522))”;
ALTER SYSTEM REGISTER;
Exit SQL Command Line and run the lsnrctl status command to verify the port number change.
The new port number should be displayed in the Listening Endpoints Summary section of the status report, and the report should include the following lines:
Service “dba” has 1 instance(s).  Instance “dba”, status READY, has 1 handler(s) for this service…

Advertisements
Standard
Oracle

change / move the Oracle Inventory

Hi,

The below steps will help you to change / move the Oracle Inventory to other locations for Linux flavor setups:

Find the current location of the Oracle Inventory (default $ORACLE_BASE/oraInventory):

For example:

[oracle@tto ~]$ cd $ORACLE_BASE

[oracle@tto app]$ pwd
/opt/app

find . -name oraInventory -print

[oracle@tto app]$ find . -name oraInventory -print
find: ./oracle/product/11.2.0/db_1/opmn/conf: Permission denied
find: ./oracle/product/11.2.0/db_1/opmn/logs: Permission denied
find: ./oracle/product/11.2.0/db_1/inventory/ContentsXML/ConfigXML: Permission denied
find: ./oracle/product/11.2.0/db_1/cfgtoollogs/cfgfw: Permission denied
./oraInventory

Open the oraInst.loc file in /etc/ and check the value of inventory_loc

[oracle@tto app]$ cat /etc/oraInst.loc
inventory_loc=/opt/app/oraInventory
inst_group=oinstall

Copy the oraInventory directory to the destination directory

cp -Rp /opt/app/oraInventory /home/oracle/oraInventory

Edit the oraInst.loc file to point to the new location

For example:

vi /etc/oraInst.loc
inventory_loc=/home/oracle/oraInventory inst_group=dba

Note: The oraInst.loc file is simply a pointer to the location of the Oracle Inventory (oraInventory)

Regards, Erman

Standard