Interactive Documentation For 12c

At this link (from OE) you can a easy way to discover the new architecture for Oracle Database 12c.

Interacte Documentation

HTH – Antonio NAVARRO

Advertisements

Can I Have Different Servers In My Oracle RAC?

Today in a working meeting, which was being discussed the possibility of expanding the current capacity of a RAC (this system has two nodes) it was evaluating the possibility of increasing the number of CPUs and system memory. Someone has said that as the machines were very old we could buy a new machine and include it in the cluster. The issue is that current machines are so old that they are no longer sold, so you would have to buy a different machine. Is this possible?, Oracle supported it technically, is like having two types of cabin storage. Keep in mind some of the following limitations (there are more but you should refer to the vendor documentation).

  • All the nodes to run the same Operating System binary, all Windows 2008 or all nodes RedHAT 7 or all nodes Solaris 11…
  • All nodes must be the same architecture (32 or 64 Bit).
  • Nodes that have different hardware configurations (I.E. number of CPUs) are supported.

However, from the standpoint of experience and daily work, this can be a problem if the application does not support balance load or is not designed for it. Apart cluster is unbalanced, of course, there any 100% balanced cluster (nodes may have other applications or databases) and this involves more manual labor by someone (an operator, DBA, …).

HTH – Antonio NAVARRO

Microsoft Announces SQL Server 2016

Last month, Microsoft launched its new version of SQL Server, including proposed improvements I have selected three seem more interesting. Now we will have to see how they work in production environments.

  • AlwaysOn Enhancements.
  • Security Enhancements.
  • Analysis Services tools Enhancements.

Despite its name, this new version is expected to be available sometime during the summer of 2015.

Your can download the new version of SQLSERVER 2016 at the following link;

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016

HTH – Antonio NAVARRO

Run Many Times The Same Procedure

A simple way to submit several times the same process. Of course, DBMS_JOB should not be used any more, and instead use the DBMS_SCHEDULER, but it’s easier using the DBMS_JOB.

ORCL*ANR> CREATE OR REPLACE PROCEDURE WAIT_ONE_MINUTE IS
  2  BEGIN
  3    DBMS_LOCK.SLEEP (60);
  4  END;
  5  /

Advertencia: Procedimiento creado con errores de compilación.  

Elapsed: 00:00:00.12
ORCL*ANR> SHOW ERR
Errores para PROCEDURE WAIT_ONE_MINUTE:

LINE/COL ERROR
________ _________________________________________________________________
3/3      PL/SQL: Statement ignored
3/3      PLS-00201: el identificador 'DBMS_LOCK' se debe declarar

REM
REM From a privilege session like sys execute "grant execute on dbms_lock to anr"
REM 

ORCL*ANR> CREATE OR REPLACE PROCEDURE WAIT_ONE_MINUTE IS
  2   BEGIN
  3     DBMS_LOCK.SLEEP (60);
  4   END;
  5   /

Procedimiento creado.

Elapsed: 00:00:00.06
ORCL*ANR> show parameter job;

NAME                                 TYPE        VALUE
____________________________________ ___________ ______________________________
job_queue_processes                  integer     5

REM
REM Submit 5 times the procedure
REM 

DECLARE 
   job_n PLS_INTEGER;
BEGIN
   FOR N IN 1..5 LOOP 
      DBMS_JOB.SUBMIT ( job_n, 'WAIT_ONE_MINUTE;');              
   END LOOP;
   COMMIT;
END;
/
REM 
REM FROM OTHER SESSION QUERY THE JOBS RUNNIG
REM 

ORCL*ANR> R
  1* SELECT * FROM DBA_JOBS_RUNNING

No Rows selected


ORCL*ANR> R
  1* SELECT * FROM DBA_JOBS_RUNNING

    SID        JOB   FAILURES LAST_DATE            LAST_SEC THIS_DATE            THIS_SEC   INSTANCE
_______ __________ __________ ____________________ ________ ____________________ ________ __________
   4367    3362223 ø          ø                    ø        10/JUN/2015 15:00:33 15:00:33          0
   4363    3362225 ø          ø                    ø        10/JUN/2015 15:00:34 15:00:34          0
   4325    3362224 ø          ø                    ø        10/JUN/2015 15:00:33 15:00:33          0
   4341    3362215 ø          ø                    ø        10/JUN/2015 15:00:34 15:00:34          0
   4262    3362221 ø          ø                    ø        10/JUN/2015 15:00:34 15:00:34          0

HTH – Antonio NAVARRO

ORA-00600 Error with [kxfprdp:1] [10387] Parameters

Today I found the following error in the alert.log of a database.

ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002 
ORA-00600: código de error interno  argumentos: [kxfprdp:1]  [10387]  []  []  []  []  []  []ORA-0002

An inactive slave dies and leave a stack trace behind with ora-00600 error. The workaround is none, no action is required.Depending on the architecture that you have can apply A patch or not, in my case for example it is not possible, so my workaround is avoid run the statement that has the problem. The fine solution is upgrade to 10.2.0.5 or more. The problem seems to be related to the Itanium micro.

HTH – Antonio NAVARRO

Boot Sequence Recommended By Oracle

Today a coworker has struggled to give a listener service to a database, but the order does not matter, sometimes It gives these problems. We reviewed more quickly once recommended by Oracle to start the basic components order. also we should note that the listener should be used with “Dynamic Register” this is that the database will search the listener (this makes the pMON), formerly it was used what is called “Static Register” in which the listener look for the database.

– Database control or Enterprise Manager EM.
– Listener – Listener Scan.
– Database.

HTH – Antonio NAVARRO

How To Deactivate Segment Advisor

I have a database that is historic and there are some advisors that have active does not interest me, so I’ll stop SEGMENT ADVISOR to not load the system. A simple and fast way from a session with privileges is as follows;

ORCL*ANTO> SELECT client_name, status FROM dba_autotask_client;                                                                               
                                                                                                    
CLIENT_NAME                                                      STATUS                             
________________________________________________________________ ________                           
auto optimizer stats collection                                  ENABLED                            
auto space advisor                                               ENABLED                            
sql tuning advisor                                               ENABLED                            
                                                                                                    
Transcurrido: 00:00:01.40                                                                           
ORCL*ANTO>  EXEC DBMS_AUTO_TASK_ADMIN.DISABLE(client_name=>'auto space advisor', operation=>NULL, window_name=>NULL);                                                                                   
                                                                                                    
Procedimiento PL/SQL terminado correctamente.                                                       
                                                                                                    
Transcurrido: 00:00:00.07                                                                           
ORCL*ANTO>  SELECT client_name, status FROM dba_autotask_client;                                    
                                                                                                    
CLIENT_NAME                                                      STATUS                             
________________________________________________________________ ________                           
auto optimizer stats collection                                  ENABLED                            
auto space advisor                                               DISABLED                           
sql tuning advisor                                               ENABLED                            

HHT – Antonio NAVARRO