In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-19 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Today, I logged in to the ORACLE test server on the company's AIX platform and did not configure listening. After manually configuring listening, I started listening and found that it was very slow to start. The log is as follows:
Welcome to join the ORACLE Super Group: 17115662 solve all kinds of ORACLE problems free of charge. BLOG will migrate to http://www.htz.pw in the future.
[(hostname): oracle:/u01/app/oracle/10.2.0/db_1/network/admin] lsnrctl startLSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0-Production on 20-MAR-2013 21:52:46Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting / u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0-ProductionSystem parameter file is / u01/app/oracle/10.2.0/db_1/network/admin/listener.oraLog messages written to / u01/app/oracle/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=cdolm2) (PORT=1521) Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC0)) Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=cdolm2) (PORT=1521)
Stop here, truss process
[$(hostname): oracle:/home/oracle] truss-p 241908connext (0, 0x0000000000000000, 0) (sleeping...) connext (0, 0x0000000000000000, 0) Err#78 ETIMEDOUTclose (3) = 0getsockopt (3,65535,4097, 0x0FFFFFFFFFFF7824, 0x0FFFFFFFFFFF7820) Err#9 EBADFgetsockopt (3,65535,4098, 0x0FFFFFFFFFFF7824, 0x0FFFFFFFFFFF7820) Err#9 EBADFaccess ("/ tmp/.oracle", 0) = 0chmod ("/ tmp/.oracle", 01777) Err#1 EPERMsocket (1,1,0) = 3access ("/ tmp/.oracle/sEXTPROC0" 0) Err#2 ENOENTaccess ("/ tmp/o/sEXTPROC0", 0) Err#2 ENOENTclose (3) = 0open ("/ u01/app/oracle/10.2.0/db_1/network/mesg/tnsus.msb", O_RDONLY) = 3kfcntl (3, F_SETFD, 0x0000000000000001) = 0lseek (3,0,0) = 0kread (3,256 "011303\ t\ t\ 0\ 0\ 0\ 0"..) = 256lseek (3512,0) = 512kread (3) "19B\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0"..) = 512lseek (3, 1024, 0) = 1024kread (3, "\ 0\ t\ 012\ 01A\ 0 &\ 0 -\ 0F"..) = 170lseek (3, 19456, 0) = 19456kread (3, "\ 00F04 $\ 0\ 0\ 0b04%\ 0\ 0".. 512) = 512kwrite (1, "S t a r t i n g / u 0". 66) = 66kfcntl (1, F_GETFL, 0x0000000000000008) = 2pipe (0x0FFFFFFFFFFFA548) = 0pipe (0x0FFFFFFFFFFFA540) = 0sigprocmask (0, 0x09001000A0198818, 0x09001000A01987F8) = 0kfork () = 200740thread_setmystate (0x0FFFFFFFFFFF9F50, 0x0000000000000000) = 0sigprocmask (0, 0x0FFFFFFFFFFFA420, 0x0000000000000000) = 0sigprocmask (2, 0x09001000A0198818, 0x0FFFFFFFFFFFA130) = 0_sigaction (13, 0x0FFFFFFFFFFFA260, 0x0FFFFFFFFFFFA290) = 0thread_setmystate (0x0FFFFFFFFFFF9D20, 0x0000000000000000) = 0sigprocmask (1, 0x0FFFFFFFFFFFA390, 0x0000000000000000) = 0kwaitpid (0x0FFFFFFFFFFFA530, 200740,4, 0x0000000000000000, 0x0000000000000000) = 200740close (4) = 0close (7) = 0set-o vikread (6) "N T P 02 7 8 5 8 8\ n".., 64) = 12_getpid () = 241908kfcntl (6, F_SETFD, 0x0000000000000001) = 0kwrite (5, "\ 0001\ 0\ 0\ 001 901,".. 184) = 184kread (6, "\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0\ 0".. 2064) (sleeping...) kread (6, "\ 0\ 0\ 002\ 0\ 0\ 001 9\ 0\ 0". 2064) = 32kread (6, "01}\ 0\ 006\ 0\ 0\ 0 TN".., 2064) = 381kwrite (1, "T N S L S N R f o r".. 371) = 371kwrite (1, "\ n", 1) = 1close (5) = 0close (6) = 202__libc_sbrk (0x0000000000010020) = 0x00000000106044E0open ("/ etc/passwd", O_RDONLY) = 4kioctl (4,22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTYkfcntl (4, F_GETFD) 0x0000000000000000) = 0kfcntl (4, F_SETFD, 0x0000000000000001) = 0accessx ("/ etc/security/passwd", 04,0) Err#13 EACCES_getpid () = 241908accessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF7880, 176,0) = 0_getpid () = 241908accessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF7040, 176,0) = 0accessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF7100, 176,0) 0) = 0_getpid () = 241908accessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF7000, 176,0) = 0accessx ("/ etc/security/passwd", 04,0) Err#13 EACCESaccessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF6D30, 176,0) = 0accessx ("/ etc/passwd", 04,0) = 0statx ("/ etc/passwd", 0x0FFFFFFFFFFF6DF0, 176,0) 0) = 0_getpid () = 241908accessx ("/ etc/security/passwd", 04,0) Err#13 EACCESaccessx ("/ etc/passwd", 04,0) = 0close (4) = 0lseek (3,256) = 18944kread (3, "\ 00F0413\ 0\ 0\ 0b0414\ 0\ 0".. 512) = 512kwrite (1, "C o nn ec t in g t".., 77) = 77kfcntl (1, F_GETFL, 0x0000000000000008) = 2getdomainname (0x0FFFFFFFFFFF66B0, 18944) = 0open ("/ etc/hosts") O_RDONLY) = 4kioctl (4, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTYkfcntl (4, F_SETFD, 0x0000000000000001) = 0kioctl (4,22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTYkread (4, "# @ (#) 4 7\ t 1. 1 ".., 4096) = 2026kread (4," # @ (#) 4 7\ t 1. 1 ".., 4096) = 0close (4) = 0socket (2,1,0) = 4getsockopt (4, 65535, 4104, 0x0FFFFFFFFFFF7644, 0x0FFFFFFFFFFF7640) = 0connext (4, 0x0000000110603D30, 16) (sleeping...)
Re-connext the process again and again.
[$(hostname): oracle:/home/oracle] ping cdolm2PING cdolm2: (10.10.123.223): 56 data bytes is not responding Ctrl+c ending ^ C----cdolm2 PING Statistics----4 packets transmitted, 0 packets received 100% packet loss [$(hostname): oracle:/home/oracle] cat / etc/hosts127.0.0.1 loopback localhost # loopback (lo0) name/address10.0.0.6 cdolm2-priv192.168.0.221 cdolm110.0.0.5 cdolm1-priv192.168.0.232 cdolm2-vip192.168.0.231 cdolm1-vip10.10.123.223 cdolm2 cdolm2 / fdfd2192.168.1.250 cdolm2192.168.1.251 cdolm2 found that the HOSTS file is incorrect.
Modify hosts
[$(hostname): oracle:/home/oracle] set-o vi [$(hostname): oracle:/home/oracle] ifconfig-aen0: flags=4e080863,80inet 192.168.1.250 netmask 0xffffff00 broadcast 192.168.1.255lo0: flags=e08084binet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255inet6:: 1/0tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1 modify hosts file 192.168.1.250 cdolm2
Start up normally
Start normal [$(hostname): oracle:/u01/app/oracle/10.2.0/db_1/network/admin] lsnrctl startLSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0-Production on 20-MAR-2013 21:56:37Copyright (c) 1991, 2005, Oracle. All rights reserved.Starting / u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0-ProductionSystem parameter file is / u01/app/oracle/10.2.0/db_1/network/admin/listener.oraLog messages written to / u01/app/oracle/10.2.0/db_1/network/log/listener.logListening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=cdolm2) (PORT=1521) Listening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC0) Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=cdolm2) (PORT=1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0-ProductionStart Date 20-MAR-2013 21:56:37Uptime 0 days 0 hr. 0 min. 1 secTrace Level off Security ON: Local OS AuthenticationSNMP OFF Listener Parameter File / u01/app/oracle/10.2.0/db_1/network/admin/listener.oraListener Log File / u01/app/oracle/10.2.0/db_1/network/log/listener.logListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=cdolm2) (PORT=1521)) (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC0) Services Summary...Service "PLSExtProc" has 1 instance (s). Instance "PLSExtProc", status UNKNOWN Has 1 handler (s) for this service...The command completed successfully
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 265
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.