[oracle@linux01 trace]$ lsnrctl LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 16-SEP-2015 11:24:18 Copyright (c) 1991, 2009, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> set current_listener LISTENER Current Listener is LISTENER LSNRCTL> set log_file listener1 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux01)(PORT=1521))) TNS-01251: Cannot set trace/log directory under ADR Solution : DIAG_ADR_ENABLED_LISTENER=OFF -- >> add this line to you listener.ora reload the listener. $ lsnrctl reload Now lets try again to reset: LSNRCTL> set current_listener LISTENER Current Listener is LISTENER LSNRCTL> set log_file /u01/app/oracle/diag/tnslsnr/linux01/listener/trace/listener1.log Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=linux01)(PORT=1521))) LISTENER parameter "log_file" set to /u01/app/oracle/diag/tnslsnr/linux01/listener/trace/listener1.log The command completed ...
chr function returns the ascii letter for that integer. We know that there are 255 ascii characters defined. SQL> select chr(65) as CHR from dual; CHR – A Below code print all 255 ascii characters Sample code to check the values : begin for i in 1..255 loop dbms_output.put_line( 'CHR('||i||')' ||'=='|| chr(i) ); end loop; end; / This output might differ actually based on the chacterset you have choosen while installing you Database. DBMS_OUTPUT : CHR(1)== CHR(2)== CHR(3)== CHR(4)== CHR(5)== CHR(6)== CHR(7)== CHR(8)== CHR(9)== CHR(10)== CHR(11)== CHR(12)== CHR(13)== CHR(14)== CHR(15)== CHR(16)== CHR(17)== CHR(18)== CHR(19)== CHR(20)== CHR(21)== CHR(22)== CHR(23)== CHR(24)== CHR(25)== CHR(26)== CHR(27)== CHR(28)== CHR(29)== CHR(30)== CHR(31)== CHR(32)== CHR(33)==! CHR(34)==" CHR(35)==# CHR(36)==$ CHR(37)==% CHR(38)==& CHR(39)==' CHR(40)==( CHR(41)==) CHR(42...
TNS-12560: TNS:protocol adapter error TNS-00583: Valid node checking: unable to parse configuration parameters I Received following errors when trying to startup my listener. I verified the listener.ora and sqlnet.ora files and everything seemed to look normal. [oracle@Linux03 encryption_keystore]$ lsnrctl start LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 12-JUL-2016 10:05:32 Copyright (c) 1991, 2014, Oracle. All rights reserved. Starting /u01/app/oracle/product/12.1.0.2/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/Linux03/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1))) Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Linux03)(PORT=1521))) TNS-12560: TNS:protocol adapter error TNS-00583: Valid node checking...
Comments
Post a Comment