Troubleshooting for startup inconsistent DB
for e.g. database unable up cause of datafile corruption
SQL> startup ORACLE instance started. Total System Global Area 1610612736 bytes Fixed Size 2177912 bytes Variable Size 396149896 bytes DATABASE Buffers 1207959552 bytes Redo Buffers 4325376 bytes DATABASE mounted. ORA-01113: file 2 needs media recovery ORA-01110: DATA file 2: '/oradata/oracle/ts/undotbs01.
commonly the database unable be startup if UNDO or SYSTEM table space need recovery, if these happen we need correct temporary workaround to handle this, all workaround for each tablespace datafile is similar
do the recovery
SQL> recover DATABASE; ORA-00279: CHANGE 7516226638 generated at 05/05/2008 12:32:11 needed FOR thread 1 ORA-00289: suggestion : /oradata/oracle/ts/arc/1_42_653916655.dbf ORA-00280: CHANGE 7516226638 FOR thread 1 IS IN sequence #42 Specify log: {ret=suggested | filename | AUTO | CANCEL} AUTO ORA-00308: cannot open archived log ‘/oradata/oracle/ts/arc/1_42_653916655.dbf’ ORA-27037: unable TO obtain file STATUS SVR4 Error: 2: No such file OR directory Additional information: 3
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 [...]
Set hostname without reboot
bash> uname -a SunOS Trojan 5.9 Generic_118558-33 sun4u sparc SUNW,Netra-T12
replace old “hostname” with new “hostname” in file /etc/hosts, /etc/nodename, /etc/hostname.”ethernet_port_name”, /etc/net/ticlts/hosts, /etc/net/ticotsord/hosts, /etc/net/ticots/hosts
bash> vi /etc/hosts bash> vi /etc/nodename bash> vi /etc/hostname.bge0 bash> vi /etc/net/ticlts/hosts bash> vi /etc/net/ticotsord/hosts bash> vi /etc/net/ticots/hosts
and then execute command :
hostname "new hostname"
bash> hostname worm bash> . /.profile
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
Oracle Heterogeneous Configuration Service (ORACLE to MySQL)
PART I : Setting up ODBC driver
bash> rpm –ivh mysql-connector-odbc-3.51.12-linux-i686.rpm
bash> /etc/init.d/mysqld start Initializing MySQL database: [ OK ]
bash> ODBCConfig
bash> vi /etc/odbc.ini
[trans] Driver = MySQL ODBC 3.51 Driver DATABASE = kampus DESCRIPTION = punya_kampus PWD = password PORT = 3306 SERVER = localhost UID = root
Comparison Kernel parameter Solaris9 and Solaris10
SERVER – Solaris9 – Oracle9i …..[compare]….. SERVER – solaris10 – Oracle10g
[ Solaris9] forceload:sys/shmsys
[ Solaris9] forceload:sys/semsys
[ Solaris9] set shmsys:shminfo_shmmax=51539607552
[ Solaris9] set shmsys:shminfo_shmmin=1
[ Solaris9] set shmsys:shminfo_shmmni=2048
[ Solaris9] set shmsys:shminfo_shmseg=200
[ Solaris9] set semsys:seminfo_semmni=1000