SQLServer - [ Error: Value cannot be null. Parameter name: viewInfo ]

Error: Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

I came across this error on a test database server when I launched the SSMS. The version of SQL Server I was using was 2008 R2 SE. A dialog box with following message would prompt whenever I click on anything in the management studio.

Value cannot be null. Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

The problem appeared to be when accessing the contents of a settings file. The file had invalid entries. This file is CurrentSettings-<date>. The fix for this is as shown below:

1. On the server Go to start menu–>Your profile–>Documents–>SQL Server Management Studio–>Settings (this is the location of the file specified above)

2. Delete all files from this folder

3. Restart sqlserver services

4. Launch the SSMS and this error is gone. You will be able to expand all the folders and perform regular SSMS activities without this error.

Hope this helps!

Font : http://mssqlnuggets.wordpress.com/

Read More

Oracle - ORA-01172/ORA-01151 [ Baby does not cry =)]

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01172: recovery of thread 1 stuck at block 7583 of file 2
ORA-01151: use media recovery to recover block, restore backup if needed


SQL> recover database;
Media recovery complete.
SQL> alter database open;



SQL> select * from dba_data_Files where file_id=2;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------
   FILE_ID TABLESPACE_NAME                     BYTES     BLOCKS STATUS    RELATIVE_FNO AUT   MAXBYTES  MAXBLOCKS
---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ----------
INCREMENT_BY USER_BYTES USER_BLOCKS ONLINE_
------------ ---------- ----------- -------
/home/etr/db/dbfiles/undotbs01.dbf
         2 UNDOTBS1                        214958080      26240 AVAILABLE            2 YES 8388608000  1024000
       25600  214892544       26232 ONLINE

Read More

Oracle - RMAN RESTORE DB

SQL> select dbid from v$database; PRD

      DBID
----------
 250744165

BASE :TESTE_RESTORE

alter system set db_create_file_dest='D:\Oracle\oradata\wms1' scope=spfile;

alter system set db_file_name_convert='E:\ORACLE\ORADATA\WMS','D:\Oracle\oradata\wms1' scope=spfile;

alter system set log_file_name_convert='E:\ORACLE\ORADATA\WMS','D:\Oracle\oradata\wms1' scope=spfile;

alter system set db_create_online_log_dest_1='D:\Oracle\oradata\wms1' scope=spfile;




$ rman target / nocatalog

RMAN> SET DBID=ID_PRD   
RMAN> RMAN RESTORE CONTROLFILE FROM ‘ FILE.BAK’

RMAN> RMAN CATALOG START WITH ‘PATH_BACKUP’;

RMAN> RESTORE DATABASE;

Or Rename datafile destination 

run{
set newname for datafile 1 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 2 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 3 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 4 to ‘d:\oracle\oradata\wms\’;
set newname for datafile 5 to 'd:\oracle\oradata\wms\';
set newname for datafile 6 to 'd:\oracle\oradata\wms\';
set newname for datafile 7 to 'd:\oracle\oradata\wms\';
set newname for datafile 8 to 'd:\oracle\oradata\wms\';
set newname for datafile 9 to 'd:\oracle\oradata\wms\';
set newname for datafile 10 to 'd:\oracle\oradata\wms\';
set newname for datafile 11 to 'd:\oracle\oradata\wms\';
set newname for datafile 12 to 'd:\oracle\oradata\wms\';
set newname for datafile 13 to 'd:\oracle\oradata\wms\';
set newname for datafile 14 to 'd:\oracle\oradata\wms\';
set newname for datafile 15 to 'd:\oracle\oradata\wms\';
set newname for datafile 16 to 'd:\oracle\oradata\wms\';
set newname for datafile 17 to 'd:\oracle\oradata\wms\';
set newname for datafile 18 to 'd:\oracle\oradata\wms\';
set newname for datafile 19 to 'd:\oracle\oradata\wms\';
set newname for datafile 20 to 'd:\oracle\oradata\wms\';
set newname for datafile 21 to 'd:\oracle\oradata\wms\';
set newname for datafile 22 to 'd:\oracle\oradata\wms\';
set newname for datafile 23 to 'd:\oracle\oradata\wms\';
set newname for datafile 24 to 'd:\oracle\oradata\wms\';
set newname for datafile 25 to 'd:\oracle\oradata\wms\';
set newname for datafile 26 to 'd:\oracle\oradata\wms\';
set newname for datafile 27 to 'd:\oracle\oradata\wms\';
restore database;
}

Read More

Oracle - Automating Database Startup / Linux

# vi /etc/oratab


SINTEXA:
[NOME_DA_INSTÂNCIA]:[ORACLE_HOME]:[Y/N]

[NOME_DA_INSTÂNCIA] : USER/ORACLE $echo $ORACLE_SID;
[ORACLE_HOME] : USER/ORACLE  $echo $ORACLE_HOME.
[Y/N] : Y= Automating Startup /  N= No Automating Startup  .

Example

root@aix(/)# su - oracle
[YOU HAVE NEW MAIL]
$ . ./profileoracle
$ echo $ORACLE_HOME
/opt/app/oracle/product/11.2.0/db_1
$ echo $ORACLE_SID
orcl
$ cat /etc/oratab
orcl:/opt/app/oracle/product/11.2.0/db_1:Y              # line added by Agent
#orcl:/opt/app/oracle/product/11.2.0/db_1:N             # line added by Agent

Read More

Lunix - SSH Authorized

Machine Authorized

[root@srv-gama .ssh]# ssh-keygen 
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa):
[root@srv-gama .ssh]#
[root@srv-gama .ssh]#
[root@srv-gama .ssh]# ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/root/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /root/.ssh/id_rsa.
Your public key has been saved in /root/.ssh/id_rsa.pub.
The key fingerprint is:
5c:26:56:84:00:63:a8:5e:12:6a:40:e2:0d:c1:78:45 root@srv-gama
[root@srv-gama .ssh]# ls -lat
total 24
drwx------  2 root root 4096 Jun 20 08:36 .
-rw-------  1 root root 1675 Jun 20 08:36 id_rsa
-rw-r--r--  1 root root  395 Jun 20 08:36 id_rsa.pub
drwxr-x--- 25 root root 4096 Jun 20 08:29 ..
-rw-r--r--  1 root root 1183 Jul 10  2009 known_hosts
[root@srv-gama .ssh]# ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/root/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /root/.ssh/id_dsa.
Your public key has been saved in /root/.ssh/id_dsa.pub.
The key fingerprint is:
79:ad:fc:b1:a9:19:6d:6d:5d:f4:ec:08:c8:6e:ef:76 root@srv-gama
[root@srv-gama .ssh]# ls -lat
total 32
drwx------  2 root root 4096 Jun 20 08:36 .
-rw-------  1 root root  672 Jun 20 08:36 id_dsa
-rw-r--r--  1 root root  603 Jun 20 08:36 id_dsa.pub
-rw-------  1 root root 1675 Jun 20 08:36 id_rsa
-rw-r--r--  1 root root  395 Jun 20 08:36 id_rsa.pub
drwxr-x--- 25 root root 4096 Jun 20 08:29 ..
-rw-r--r--  1 root root 1183 Jul 10  2009 known_hosts
[root@srv-gama .ssh]# more id_rsa.pub 
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEAvyxuEL8ruqzgQQd3yT9kpjQDCoOw1lyxNo9/OVtXkrgOQjS5uc4gpPgZULmHsafsFAP4Rv6JVevD3zyQP30tF/Yr04Hqe8vVVlyj962SWGvd2/T8Nk7jAFvdDVlrnkzUya++QmrUxJZlADF
PfPxquBJbHOuguhZcJmQN5nzPlvEMyiI1JpcT8kIReE8iNMfQ9Bwr2J4wPZRhc5AfLjjXgxP7356Zzss3YcRGbO4NAx+h0SN5ULingkrdjqrj9TLfem+uLj5KFt2dgHdoPvW+FdEHEEgrjngzzaGpRXn7zle5wg7cWoJCmWhM2C9AACPlbk
ev5hmWwid+r68FxX/jXw== root@srv-gama
[root@srv-gama .ssh]# more id_dsa.pub 
ssh-dss AAAAB3NzaC1kc3MAAACBANrW/auJEH+kvPFZ5WDaBULUv/sUVEOWkhpvSmEFg9WWoceMsBG9wvZWON3VzrLjwbvJRckxzUIzHUx3oQhNo2GYT++SNI4oMPv9M7/a1tdVcIwtpvhwQ/DolzQjmUvuPs8ErcvW9oxgbglLI/UjESa
t6f1HEAyMJHAsVT76K753AAAAFQDX306rlTgEZ2nNnO3ROQ8W4UE8cQAAAIEA0FfFW+i+xm/sL0HVJRx6ax83ul1QClOwi3tSugNCFyTIWhrNMv8UfA+Dx4x1r2vx/l9+1S8NLTnob9nQVmCv4Qrtv5VRQwriGA2wagnfXGcSjbVE6Dq3PE
DQB8oxFNHy3N4JXF0wCJZGpRvMNl77mcXE7Jz46Dhxi7NSaMpXvdsAAACBANFma3xWHXqP/d6bbVpzMlmgzMHZR8rjAh7AlyKj2FNiqgXBxuoJTls9mEJf/2sJksrAi1bqzLGH8jw/6qENPYnwHJeFQigogr7/KdZOtf5hWV96sYfxTwUG0
0nKRR8jyBr9v3JJVggoRsIB2/B6iVRC5BFoYXG0VSHNFUeJaLRV root@srv-gama



Machine destination

[root@srv-alpha .ssh]# ls -lat
total 16
drwxr-x--- 22 root root 4096 Jun 20 10:01 ..
drwx------  2 root root 4096 Jul 15  2010 .
-rw-r--r--  1 root root  395 Jul 15  2010 known_hosts
[root@srv-alpha .ssh]# vi authorized_keys

COPY TEXT "ssh-dss  + ssh-rsa"  >>  authorized_keys

Read More

Oracle - Alter profile / user [ ORA-01017/ ORA-28009 ]

SQL> connect sys as sysdba

Enter password: 

Connected.

SQL> SELECT * FROM DBA_PROFILES;

PROFILE         RESOURCE_NAME RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT         COMPOSITE_LIMIT KERNEL  UNLIMITED

DEFAULT         SESSIONS_PER_USER KERNEL  UNLIMITED

DEFAULT         CPU_PER_SESSION KERNEL  UNLIMITED

DEFAULT         CPU_PER_CALL KERNEL  UNLIMITED

DEFAULT         LOGICAL_READS_PER_SESSION KERNEL  UNLIMITED

DEFAULT         LOGICAL_READS_PER_CALL KERNEL  UNLIMITED

DEFAULT         IDLE_TIME KERNEL  UNLIMITED

DEFAULT         CONNECT_TIME KERNEL  UNLIMITED

DEFAULT         PRIVATE_SGA KERNEL  UNLIMITED

DEFAULT         FAILED_LOGIN_ATTEMPTS PASSWORD 10

DEFAULT         PASSWORD_LIFE_TIME PASSWORD 180

DEFAULT         PASSWORD_REUSE_TIME PASSWORD UNLIMITED

DEFAULT         PASSWORD_REUSE_MAX PASSWORD UNLIMITED

DEFAULT         PASSWORD_VERIFY_FUNCTION  PASSWORD NULL

DEFAULT         PASSWORD_LOCK_TIME PASSWORD 1

DEFAULT         PASSWORD_GRACE_TIME PASSWORD 7

16 rows selected.

SQL> ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;

Profile altered.

SQL> SELECT * FROM DBA_PROFILES;

PROFILE         RESOURCE_NAME RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT         COMPOSITE_LIMIT KERNEL  UNLIMITED

DEFAULT         SESSIONS_PER_USER KERNEL  UNLIMITED

DEFAULT         CPU_PER_SESSION KERNEL  UNLIMITED

DEFAULT         CPU_PER_CALL KERNEL  UNLIMITED

DEFAULT         LOGICAL_READS_PER_SESSION KERNEL  UNLIMITED

DEFAULT         LOGICAL_READS_PER_CALL KERNEL  UNLIMITED

DEFAULT         IDLE_TIME KERNEL  UNLIMITED

DEFAULT         CONNECT_TIME KERNEL  UNLIMITED

DEFAULT         PRIVATE_SGA KERNEL  UNLIMITED

DEFAULT         FAILED_LOGIN_ATTEMPTS PASSWORD 10

DEFAULT         PASSWORD_LIFE_TIME PASSWORD UNLIMITED

DEFAULT         PASSWORD_REUSE_TIME PASSWORD UNLIMITED

DEFAULT         PASSWORD_REUSE_MAX PASSWORD UNLIMITED

DEFAULT         PASSWORD_VERIFY_FUNCTION  PASSWORD NULL

DEFAULT         PASSWORD_LOCK_TIME PASSWORD 1

DEFAULT         PASSWORD_GRACE_TIME PASSWORD 7

SQL> connect sys 
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

SQL> connect sys as sysdba

Enter password: 

Connected.

-- USER IN LOCK

SQL> alter user sys identified by PASS account unlock;

User altered.

[oracle@svr-oracle01 ~]$ sqlplus sys/PASS@oralee

SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 28 10:50:23 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Enter user-name: 

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name: 

ERROR:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

[oracle@svr-oracle01 ~]$ oerr ORA 28009

28009, 00000, "connection as SYS should be as SYSDBA or SYSOPER"

// *Cause:    connect SYS/<password> is no longer a valid syntax

// *Action:   Try connect SYS/<password> as SYSDBA or

//            connect SYS/<password> as SYSOPER

//

[oracle@svr-oracle01 ~]$ sqlplus sys/PASS as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Nov 28 10:51:28 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> exit

# ALTER PASS

SQL> alter user USER identified by PASS;

User altered.

Read More

Oracle - Listener

Examples:

-- SQL> ALTER SYSTEM SET service_names='svr_oracle_prd.com.br' SCOPE=MEMORY SID='orcl_prd';

-- SQL> show parameter service_names;

NAME     TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names     string svr_oracle_prd.com.br




oracle@svr-oracle01 trace]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 28-NOV-2013 10:05:19

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                27-NOV-2013 01:08:38
Uptime                    1 days 8 hr. 56 min. 40 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/grid/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/svr-oracle01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.20.57)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.20.21)(PORT=1521)))

Edit: 

vim | vi  $ORACLE_HOME/network/admin/tnsnames.ora

NAME_ALIAS_BASE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP_BASE )(PORT = PORT_LISTENER ))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
   (SERVICE_NAME = SERVICE_NAMES )
             )
    )

Read More

Oracle - CONNECT_PERL_CMD

use strict;
use warnings;


my $connect_string = 'username/password@server'; # connection to the DB
my $file = 'test.sql'; # location of SQL file. The file must end with "exit"

my $sqlcmd = "sqlplus -S $connect_string \@$file"; # sqlcommand
system $sqlcmd; # executes command

-

use warnings;
use DBI;
use strict;

my $user = 'system';
my $passwd = 'pass';
my $dbh = DBI->connect("dbi:Oracle:host=192.168.0.208;sid=ORAPRD;  port=1521", $user, $passwd)  || die "Database connection not made: $DBI::errstr";
$dbh->disconnect;

Read More

Oracle - Alter case sensitive

Oracle Database 11g Release 11.2.0.3.0 - 64bit Production

SQL> show parameter case

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------
sec_case_sensitive_logon             boolean     TRUE
SQL> alter system set sec_case_sensitive_logon=false;

Sistema alterado.

SQL> show parameter case;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------
sec_case_sensitive_logon             boolean     FALSE
SQL>

Read More

Oracle - Analyze Template for Windows

FILE 1 *.bat

set ORACLE_HOME=D:\oracle\product\10.2.0\db_1\BIN\
set PATH=D:\oracle\product\10.2.0\db_1\BIN\

set ORACLE_SID=STDBY
sqlplus USER/PASS @D:\scripts\Analyze.sql

exit;

FILE 2 *.sql

set linesize 180
set pagesize 5000

alter session set nls_date_format='DD/MM/YYYY HH24:MI:SS';
spool D:\scripts\analyze.log
select sysdate from dual;

--select owner,SEGMENT_NAME from dba_segments where SEGMENT_NAME='TB_NAME';

--select owner, object_name, object_type  from ALL_OBJECTS where object_name ='TB_NAME';

exec dbms_stats.gather_schema_stats(ownname=>'OWNER',tabname=>'TB_NAME',cascade=>true,options=>'GATHER');

exec dbms_stats.gather_table_stats(ownname=>'OWNER',tabname=>'TB_NAME',cascade=>true);

spool off

exit;

Read More

Oracle - Changing Datafile Size [ Alter autoextend / maxsize ]

#!/usr/bin/perl
use strict;
use warnings;

#select file_id ,Tablespace_name, file_name, bytes/1024/1024 mbytes, AUTOEXTENSIBLE, MAXBYTES/1024/1024 maxbytes, INCREMENT_BY nextmb from dba_data_files where Tablespace_name='SYSAUX';

#select file_id, file_name, bytes/1024/1024 mbytes, AUTOEXTENSIBLE, MAXBYTES/1024/1024 maxbytes, INCREMENT_BY nextmb from dba_data_files where Tablespace_name='TS_DATA_01';


#column file_name format a45;
#select file_id ,file_name,Tablespace_name from dba_data_files;


my @to_8000 = (1..10);
my @to_4000 = (1..10);

print "\nproducao\n";

for (@to_8000){
   
    print "alter database datafile $_ autoextend on next 500m maxsize 8000m;\n";
   
}  

print "\naerp\n";

for (@to_4000){
   
    print "alter database datafile $_ autoextend on next 500m maxsize 4000m;\n";
   
}  

Example:


producao
alter database datafile 1 autoextend on next 500m maxsize 8000m;
alter database datafile 2 autoextend on next 500m maxsize 8000m;

stdby
alter database datafile 1 autoextend on next 500m maxsize 4000m;
alter database datafile 2 autoextend on next 500m maxsize 4000m;
alter database datafile 3 autoextend on next 500m maxsize 4000m;
alter database datafile 4 autoextend on next 500m maxsize 4000m;
alter database datafile 5 autoextend on next 500m maxsize 4000m;
alter database datafile 6 autoextend on next 500m maxsize 4000m;

Read More

Oracle - Alter database to archivelog mode

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     208

Current log sequence           218

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 5745586176 bytes

Fixed Size                  2238736 bytes

Variable Size            3791652592 bytes

Database Buffers         1946157056 bytes

Redo Buffers                5537792 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     208

Next log sequence to archive   218

Current log sequence           218

Read More

Parameter on bash.

MacBook-de-Andre-Silva als$ cat tmp.sh
#!/bin/bash

echo spool  /home/analyze_$2.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_parameter
spool /home/analyze_info_parameter.log
MacBook-de-Andre-Silva als$ ./tmp.sh - info_number
spool /home/analyze_info_number.log
MacBook-de-Andre-Silva als$

Read More

Script Rename File / Windows / Expdp

@echo off
Rem Get Day,Mth & Year from %Date%
set Day=%Date:~0,2%
set Mth=%Date:~3,2%
set Yr=%Date:~6,4%
ren 1.txt 1_%Day%-%Mth%-%Yr%_I.txt

@echo off
ren texte.txt texte_%Date:~0,2%%Date:~3,2%%Date:~6,4%.txt


set ORACLE_SID=TEST

C:\oracle\app\Administrador\product\11.2.0\dbhome_1\BIN\expdp.exe siltech/siltech@INSTANCE parfile=F:\Oracle\Backup\expdp.par

rename F:\export\expfull_TEST.log expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.log
       
rename F:\export\EXPFULL_TEST.dmp expfull_TEST_%Date:~0,2%%Date:~3,2%%Date:~6,4%.dmp
       
forfiles -p "F:\export\" -d -5 -m *.dmp -c "cmd /c del /f /q @path"

Read More

Bytecode [ Perlcc is dead on RedHat 6.* -> PP new Solution ]

#Commands
CD_IN='cd'
CD_OUT='cd ..'
TAR='tar -xvzf'
PERL_MAKEFILE='perl Makefile.PL'
MAKE='make'
MAKE_INSTALL='make install'
CHMOD='chmod +x Makefile'

#Module
M1=IO-Compress-2.060
M2=Archive-Zip-1.30
M3=Getopt-ArgvFile-1.11
M4=Module-ScanDeps-1.10
M5=PAR-1.007
M6=PAR-Dist-0.49
M7=AutoLoader-5.73
M8=Compress-Raw-Zlib-2.060
M9=AutoLoader-5.73
M10=CPAN-Meta-Requirements-2.122
M11=CPAN-Meta-YAML-0.008
M12=JSON-PP-2.27202
M13=Parse-CPAN-Meta-1.4404
M14=version-0.9902
M15=CPAN-Meta-2.130880
M16=Perl-OSType-1.003
M17=Module-Metadata-1.000011
M18=Module-Build-0.4004
M19=Text-ParseWords-3.29
M20=Test-Harness-3.26
M21=Time-Local-1.2300
M22=File-Path-2.09
M23=File-Temp-0.2301
M24=Test-Simple-0.98
M25=PathTools-3.40
M26=ExtUtils-MakeMaker-6.66
M27=IO-1.25

#Uncompress
FILE_GZ=`ls *.gz`
for i in ${FILE_GZ} ; do \
       ${TAR} ${i}
done;

#Execute Install
for i in ${M1} ${M2} ${M3} ${M4} ${M5} ${M6} ${M7} ${M8} ${M9} ${M10} ${M11} ${M12} ${M13} ${M14} ${M15} ${M16} ${M17} ${M18} ${M19} ${M20} ${M21} ${M22} ${M23} ${M24} ${M25} ${M26} ${M27} ${M28} ${M29} ; do \
${CD_IN} ${i}
${PERL_MAKEFILE}
${CHMOD}
${MAKE}
${MAKE_INSTALL}
${CD_OUT}
done;

Read More

Reser Tablet ZTE

Emergency Call + *983*987#

Read More

Windows / FORFILES - [ To delete old archives ]

command : Forfiles
-p  = PATH
-d  = DAYS
-m = REGEX
-c  = NEW COMMAND


C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl

"IdaDB_03122012.pl"
"IdaDB_Windows_SRV.pl"
"IdaDB_Windows_SRV_03122012.pl"
"tmp1.pl"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl -c "cmd /c del /f /q @path"

C:\Users\Administrador\Desktop\IDADB_TEST>forfiles -p "C:\Users\Administrador\De
sktop\IDADB_TEST" -d -80 -m *.pl
ERRO: Nenhum arquivo encontrado com os critérios de pesquisa especificados.

Read More

ORACLE - [ spreport ]

1:
SQL> exec perfstat.statspack.snap

2:
SQL> exec perfstat.statspack.snap

3:
SQL> @$ORACLE_HOME/rdbms/admin/spreport

Read More

ORACLE - NLS_LANG

SQL> select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

NAME          VALUE
------------- ----------------------------------------------------------------
LANGUAGE      AMERICAN
TERRITORY     AMERICA
CHARACTER SET WE8ISO8859P1

SQL> exit

NLS_LANG=<LANGUAGE>_<TERRITORY>.<CHARACTER SET>

C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

C:\>echo %NLS_LANG%
AMERICAN_AMERICA.WE8ISO8859P1

Read More

Rman catalog - Time Retention

SQL> show parameter keep

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
buffer_pool_keep                     string
control_file_record_keep_time        integer     7
db_keep_cache_size                   big integer 0

Read More

Oracle Rman Show Backups

select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation = 'BACKUP'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time
SQL> /

OPERACAO   TIPO          STATUS     MEDIA      DATA                TAMANHO(MB)
---------- ------------- ---------- ---------- ------------------- -----------
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   04-02-2013 09:17:55       19.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   04-02-2013 12:05:11        6.48
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   05-02-2013 00:06:20        3.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_TAPE   05-02-2013 12:05:38        8.61

Read More

ORACLE / RMAN - Status

set pages 120
set lines 120
column MEDIA format a10
column STATUS format a10
column OPERACAO format a10

select operation as "OPERACAO",
object_type as "TIPO",
status,
output_device_type as "MEDIA",
to_char(end_time,'DD-MM-RRRR HH24:MI:SS') as "DATA",
round(MBYTES_PROCESSED/1024,2) as "TAMANHO(MB)"
from
v$rman_status
where
operation <> 'CATALOG'
and trunc(end_time)>=trunc(sysdate-1)
order by
end_time;



OPERACAO   TIPO          STATUS     MEDIA DATA                TAMANHO(MB)
---------- ------------- ---------- ----- ------------------- -----------
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 09:17:55       19.87
APE
RMAN                     COMPLETED        04-02-2013 09:17:56       19.87
BACKUP     ARCHIVELOG    COMPLETED  SBT_T 04-02-2013 12:05:11        6.48
APE
RMAN                     COMPLETED        04-02-2013 12:05:11        6.48
LIST       DB FULL       COMPLETED        04-02-2013 18:15:50           0
RMAN                     COMPLETED        04-02-2013 18:22:16           0
LIST       DB FULL       COMPLETED        04-02-2013 18:22:48           0
RMAN                     COMPLETED        04-02-2013 18:27:21           0

---------------------------------------------------////---------------------------------------------------------------


[oracle@Linux ~]$ export NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS"
[oracle@Linux ~]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Tue Feb 5 07:47:28 2013

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: RM (DBID=2664802127)

RMAN> list backup ;

Read More

Oracle - [ Alter Database Datafile ]

 1* select file_id,file_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files order by file_id
SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024
---------- ------------------------------ --------------- ------------------
1 +DSKDATA/oralee/datafile/syste      740  32767.9844
  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810  32767.9844
  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815  32767.9844
  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000
  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000
  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200  32767.9844
  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25  32767.9844
  .341.783430401

SQL> alter database datafile 1 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> alter database datafile 2 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> l

  1* alter database datafile 2 autoextend on next 500m maxsize 8000m

SQL> c/2/3/

  1* alter database datafile 3 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> c/3/4/

  1* alter database datafile 4 autoextend on next 500m maxsize 8000m

SQL> c/4/6/

  1* alter database datafile 6 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> c/6/7/

  1* alter database datafile 7 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> set pages 120

SQL> set lines 100

SQL> column file_name format a30

SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024

---------- ------------------------------ --------------- ------------------

1 +DSKDATA/oralee/datafile/syste      740 8000

  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810 8000

  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815 8000

  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000

  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000

  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200 8000

  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25 8000

  .341.783430401

7 rows selected.

Read More

Oracle [ Size by Partitions ]

How do I know if an object is partitioned or not?


SELECT * FROM dba_tab_partitions WHERE table_name = '<table_name>';

SELECT * FROM dba_ind_partitions WHERE index_name = '<index_name>';

1 -Partitions = NO

select owner, segment_type, segment_name, bytes/1024/1024 mbytes
from dba_segments
where segment_name = 'TABLE_NAME';

2 - Partitions = YES

select seg.OWNER , seg.PARTITION_NAME, seg.SEGMENT_NAME , seg.BYTES/1024/1024 mbytes from dba_segments seg
inner join dba_tab_partitions part
on seg.SEGMENT_NAME=part.TABLE_NAME
and seg.owner = part.table_owner
where part.TABLE_NAME='TABLE_NAME';

Read More

Perl with SQLServer -> =)

use DBI;

my $dsn = 'DBI:ODBC:Driver={SQL Server}';
my $host = 'WINSRV';
my $database = 'Relatorios';
my $user = 'sa';
my $auth = 'm1f1g1f4$';


my $dbh = DBI -> connect( "dbi:ODBC:driver={SQL Server};server={$host};Trusted Connection=yes, $user, $auth { PrintError => 0,RaiseError => 0,}") or die "\n\nthe mssql connection died with the following error: \n\n$DBI::errstr\n\n";

my $sth = $dbh->prepare('SELECT *  FROM sys.tables');

$sth->execute();

while(my @result = $sth->fetchrow_array() ){
        print join ("\t",@result),"\n";
}

$dbh->disconnect();

Read More

Perl Date Time [ yyyymmdd ]

#!/usr/bin/perl

my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst)=localtime(time);

my $yyyy_mm_dd = sprintf( "%4d%02d%02d", $year+1900,$mon+1,$mday );

print "$yyyy_mm_dd\n";

use POSIX;

my $DateTime = strftime "%F", localtime $^T;

$DateTime =~ s/-//g;

print "$DateTime";

Read More