Modify SCAN Listener Port from 1521 to 1721 on Oracle 12c RAC

Modify Scan Listener Port from 1521 to 1721

on Oracle 12c RAC (12.1.0.1) Linux x64

Steps below will change the port from the default 1521 to 1721. I have done this configuration on 12c (12.1.0.1) Standard ASM.

· Login with GI owner as Default listener is owned by Gird Infrastructure. In this case user grid is our GI owner.

[grid@rac128 ~]$ . oraenv

ORACLE_SID = [+ASM1] ?

The Oracle base remains unchanged with value /grid/app/grid

[grid@rac128 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac130,rac129,rac128

[grid@rac128 ~]$ srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac128

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac130

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac129

· Check the status of SCAN LISTENER on all Cluster Nodes

Node 1

[grid@rac128 ~]$ lsnrctl status listener_scan1

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:10:40

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN1

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 22:54:28

Uptime 0 days 8 hr. 16 min. 11 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac128/listener_scan1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.43)(PORT=1521)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "_mgmtdb" has 1 instance(s).

Instance "-MGMTDB", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

Node 2

[oracle@rac129 ~]$ lsnrctl status listener_scan3

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:15:31

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN3

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 22:53:38

Uptime 0 days 8 hr. 21 min. 53 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac129/listener_scan3/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.42)(PORT=1521)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "_mgmtdb" has 1 instance(s).

Instance "-MGMTDB", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

Node 3

[grid@rac130 ~]$ lsnrctl status listener_scan2

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:15:25

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN2

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 22:45:27

Uptime 0 days 8 hr. 29 min. 57 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac130/listener_scan2/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.41)(PORT=1521)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "_mgmtdb" has 1 instance(s).

Instance "-MGMTDB", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

· Check the status of LISTENER on all Cluster Nodes

[grid@rac128 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:18:23

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 22:54:29

Uptime 0 days 8 hr. 23 min. 53 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac128/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.128)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.163)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac128.ora.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.1/dbhome_1/admin/AMIT/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "AMIT.ora.com" has 1 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 1 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 1 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 1 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@rac129 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:18:17

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 16:10:25

Uptime 0 days 15 hr. 7 min. 52 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac129/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.129)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.164)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac129.ora.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.1/dbhome_1/admin/AMIT/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM2", status READY, has 1 handler(s) for this service...

Service "AMIT.ora.com" has 1 instance(s).

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 1 instance(s).

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 1 instance(s).

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 1 instance(s).

Instance "AMIT2", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@rac129 ~]$

[grid@rac130 ~]$ lsnrctl status

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:18:10

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

------------------------

Alias LISTENER

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 28-JUL-2015 22:46:52

Uptime 0 days 8 hr. 31 min. 18 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac130/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.130)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.165)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=rac130.ora.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.1.0.1/dbhome_1/admin/AMIT/xdb_wallet))(Presentation=HTTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

Instance "+ASM3", status READY, has 1 handler(s) for this service...

Service "-MGMTDBXDB" has 1 instance(s).

Instance "-MGMTDB", status READY, has 1 handler(s) for this service...

Service "AMIT.ora.com" has 1 instance(s).

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 1 instance(s).

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "_mgmtdb" has 1 instance(s).

Instance "-MGMTDB", status READY, has 2 handler(s) for this service...

Service "fi_pdb.ora.com" has 1 instance(s).

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 1 instance(s).

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

· Modify the Listener Port from 1521 to 1721 on any one of the node.

[grid@rac128 ~]$ srvctl modify listener -l LISTENER -p 1721

[grid@rac128 ~]$ srvctl config listener

Name: LISTENER

Network: 1, Owner: grid

Home: <CRS home>

End points: TCP:1721

· Modify the SCAN LISTENER Port to 1721.

[grid@rac128 ~]$ srvctl modify scan_listener -p TCP:1721

[grid@rac128 ~]$ srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

[grid@rac128 ~]$ srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac128

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac130

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac129

· Bounce the Listener in order to register with new assigned port (1721).

[grid@rac128 ~]$ srvctl stop listener

[grid@rac128 ~]$ srvctl start listener

[grid@rac128 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac130,rac129,rac128

[grid@rac128 ~]$ srvctl config listener

Name: LISTENER

Network: 1, Owner: grid

Home: <CRS home>

End points: TCP:1721

· Bounce the SCAN LISTENER

[grid@rac128 ~]$ srvctl stop scan_listener

[grid@rac128 ~]$ srvctl start scan_listener

[grid@rac128 ~]$ srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac130

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac129

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac128

[grid@rac128 ~]$ srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1721

Registration invited nodes:

Registration invited subnets:

· Verifying SCAN LISTENER port on all nodes

[grid@rac128 ~]$ lsnrctl status listener_scan3

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:28:24

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN3)))

STATUS of the LISTENER

------------------------

Alias listener_scan3

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 29-JUL-2015 06:47:11

Uptime 0 days 0 hr. 41 min. 12 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac128/listener_scan3/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN3)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.42)(PORT=1721)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@rac129 ~]$ lsnrctl status listener_scan2

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:30:17

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN2

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 29-JUL-2015 07:25:44

Uptime 0 days 0 hr. 4 min. 33 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac129/listener_scan2/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.41)(PORT=1721)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...
The command completed successfully

[grid@rac130 ~]$ lsnrctl status listener_scan1

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 07:30:52

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN1

Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production

Start Date 29-JUL-2015 07:25:37

Uptime 0 days 0 hr. 5 min. 15 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /grid/app/12.1.0/grid/network/admin/listener.ora

Listener Log File /grid/app/grid/diag/tnslsnr/rac130/listener_scan1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.43)(PORT=1721)))

Services Summary...

Service "AMIT.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "AMITXDB.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "fi_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

Service "hr_pdb.ora.com" has 3 instance(s).

Instance "AMIT1", status READY, has 1 handler(s) for this service...

Instance "AMIT2", status READY, has 1 handler(s) for this service...

Instance "AMIT3", status READY, has 1 handler(s) for this service...

The command completed successfully

· Still database is not occupying new port. Bounce the database in order to capture new port.

[grid@rac128 ~]$ srvctl stop database -d AMIT

[grid@rac128 ~]$ srvctl start database -d AMIT

[grid@rac128 ~]$ srvctl config database -d AMIT

Database unique name: AMIT

Database name: AMIT

Oracle home: /u01/app/oracle/product/12.1.0.1/dbhome_1

Oracle user: oracle

Spfile: +DATA_DG/AMIT/spfileAMIT.ora

Password file: +DATA_DG/AMIT/orapwAMIT

Domain: ora.com

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: AMIT

Database instances: AMIT1,AMIT2,AMIT3

Disk Groups:

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

Database is administrator managed

· Verify listener port on database

[grid@rac128 ~]$ su - oracle

Password:

[oracle@rac128 ~]$ . oraenv

ORACLE_SID = [oracle] ? AMIT1

The Oracle base has been set to /u01/app/oracle

[oracle@rac128 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 29 08:19:10 2015

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> show parameter list

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

listener_networks string

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=

192.168.1.163)(PORT=1721))

remote_listener string rac-scan.ora.com:1721

· Modify tnsnames.ora with new port on tns-aliases on all nodes.

SQL> !tnsping AMIT

TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 08:24:49

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.ora.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = AMIT.ora.com)))

TNS-12541: TNS:no listener

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

[oracle@rac128 ~]$ vi /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/

[oracle@rac128 ~]$ vi /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/tnsnames.ora

[oracle@rac128 ~]$ more /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

AMIT =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.ora.com)(PORT = 1721))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = AMIT.ora.com)

)

[oracle@rac128 ~]$ ssh rac129

Last login: Tue Jul 28 23:31:48 2015 from rac128.ora.com

[oracle@rac129 ~]$ vi /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/tnsnames.ora

AMIT =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.ora.com)(PORT = 1721))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = AMIT.ora.com)

)

[oracle@rac129 ~]$ ssh rac130

Last login: Tue Jul 28 23:31:37 2015 from rac128.ora.com

[oracle@rac130 ~]$ vi /u01/app/oracle/product/12.1.0.1/dbhome_1/network/admin/tnsnames.ora

AMIT =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.ora.com)(PORT = 1721))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = AMIT.ora.com)

)

[oracle@rac130 ~]$ tnsping AMIT

TNS Ping Utility for Linux: Version 12.1.0.1.0 - Production on 29-JUL-2015 08:30:33

Used parameter files:

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.ora.com)(PORT = 1721)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = AMIT.ora.com)))

OK (10 msec)

[oracle@rac130 ~]$ sqlplus system/oracle@AMIT

SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 29 08:30:39 2015

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> sho parameter list

NAME TYPE VALUE

--------------------- ----------- ------------------------------

listener_networks string

local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=

192.168.1.164)(PORT=1721))

remote_listener string rac-scan.ora.com:1721

Oracle Certified Master's - Blogs

Home

Wednesday, July 29, 2015

Modify SCAN Listener Port from 1521 to 1721 on Oracle 12c RAC

No comments:

Post a Comment