Unset LD_ASSUME_KERNEL in srvctl / vipca
This site contains information, scripts and instructions related to Oracle database and other technologies. Please use sqlplus and test my scripts on test environment before actual use on production. All relevant comments are welcome.
Страницы
- Main
- Veritas cluster
- AIX
- Solaris
- Linux
- Performance scripts
- RAC
- TNS
- Init parameters
- Dataguard
- ASM
- Unix tips
- VxVM
- Linux HA (hearbeat)
- Oracle internals
- Metalink (useful notes)
- Security
- OGG Oracle Golden Gate
- HTML/JavaScript in sqlplus
- Automatic TSPITR 11.2.0.3 (dropped user)
- 12.1
- SQL Performance Analyzer
- Backup/Recovery
- Alert log
четверг, 29 декабря 2011 г.
вторник, 27 декабря 2011 г.
rac: crs version
--on current node
crsctl query crs softwareversion
--lowest version (all nodes)
crsctl query crs activeversion
crsctl query crs softwareversion
--lowest version (all nodes)
crsctl query crs activeversion
понедельник, 26 декабря 2011 г.
General: Debug Oracle Installer
./runInstaller -logLevel trace
-debug /-J-DTRACING.ENABLED=true -J-DTRACING.LEVEL=2/
среда, 9 ноября 2011 г.
Linux: OpenSUSE - ssh timeout
trace for ssh
linux-nn5t:~ # strace -p 5117
Process 5117 attached - interrupt to quit
connect(3, {sa_family=AF_INET, sin_port=htons(22), sin_addr=inet_addr("192.168.55.100")}, 16) = -1 ETIMEDOUT (Connection timed out)
close(3) = 0
write(2, "ssh: connect to host 192.168.55."..., 67) = 67
exit_group(255) = ?
Process 5117 detached
linux-nn5t:~ # strace -p 5117
Process 5117 attached - interrupt to quit
connect(3, {sa_family=AF_INET, sin_port=htons(22), sin_addr=inet_addr("192.168.55.100")}, 16) = -1 ETIMEDOUT (Connection timed out)
close(3) = 0
write(2, "ssh: connect to host 192.168.55."..., 67) = 67
exit_group(255) = ?
Process 5117 detached
Solution:
Stop firewall/sbin/SuSEfirewall2 off
вторник, 8 ноября 2011 г.
Linux: Oracle VirtualBox on OpenSUSE 11.4
aus@linux-nn5t:~/Desktop> su -
Password:
linux-nn5t:~ # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Your kernel headers for kernel 2.6.37.1-1.2-default cannot be found at
/lib/modules/2.6.37.1-1.2-default/build or /lib/modules/2.6.37.1-1.2-default/source.
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
--install dkms http://mirror.bjtu.edu.cn/packman/suse/openSUSE_Tumbleweed/Extra/noarch/dkms-2.1.1.2-0.pm.1.1.noarch.rpm
linux-nn5t:~ # which dkms
/usr/sbin/dkms
linux-nn5t:~ # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Your kernel headers for kernel 2.6.37.1-1.2-default cannot be found at
/lib/modules/2.6.37.1-1.2-default/build or /lib/modules/2.6.37.1-1.2-default/source.
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
linux-nn5t:~ # uname -r
2.6.37.1-1.2-default
linux-nn5t:~ # cd /lib/modules
linux-nn5t:/lib/modules # ls -la
total 36
drwxr-xr-x 7 root root 4096 Nov 7 06:23 .
drwxr-xr-x 19 root root 12288 Nov 7 05:40 ..
drwxr-xr-x 6 root root 4096 Nov 7 05:05 2.6.37.1-1.2-default
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-default
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-pae
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-trace
drwxr-xr-x 4 root root 4096 Nov 7 06:23 2.6.37.6-0.7-xen
linux-nn5t:/lib/modules # ls -la 2.6.37.1-1.2-default
total 2776
drwxr-xr-x 6 root root 4096 Nov 7 05:05 .
drwxr-xr-x 7 root root 4096 Nov 7 06:23 ..
drwxr-xr-x 12 root root 4096 Mar 2 2011 kernel
-rw-r--r-- 1 root root 650566 Nov 7 05:05 modules.alias
-rw-r--r-- 1 root root 630327 Nov 7 05:05 modules.alias.bin
-rw-r--r-- 1 root root 2912 Feb 22 2011 modules.builtin
-rw-r--r-- 1 root root 4205 Nov 7 05:05 modules.builtin.bin
-rw-r--r-- 1 root root 327336 Nov 7 05:05 modules.dep
-rw-r--r-- 1 root root 466072 Nov 7 05:05 modules.dep.bin
-rw-r--r-- 1 root root 248 Nov 7 05:05 modules.devname
-rw-r--r-- 1 root root 113584 Feb 22 2011 modules.order
-rw-r--r-- 1 root root 131 Nov 7 05:05 modules.softdep
-rw-r--r-- 1 root root 263785 Nov 7 05:05 modules.symbols
-rw-r--r-- 1 root root 336527 Nov 7 05:05 modules.symbols.bin
drwxr-xr-x 2 root root 4096 Mar 2 2011 systemtap
drwxr-xr-x 2 root root 4096 Mar 2 2011 updates
drwxr-xr-x 2 root root 4096 Mar 2 2011 vdso
--install kernel 2.6.37.1-1.2.2
linux-nn5t:/lib/modules # rpm -qa | grep kernel
kernel-default-2.6.37.1-1.2.2.i586
kernel-desktop-devel-2.6.37.1-1.2.2.i586
kernel-xen-2.6.37.6-0.7.1.i586
kernel-default-devel-2.6.37.1-1.2.2.i586
kernel-firmware-2.6.38-1.2.1.noarch
kernel-xen-devel-2.6.37.1-1.2.2.i586
kernel-devel-2.6.37.1-1.2.2.noarch
linux-nn5t:/lib/modules # ls -la 2.6.37.1-1.2-default
total 2776
drwxr-xr-x 6 root root 4096 Nov 8 01:39 .
drwxr-xr-x 9 root root 4096 Nov 8 01:39 ..
lrwxrwxrwx 1 root root 44 Nov 8 01:39 build -> /usr/src/linux-2.6.37.1-1.2-obj/i386/default
drwxr-xr-x 12 root root 4096 Mar 2 2011 kernel
-rw-r--r-- 1 root root 650566 Nov 7 05:05 modules.alias
-rw-r--r-- 1 root root 630327 Nov 7 05:05 modules.alias.bin
-rw-r--r-- 1 root root 2912 Feb 22 2011 modules.builtin
-rw-r--r-- 1 root root 4205 Nov 7 05:05 modules.builtin.bin
-rw-r--r-- 1 root root 327336 Nov 7 05:05 modules.dep
-rw-r--r-- 1 root root 466072 Nov 7 05:05 modules.dep.bin
-rw-r--r-- 1 root root 248 Nov 7 05:05 modules.devname
-rw-r--r-- 1 root root 113584 Feb 22 2011 modules.order
-rw-r--r-- 1 root root 131 Nov 7 05:05 modules.softdep
-rw-r--r-- 1 root root 263785 Nov 7 05:05 modules.symbols
-rw-r--r-- 1 root root 336527 Nov 7 05:05 modules.symbols.bin
lrwxrwxrwx 1 root root 27 Nov 8 01:39 source -> /usr/src/linux-2.6.37.1-1.2
drwxr-xr-x 2 root root 4096 Mar 2 2011 systemtap
drwxr-xr-x 2 root root 4096 Mar 2 2011 updates
drwxr-xr-x 2 root root 4096 Mar 2 2011 vdso
linux-nn5t:/lib/modules # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Bad return status for module build on kernel: 2.6.37.1-1.2-default (i586)
Consult the make.log in the build directory
/var/lib/dkms/vboxhost/4.1.6/build/ for more information.
DO YOU HAVE gcc INSTALLED???
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
linux-nn5t:/lib/modules # rpm -qa | grep gcc
libgcc45-4.5.1_20101208-9.8.i586
libstlport_gcc4-4.6.2-9.1.i586
--install gcc
linux-nn5t:/lib/modules # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS done
Starting VirtualBox kernel modules done
linux-nn5t:/lib/modules # ^A
Password:
linux-nn5t:~ # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Your kernel headers for kernel 2.6.37.1-1.2-default cannot be found at
/lib/modules/2.6.37.1-1.2-default/build or /lib/modules/2.6.37.1-1.2-default/source.
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
--install dkms http://mirror.bjtu.edu.cn/packman/suse/openSUSE_Tumbleweed/Extra/noarch/dkms-2.1.1.2-0.pm.1.1.noarch.rpm
linux-nn5t:~ # which dkms
/usr/sbin/dkms
linux-nn5t:~ # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Your kernel headers for kernel 2.6.37.1-1.2-default cannot be found at
/lib/modules/2.6.37.1-1.2-default/build or /lib/modules/2.6.37.1-1.2-default/source.
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
linux-nn5t:~ # uname -r
2.6.37.1-1.2-default
linux-nn5t:~ # cd /lib/modules
linux-nn5t:/lib/modules # ls -la
total 36
drwxr-xr-x 7 root root 4096 Nov 7 06:23 .
drwxr-xr-x 19 root root 12288 Nov 7 05:40 ..
drwxr-xr-x 6 root root 4096 Nov 7 05:05 2.6.37.1-1.2-default
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-default
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-pae
drwxr-xr-x 3 root root 4096 Nov 7 06:01 2.6.37.6-0.7-trace
drwxr-xr-x 4 root root 4096 Nov 7 06:23 2.6.37.6-0.7-xen
linux-nn5t:/lib/modules # ls -la 2.6.37.1-1.2-default
total 2776
drwxr-xr-x 6 root root 4096 Nov 7 05:05 .
drwxr-xr-x 7 root root 4096 Nov 7 06:23 ..
drwxr-xr-x 12 root root 4096 Mar 2 2011 kernel
-rw-r--r-- 1 root root 650566 Nov 7 05:05 modules.alias
-rw-r--r-- 1 root root 630327 Nov 7 05:05 modules.alias.bin
-rw-r--r-- 1 root root 2912 Feb 22 2011 modules.builtin
-rw-r--r-- 1 root root 4205 Nov 7 05:05 modules.builtin.bin
-rw-r--r-- 1 root root 327336 Nov 7 05:05 modules.dep
-rw-r--r-- 1 root root 466072 Nov 7 05:05 modules.dep.bin
-rw-r--r-- 1 root root 248 Nov 7 05:05 modules.devname
-rw-r--r-- 1 root root 113584 Feb 22 2011 modules.order
-rw-r--r-- 1 root root 131 Nov 7 05:05 modules.softdep
-rw-r--r-- 1 root root 263785 Nov 7 05:05 modules.symbols
-rw-r--r-- 1 root root 336527 Nov 7 05:05 modules.symbols.bin
drwxr-xr-x 2 root root 4096 Mar 2 2011 systemtap
drwxr-xr-x 2 root root 4096 Mar 2 2011 updates
drwxr-xr-x 2 root root 4096 Mar 2 2011 vdso
--install kernel 2.6.37.1-1.2.2
linux-nn5t:/lib/modules # rpm -qa | grep kernel
kernel-default-2.6.37.1-1.2.2.i586
kernel-desktop-devel-2.6.37.1-1.2.2.i586
kernel-xen-2.6.37.6-0.7.1.i586
kernel-default-devel-2.6.37.1-1.2.2.i586
kernel-firmware-2.6.38-1.2.1.noarch
kernel-xen-devel-2.6.37.1-1.2.2.i586
kernel-devel-2.6.37.1-1.2.2.noarch
linux-nn5t:/lib/modules # ls -la 2.6.37.1-1.2-default
total 2776
drwxr-xr-x 6 root root 4096 Nov 8 01:39 .
drwxr-xr-x 9 root root 4096 Nov 8 01:39 ..
lrwxrwxrwx 1 root root 44 Nov 8 01:39 build -> /usr/src/linux-2.6.37.1-1.2-obj/i386/default
drwxr-xr-x 12 root root 4096 Mar 2 2011 kernel
-rw-r--r-- 1 root root 650566 Nov 7 05:05 modules.alias
-rw-r--r-- 1 root root 630327 Nov 7 05:05 modules.alias.bin
-rw-r--r-- 1 root root 2912 Feb 22 2011 modules.builtin
-rw-r--r-- 1 root root 4205 Nov 7 05:05 modules.builtin.bin
-rw-r--r-- 1 root root 327336 Nov 7 05:05 modules.dep
-rw-r--r-- 1 root root 466072 Nov 7 05:05 modules.dep.bin
-rw-r--r-- 1 root root 248 Nov 7 05:05 modules.devname
-rw-r--r-- 1 root root 113584 Feb 22 2011 modules.order
-rw-r--r-- 1 root root 131 Nov 7 05:05 modules.softdep
-rw-r--r-- 1 root root 263785 Nov 7 05:05 modules.symbols
-rw-r--r-- 1 root root 336527 Nov 7 05:05 modules.symbols.bin
lrwxrwxrwx 1 root root 27 Nov 8 01:39 source -> /usr/src/linux-2.6.37.1-1.2
drwxr-xr-x 2 root root 4096 Mar 2 2011 systemtap
drwxr-xr-x 2 root root 4096 Mar 2 2011 updates
drwxr-xr-x 2 root root 4096 Mar 2 2011 vdso
linux-nn5t:/lib/modules # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS
Error! Bad return status for module build on kernel: 2.6.37.1-1.2-default (i586)
Consult the make.log in the build directory
/var/lib/dkms/vboxhost/4.1.6/build/ for more information.
DO YOU HAVE gcc INSTALLED???
failed
(Failed, trying without DKMS)
Recompiling VirtualBox kernel modules failed
(Look at /var/log/vbox-install.log to find out what went wrong)
linux-nn5t:/lib/modules # rpm -qa | grep gcc
libgcc45-4.5.1_20101208-9.8.i586
libstlport_gcc4-4.6.2-9.1.i586
--install gcc
linux-nn5t:/lib/modules # /etc/init.d/vboxdrv setup
Stopping VirtualBox kernel modules done
Uninstalling old VirtualBox DKMS kernel modules done
Trying to register the VirtualBox kernel modules using DKMS done
Starting VirtualBox kernel modules done
linux-nn5t:/lib/modules # ^A
Подписаться на:
Сообщения (Atom)
Update BLOB
set define off DECLARE vb1 CLOB := 'long text'; vb2 CLOB := 'long text'; vb3 CLOB := ...
-
0) Generate the diff plan report We have sql_id gu7rvn4s4rb0m, and 2 child cursors 0 and 2 variable v clob set serveroutput on set auto...
-
aus@linux-nn5t:~/Desktop> su - Password: linux-nn5t:~ # /etc/init.d/vboxdrv setup Stopping VirtualBox kernel modules ...
-
-- After media failure 03:03:25 150 4294967295 SYS@orcl> select * from t_t where object_name = 'test'; select * from t_t where ob...