As per Oracle Documentation from Oracle 11g Release 2 (11.2), the password feature is being deprecated. This does not cause a loss of security because authentication is enforced through local operating system authentication. If remote administration of listener is required, then use one of the following methods to connect to and administer the listener. 1) Connect to the host where listener is running using SSH or other secure method. 2) Use Oracle Enterprise Manager to adminster the listener. Listener Name: prod Log in to the listener control utility. [oracle@canada ~]$ lsnrctl #Select listener name. LSNRCTL> set current_listener prodCurrent Listener is prod#Change password(press enter for old password). LSNRCTL> change_passwordOld password: New password: Reenter new password: Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) Password changed for prod The command completed successfully#Save the configuration. LSNRCTL> save_configConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) Saved prod configuration parameters. Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Old Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.bak The command completed successfullyIn listener.ora file insert the following line. LOCAL_OS_AUTHENTICATION_PROD=OFF #Restart the listener. [oracle@canada ~]$ lsnrctl LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-JAN-2013 11:43:43 Copyright (c) 1991, 2009, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> set current_listener prodCurrent Listener is prodLSNRCTL> stopConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) The command completed successfullyLSNRCTL> startStarting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/canada/prod/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=canada.example.com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias prod Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 04-JAN-2013 11:43:59 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Password SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/canada/prod/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=canada.example.com)(PORT=1521))) Services Summary... Service "dell" has 1 instance(s). Instance "dell", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully#At this stage the password has been successfully implemented. #Stopping a listener at this stage will result in an TNS error. LSNRCTL> stopConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) TNS-01169: The listener has not recognized the password#To stop it set the password. LSNRCTL> set passwordPassword: The command completed successfullyLSNRCTL> stopConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) The command completed successfullyLSNRCTL> startStarting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/canada/prod/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=canada.example.com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=canada.example.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias prod Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production Start Date 04-JAN-2013 11:44:51 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Password SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/canada/prod/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=canada.example.com)(PORT=1521))) Services Summary... Service "dell" has 1 instance(s). Instance "dell", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
Search This Blog
Monday, January 21, 2013
How to Password Protect Listener in 11g ?
Wednesday, January 16, 2013
How to Configure DNS Server in RHEL 6?
Server IP Address: 192.168.1.121 Hostname: newyork.example.com [root@newyork named]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
Thursday, December 27, 2012
Different ways to get the DBID of Database.
Method 1:Through SQL command prompt.
SQL> select dbid from v$database;
DBID
----------
3764293269
Simulating Oracle Tape Backups.
As per Oracle Note:312737.1 The Oracle DiskSbt API is designed for TESTING purposes ONLY and can NOT be used for any database backup. The Oracle.Disksbt can be used to simulate tape backups on disk using sbt_tape channel.
Oracle Database links.
Primary database name = dell
Secondary Database Name = dup
On Secondary
Create TNS Entry for primary database.
[oracle@newyork admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
Tuesday, December 11, 2012
Oracle 11gR2 RAC Node Deletion.
NodeName which has to be removed from the cluster - rac3 Backup OCR from rac1 [root@rac1 ~]# /u01/app/11.2.0/grid/bin/ocrconfig -manualbackup
Monday, December 10, 2012
RAC common wait events.
1) Global cache blocks lost- This statistic shows block losses during network transfers. High values of this statistic indicate network problems. The use of an unreliable IPC protocol, such as UDP, may result in the value for lost global cache blocks being non-zero. High values for this statistics indicates that there is some problem with the IPC, network or hardware. 2) Global cache blocks corrupt - This statistic shows if there is any block corruption during interconnect transfers. High value for this statistic indicates that there is a IPC,network or hardware problem.
Subscribe to:
Posts (Atom)