ORACLE - ORATOP

oratop - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864.1) oratop: Release 14.1.2 Usage:  oratop [ [Options] [Logon] ] Logon: {username[/password][@connect_identifier] | / } [AS {SYSDBA|SYSOPER}] connect_identifier:     o Net Service Name, (TNS) or     o Easy Connect (host[:port]/[service_name]) ...

Read More

PERL - LINUX CONNECT SQLServer

[root@cacti SQLServer]# ./sql_connect.pl  Successful Connection. Current Connection Properties ---------------------------------------------------------------------------------------     SQL Server Instance : SRV-DB     SQL Server Version  : Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)      Current Database    : master    ...

Read More

ORACLE - ORA-00205: error in identifying control file

[root@cacti XE]# su - oracle -bash-4.1$ ls admin  connect  diag  exit  fast_recovery_area  oradata  oradiag_oracle  product -bash-4.1$ cd oradata/ -bash-4.1$ cd XE/ -bash-4.1$ ls control.dbf  sysaux.dbf  system.dbf  temp.dbf  undotbs1.dbf  users.dbf -bash-4.1$ ll total 1285700 -rw-r-----. 1 oracle dba   9748480 Dec 10 07:11...

Read More

ORACLE - ADD DISK ASM/Diskgroup - Automatic Storage Management (ASM)

Automatic Storage Management (ASM) login as: root root@192.168.0.239's password: Last login: Tue Dec  9 19:10:42 2014 from 192.168.0.206 [root@db1 ~]# fdisk -l Disk /dev/sda: 150.3 GB, 150323855360 bytes 255 heads, 63 sectors/track, 18275 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes /...

Read More

ORACLE - Swiss penknife QUERY

Swiss penknife QUERY SHOW AND KILL USER CONNECTED  SQL> alter system kill session ''' ||sid|| ',' || serial#|| ''' immediate;' from v$session where username='TESTE'; SHOW SIZE BY DATAFILE SQL> select file_id, block_id, blocks*8192/1024 MB, owner || '.' || segment_name...

Read More

ORACLE - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

-bash-4.1$ oratop siltech/123456@XE oratop: Release 13.2.4 Production on Mon Dec  8 12:26:17 2014 Copyright (c) 2011, Oracle.  All rights reserved. Processing ... ORA-12514: TNS:listener does not currently know of service requested in connect descriptor -bash-4.1$  -bash-4.1$...

Read More