select s1.username || ‘@’ || s1.machine
|| ‘ ( SID=’ || s1.sid || ‘ ) is blocking ‘
|| s2.username || ‘@’ || s2.machine || ‘ ( SID=’ || s2.sid || ‘ ) ‘ AS blocking_status, s1.SQL_ID
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and [...]
Show Locking Proccess
kill sesion oracle in windows
path: …/Oracle Home/bin/orakill.exe or find manually
command: orakill <sid> <spid>
example: C:\Oracle9\bin\orakill ORCL 2760
addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F11%2F15%2Fkill-sesion-oracle-in-windows%2F’;
addthis_title = ‘kill+sesion+oracle+in+windows’;
addthis_pub = ”;
Copy Tape to Tape
The ” tcopy ” tility used to copies the magnetic tape mounted on the tape drive specified by the source argument. Simply, the ” tcopy ” used for copies one tape to another tape.
Rewind the tape first
# mt -f /dev/rmt/0 rewind
# mt -f /dev/rmt/1 rewind
And [...]
Shutdown Oracle
$ su - oracle
SQL> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate
If No Response
SQL> shutdown abort
Monitoring Instance when restart database
$ tail -f $ORACLE_HOME/admin/bdump/alert_$ORACLE_SID.log
addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F07%2F18%2Fshutdown-oracle%2F’;
addthis_title = ‘Shutdown+Oracle’;
addthis_pub = ”;
Performance Monitoring Commands
Monitoring Commands
nmon
vmstat
iostat
sar
topas
nmon
svmon
filemon
rmss
addthis_url = ‘http%3A%2F%2Fsysinfo.bascomp.org%2F2007%2F07%2F05%2Fperformance-monitoring%2F’;
addthis_title = ‘Performance+Monitoring+Commands’;
addthis_pub = ”;
Get WWN of Fibre cards
To get your wwn at your Solaris machine, you can use this command
# prtpicl -v | grep wwn
:node-wwn 50 01 04 f0 00 5f 0a 85
:port-wwn 50 01 04 f0 00 [...]
System Startup and Shutdown
System boot process:
Power on
PDC executes CPU, Memory and other tests
PDC initialize the console to display messages
Looks for Primary boot path
It loads and executes Initial System Loader (ISL). Roll of boot ROM ends.
ISL loads the secondary system loader called “hpux”. It resides on boot area of the disk
“hpux” loads “/stand/vmunix” into memory and hands control over [...]
Show Information On HP-UX Machine
This optional software, you must install Ignite-UX, work only in HP-UX 11.11 n later
And only root
# print_manifest | more
System Information
Your Hewlett-Packard 9000 computer has software installed and
configured as follows.
The system was created January 09, 2003, 12:10:05 SST.
It was created with Ignite-UX revision B.4.1.61.
————————————————————-
NOTE: You should retain this information for future reference.
————————————————————-
Serial number: XXXXXXXXX
Order number: [...]
- System Administrator Appreciation Day
- Troubleshooting for startup inconsistent DB
- Linux System information
- set hostname without reboot
- ssh[23593]: [ID 530472 user.error] Kerberos mechanism library initialization error:
- Tracking Down “Last Reboot” on windows
- Backup Listener log
- Oracle Heterogeneous Configuration Service (ORACLE to MySQL)
- Comparison Kernel parameter Solaris9 and Solaris10
- Kernel setup for Solaris 10 using project files - Special for Oracle10g
Latest In ORACLE
Troubleshooting for startup inconsistent DB
for e.g. database unable up cause of datafile corruption SQL> startup ORACLE instance started. Total System Global ...continue readingBackup Listener log
In database production, the log of listener was grow rapidly, some times if you move ...continue readingCategories
-
- *Nix
- AIX
- Assign disk
- Backup
- BUG
- Connection
- Datafile
- Error
- Error Number
- Export-Import
- Fibre Channel
- FTP
- Get WWN
- Hardware Info
- HP-UX
- Kernel Conf
- LINUX
- Listener
- Mounting
- Mysql
- NTP
- ORACLE
- Sendmail
- Session
- Show Bit
- Show Memory
- Show Memory
- Show Processor
- Show Serial Number
- SOLARIS
- Sql Loader
- SSH
- Startup
- Sudo
- sysinfo
- Tablespace
- Tape
- Telnet
- Tunable Parameters
- Windows
- WWN Info


An ordinary people, participants, contributor who share their own experiences, their knowledge, their informations, task, a few tips and tricks, their problem with solving tools..