Before SQL> sho parameter listener NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ listener_networks string local_listener string LISTENER_TESTDB1 remote_listener string SQL> After SQL> show parameter listener NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ listener_networks string local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD DRESS=(PROTOCOL=TCP)(HOST=orac01)(PORT=1521)))) remote_listener string orac.thexchange.com:1521 TESTDB1.__db_cache_size=2147483648 TESTDB1.__java_pool_size=536870912 TESTDB1.__large_pool_size=536870912 TESTDB1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment TESTDB1.__pga_aggregate_target=45097156608 TESTDB1.__sga_target=8589934592 TESTDB1.__shared_io_pool_size=0 TESTDB1.__shared_pool_size=10200547328 TESTDB1.__streams_pool_size=0 *.audit_file_dest='/u01/app/oracle/admin/TESTDB/adump' *.cluster_database_instances=2 *.cluster_database=TRUE *.compatible='11.2.0' *.control_files='+DATA/testdb1_ctl01.ctl','+FRA/testdb1_ctl02.ctl' *.db_block_size=8192 *.db_create_file_dest='+DATA' *.db_domain='' *.db_file_multiblock_read_count=16 *.db_name='STGTDB' *.db_recovery_file_dest='+DATA' *.db_recovery_file_dest_size=2G *.diagnostic_dest='/u01/app/oracle' TESTDB1.instance_name='TESTDB1' TESTDB1.instance_number=1 TESTDB2.instance_number=2 *.job_queue_processes=10 *.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orac01)(PORT=1521))))' *.log_checkpoints_to_alert=TRUE *.memory_max_target=107374182400 *.memory_target=53687091200 *.pga_aggregate_target=100M *.processes=4096 *.recyclebin='OFF' *.remote_listener='orac.thexchange.com:1521' *.remote_login_passwordfile='exclusive' *.sessions=6180 STGTDB2.thread=2 TESTDB1.thread=1 *.undo_management='AUTO' TESTDB1.undo_tablespace='UNDOTBS1' TESTDB2.undo_tablespace='UNDOTBS2' |
|
|