Author Archive
Linux System information
System information
Show architecture of machine
bash> arch i686
Show used kernel version(1)
bash> uname -r 2.6.9-67.0.15.ELsmp
bash> cat /proc/version Linux version 2.6.9-67.0.15.ELsmp (mockbuild@builder10.centos.org) (gcc version 3.4.6 20060404 (Red Hat 3.4.6-9)) #1 SMP Thu May 8 10:52:19 EDT 2008
Show hardware system components(SMBIOS / DMI)
bash> dmidecode # dmidecode 2.2 SMBIOS 2.3 present. 39 structures occupying 2026 bytes. Table at 0×000F6024. Handle 0×0000 DMI type 0, 19 bytes. BIOS Information Vendor: IBM Version: -[BWE130AUS-1.11]- Release Date: 10/25/2007 Address: 0xF0F40 Runtime Size: 61632 bytes ROM Size: 4096 kB [...]
ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:
When I log via ssh to another machine
bash> ssh gandalf@rohan.lotr.com unable to initialize mechanism library [/usr/lib/gss/gl/mech_krb5.so]
the following message appears was appears
rohan.lotr.com sshd[23418]: [ID 530472 auth.error] Kerberos mechanism library initialization error: Can't open/find Kerberos /etc/krb5/krb5.conf
Workaround:
Edit /etc/ssh/ssh_config and add the following
Host * StrictHostKeyChecking no GSSAPIKeyExchange no GSSAPIAuthentication no
And
Edit /etc/ssh/sshd_config and add the following
GSSAPIAuthentication no GSSAPIKeyExchange no GSSAPIStoreDelegatedCredentials no
Tracking Down “Last Reboot” on windows
when you handful on your windows environment, you must know this
edit uptime.bat systeminfo | find "Up Time"
and then save with “alt+f > s > x”
last reboot action here..
uptime.bat systeminfo | find "Up Time" System Up Time: 3 Days, 19 Hours, 6 Minutes, 26 Seconds
Backup Listener log
In database production, the log of listener was grow rapidly, some times if you move the “listener.log” while the listener is up and running, listener will stop writing to log file after you move/delete the “listener.log”, it won’t create new log file.
The listener log status will be ‘off’, You need to start the “listener log” again manually. For this reason you must do this procedure.
bash> lsnrctl stat
LSNRCTL for Solaris: Version 9.2.0.6.0 - Production on 09-MAR-2008 12:43:22 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 9.2.0.6.0 - Production Start Date 11-SEP-2007 03:34:17 Uptime 180 days 9 hr. 9 min. 4 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /oracle/app/product/9.2.0/network/admin/listener.ora Listener Log File /oracle/app/product/9.2.0/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HOSTNAME)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "DB_SID.domain.com" has 2 instance(s). Instance "DB_SID", status UNKNOWN, has 1 handler(s) for this service... Instance "DB_SID", status READY, has 1 handler(s) for this service... The command completed successfully
bash> lsnrctl
LSNRCTL> SET log_status off Connecting TO (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) LISTENER parameter "log_status" SET TO OFF The command completed successfully
bash> mv /oracle/app/product/9.2.0/network/log/listener.log /backup/listener.log_9-March-2008
LSNRCTL> set log_status on Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) LISTENER parameter "log_status" set to ON The command completed successfully
Change SHMMAX without rebooting
Shmmax parameter is supposed to be the maximum size of a single shared memory segments (and the oracle sga is build out of these shared memory segments).
New to the Solaris 8 release is the modular debugger, mdb(1), which is unique among
available Solaris debuggers because it is easily extensible. Mdb(1) also includes a number of desirable usability features including command-line editing, command history, built-in output pager, syntax checking, and command pipelining. This is the recommended post-mortem debugger for the kernel.
To change the value of the integer variable shmmax from 8GB to 10 GB without Reboot Server, do the following
bash> cp /etc/system /etc/system_old
bash> grep shminfo_shmmax /etc/system set shmsys:shminfo_shmmax=8589934592
bash> mdb -k Loading modules: [ unix krtld genunix ip usba s1394 ipc nfs ptm logindmux random ] > shminfo_shmmax /D shminfo_shmmax: shminfo_shmmax: 1 > shminfo_shmmax /E shminfo_shmmax: shminfo_shmmax: 8589934592 > $q
At we can see the “shminfo_shmmax” use a 64 bit value, let’s start to change the value
bash> mdb -kw Loading modules: [ unix krtld genunix ip usba s1394 ipc nfs ptm logindmux random ] > shminfo_shmmax /Z 0t10737418240 shminfo_shmmax: 0x5f5e10000 = 0x19000 > shminfo_shmmax /E shminfo_shmmax: shminfo_shmmax: 10737418240 > $q
After successfully, change the parameter “shminfo_shmmax” at /etc/system with same value on mdb
bash> vi /etc/system set shmsys:shminfo_shmmax=10737418240
Moving & Recreate Temp Tablespace
I Recreate the temp tablespace coz my temp tablespace was corrupt,
you can do to the following bellow
- create temporary tablespace temp2 tempfile ‘/rdbms/temp01/temp2.dbf’ size 10M extent management local uniform size 1M;
- alter database default temporary tablespace temp2;
- drop tablespace temp including contents and datafiles;
now change back to temp again with following step bellow:
- create temporary tablespace temp tempfile ‘/rdbms/temp01/temp2_01.dbf’ size 1024M extent management local uniform size 1M;
- alter database default temporary tablespace temp;
- drop tablespace temp2 including contents and datafiles;
- alter tablespace temp add tempfile ‘/rdbms/temp01/temp2_02.dbf’ size 1024M;
ORA 29807 – specified operator does not exist
Yesterday,
During Installation of Oracle database 9i base on RHEL 4 ES,
I got Found error occurred when create the database using dbca,
and it keeps failing at the same point (Creating data dictionary Views)
This the error number Detail “ORA 29807 – specified operator does not exist”
Workaround;
just ignore the error and DBCA proceeds normally. Once the database is ready,
login as SYS and run this script manually:
$ORACLE_HOME/rdbms/admin/prvtxml.plb
SQL> @?/rdbms/admin/prvtxml.plb
How to mount an ISO image in Solaris
Q. How do I mount ISO FILE, And Read under it?
A. You can Use lofi(7D)/lofiadm the loopback file driver
Mounting an Existing CD-ROM Image Or File image
Use lofiadm to attach a block device to it:
bash> lofiadm -a /path/to/file.iso /dev/lofi/1
And Then Use the mount command to mount the image:
bash> mount -F hsfs -o ro /dev/lofi/1 /path/output
lofiadm picks the device and prints the device name to the standard output.
bash> lofiadm Block Device File /dev/lofi/1 /path/to/file.iso
Check to ensure that Solaris understands the image:
bash> df -h Filesystem size used avail capacity Mounted on /dev/lofi/1 0K 0K 0K 0% /path/output
As a final step, unmount and detach the images:
bash> umount /path/output bash> lofiadm -d /dev/lofi/1
bash> lofiadm Block Device File