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...

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 ------------------------------------------------------------------------------------------------------------------------  ...

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'...

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 $...

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...

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 ...

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...

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;...

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>...

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...

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...

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...

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  ...

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...

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...

Read More

ORACLE - [ spreport ]

1: SQL> exec perfstat.statspack.snap 2: SQL> exec perfstat.statspack.snap 3: SQL> @$ORACLE_HOME/rdbms/admin/sprepor...

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...

Read More

Rman catalog - Time Retention

SQL> show parameter keep NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ buffer_pool_keep                     string control_file_record_keep_time    ...

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  ...

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...

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...

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 ,...

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...

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