Neste artigo vamos instalar o Oracle RAC 12c (12.1) no Oracle Linux 6 Usando VirtualBox 5, preferi iniciar pelo Oracle 12.1, para podermos realizar a migração para o Oracle 12.2 em um novo artigo. Para começar vamos baixar os instaladores do Oracle. Oracle Database 12c Release 1 (12.1.0.2.0) for Linux x86-64 http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Oracle Database 12c Release 1 Grid Infrastructure (12.1.0.2.0) for Linux x86-64 http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html Criando a Máquina Virtual Antes de iniciar, crie uma pasta com o[…]
Read moreCategoria: Database
ORA-28040: No matching authentication protocol ocilogon():
Uma Solução de contorno para o erro é , acessar o diretório $ORACLE_HOME/network/admin/ e adicionar os parâmetros abaixo no sqlnet.ora. SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
|
1 2 3 4 5 6 |
cd $ORACLE_HOME/network/admin/ vi sqlnet.ora SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 |
Read more
Can’t locate Env.pm in @INC
O erro abaixo ocorreu quando eu tentava executar o rootcrs.pl -unlock no banco oracle 12.2 com OL7
|
1 2 3 4 5 |
[root@zmsolution1install]# ./rootcrs.pl -unlock Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . . ./../../perl/lib) at crsinstall.pm line 286. BEGIN failed--compilation aborted at crsinstall.pm line 286. Compilation failed in require at ./rootcrs.pl line 165. BEGIN failed--compilation aborted at ./rootcrs.pl line 165. |
Para solucionar o problema executei uma busca com o comando locate para saber onde tinha o arquivo e após copiei para o diretorio que o Oracle estava buscando.
|
1 2 3 4 5 6 7 8 |
locate Env.pm /u01/app/oracle/product/12.2.0/db_1/perl/lib/5.22.0/Env.pm /u01/app/oracle/product/12.2.0/db_1/perl/lib/5.22.0/TAP/Harness/Env.pm /u01/app/oracle/product/12.2.0/grid/perl/lib/5.22.0/Env.pm /u01/app/oracle/product/12.2.0/grid/perl/lib/5.22.0/TAP/Harness/Env.pm /u01/install/grid/perl/lib/5.22.0/Env.pm /u01/install/grid/perl/lib/5.22.0/TAP/Harness/Env.pm |
|
1 |
cp /u01/install/grid/perl/lib/5.22.0/Env.pm /usr/share/perl5/vendor_perl |
Agora vou executar o comando novamente.
|
1 2 3 4 5 6 7 |
[root@zmsolution1 install]# ./rootcrs.pl -unlock Using configuration parameter file: ./crsconfig_params The log of current session can be found at: /u01/app/oracle/crsdata/s00lnx95/crsconfig/crsunlock_s00lnx95_2018-04-24_12-05-58AM.log 2018/04/24 12:06:08 CLSRSC-357: Failed to stop current Oracle Clusterware stack during upgrade 2018/04/24 12:06:09 CLSRSC-347: Successfully unlock /u01/app/oracle/product/12.2.0/grid [root@zmsolution1 install]# |
Read more
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr]
Em bases que o archivelog não esta ativado corremos muitos riscos, entre ele o risco de termos o erro: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr] , esse erro podo ocorrer de muitas formas : This Problem is caused by Storage Problem of the Database Files. The Subsystem (eg. SAN) crashed while the Database was open. The Database then crashed because the Database Files were not accessible anymore. This caused a lost Write into the Online RedoLogs[…]
Read moreInstalando o Oracle SOA 12.2.1 – Parte 1
Parte 1 – Criando o Banco de Dados. Nesse artigo vou instalar o Oracle 12c r2 que será o nosso repositório na instalação do SOA 12.2.1 . 1- Instalando os pacotes necessários.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
yum install binutils -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y yum install zlib-devel –y yum install zlib-devel.i686 -y yum -y install unixODBC unixODBC.i686 unixODBC-devel unixODBC-devel.i686 yum -y install oracleasm-support |
|
1 2 3 4 |
wget http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.4-1.el6.x86_64.rpm rpm -Uvh oracleasmlib-2.0.4-1.el6.x86_64.rpm Preparing... ########################################### [100%] 1:oracleasmlib ########################################### [100%] |
Adicione as linhas no arquivo “/etc/sysctl.conf”.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 # Recommended value for kernel.panic_on_oops kernel.panic_on_oops = 1 |
|
1 |
/sbin/sysctl -p |
Adicione as linhas no arquivo “/etc/security/limits.conf”.
|
1 2 3 4 5 6 7 8 9 10 11 |
oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 grid soft nofile 1024 grid hard nofile 65536 grid soft nproc 2047 grid hard nproc 16384 |
Criando usuários e grupos:
|
1 2 3 4 5 6 |
groupadd -g 1000 oinstall groupadd -g 1200 asmadmin groupadd -g 1201 asmdba groupadd -g 1202 asmoper groupadd -g 1300 dba groupadd -g 1301 oper |
|
1 2 |
useradd -m -u 1100 -g oinstall -G asmadmin,asmdba,asmoper -d /home/grid -s /bin/bash grid useradd -m -u 1101 -g oinstall -G dba,oper,asmdba -d /home/oracle -s /bin/bash oracle |
Criando os Diretórios:
|
1 2 3 4 5 6 7 |
mkdir -p /u01/app/oracle mkdir -p /u01/app/oracle/product/12.2.0.1/grid chown -R grid:oinstall /u01/app/ chmod -R 775 /u01/ mkdir -p /u01/app/oracle/product/12.2.0.1/db_1 chown oracle:oinstall /u01/app/oracle/product/12.2.0.1/db_1 chmod -R 775 /u01/ |
Na máquina altere o SELinux de “enforcing” para “permissive”. vi /etc/selinux/config Desabilite o firewall.
|
1 2 |
chkconfig iptables off chkconfig ip6tables off |
Formatando um novo disco[…]
Read moreReparando invalid Oracle Database Packages and Type
Normalmente encontro mais esse problema de objetos invalidos na dba_registry apos uma migração , só que dessa vez foi antes de migrar mesmo :(, segue a correção
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10)comp_id,substr(version,1,12) version,status from dba_registry; 2 COMP_NAME COMP_ID VERSION STATUS ------------------------------ ---------- ------------ ----------- Oracle Database Catalog Views CATALOG 10.2.0.4.0 VALID Oracle Database Packages and T CATPROC 10.2.0.4.0 INVALID Oracle Workspace Manager OWM 10.2.0.4.3 VALID JServer JAVA Virtual Machine JAVAVM 10.2.0.4.0 VALID Oracle XDK XML 10.2.0.4.0 VALID Oracle Database Java Packages CATJAVA 10.2.0.4.0 VALID Oracle Expression Filter EXF 10.2.0.4.0 VALID Oracle Data Mining ODM 10.2.0.4.0 VALID Oracle Text CONTEXT 10.2.0.4.0 VALID Oracle XML Database XDB 10.2.0.4.0 VALID Oracle Rule Manager RUL 10.2.0.4.0 VALID COMP_NAME COMP_ID VERSION STATUS ------------------------------ ---------- ------------ ----------- Oracle interMedia ORDIM 10.2.0.4.0 VALID OLAP Analytic Workspace APS 10.2.0.4.0 VALID Oracle OLAP API XOQ 10.2.0.4.0 VALID OLAP Catalog AMD 10.2.0.4.0 VALID Spatial SDO 10.2.0.4.0 VALID Oracle Enterprise Manager EM 10.2.0.4.0 VALID Oracle Real Application Cluste RAC 10.2.0.4.0 VALID Oracle Application Express APEX 3.1.2.00.02 VALID 19 rows selected. SQL> select count(*) from dba_objects where status='INVALID'; COUNT(*) ---------- 92 |
Vamos executar os scripts catalog.sql,catproc.sql,utlrp.sql
|
1 2 3 4 5 |
sqlplus / as sysdba SQL> startup restrict SQL > @?/rdbms/admin/catalog.sql SQL > @?/rdbms/admin/catproc.sql SQL > @?/rdbms/admin/utlrp.sql |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup restrict ORACLE instance started. Total System Global Area 2.1475E+10 bytes Fixed Size 2122368 bytes Variable Size 1.0754E+10 bytes Database Buffers 1.0704E+10 bytes Redo Buffers 14651392 bytes Database mounted. Database opened. SQL>Total System Global Area 2.1475E+10 bytes Fixed Size 2122368 bytes Variable Size 1.0754E+10 bytes Database Buffers 1.0704E+10 bytes Redo Buffers 14651392 bytes Database mounted. Database opened. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
SQL> @?/rdbms/admin/catalog.sql DOC>###################################################################### DOC>###################################################################### DOC> The following statement will cause an "ORA-01722: invalid number" DOC> error and terminate the SQLPLUS session if the user is not SYS. DOC> Disconnect and reconnect with AS SYSDBA. DOC>###################################################################### DOC>###################################################################### DOC># no rows selected Package created. Package body created. Grant succeeded. Package created. Synonym created. Grant succeeded. Grant succeeded. PL/SQL procedure successfully completed. SQL> SQL> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
SQL> @?/rdbms/admin/catproc.sql DOC>###################################################################### DOC>###################################################################### DOC> The following PL/SQL block will cause an ORA-20000 error and DOC> terminate the current SQLPLUS session if the user is not SYS. DOC> Disconnect and reconnect with AS SYSDBA. DOC>###################################################################### DOC>###################################################################### DOC># PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. View created. View created. Comment created. Comment created. Comment created. Comment created. .... SQL> execute ORACLE_OCM.MGMT_CONFIG.run_now; PL/SQL procedure successfully completed. SQL> SQL> SQL> Rem ADD NEW PACKAGES/NEW POST CATPROC FIXED VIEWS ABOVE THIS BLOCK SQL> ------------------------------------------------------------------------------ SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> Rem Indicate CATPROC load complete and check validity SQL> BEGIN 2 dbms_registry.update_schema_list('CATPROC', 3 dbms_registry.schema_list_t('SYSTEM', 'OUTLN', 'DBSNMP')); 4 dbms_registry.loaded('CATPROC'); 5 dbms_registry_sys.validate_catproc; 6 dbms_registry_sys.validate_catalog; 7 END; 8 / PL/SQL procedure successfully completed. SQL> SQL> SET SERVEROUTPUT OFF |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 |
SQL> @?/rdbms/admin/utlrp.sql SQL> Rem SQL> Rem $Header: utlrp.sql 24-jul-2003.10:06:51 gviswana Exp $ SQL> Rem SQL> Rem utlrp.sql SQL> Rem SQL> Rem Copyright (c) 1998, 2003, Oracle Corporation. All rights reserved. SQL> Rem SQL> Rem NAME SQL> Rem utlrp.sql - Recompile invalid objects SQL> Rem SQL> Rem DESCRIPTION SQL> Rem This script recompiles invalid objects in the database. SQL> Rem SQL> Rem MODIFIED (MM/DD/YY) SQL> Rem rburns 03/17/05 - use dbms_registry_sys SQL> Rem gviswana 02/07/05 - Post-compilation diagnostics SQL> Rem gviswana 09/09/04 - Auto tuning and diagnosability SQL> Rem rburns 09/20/04 - fix validate_components SQL> Rem gviswana 12/09/03 - Move functional-index re-enable here SQL> Rem gviswana 06/04/03 - gviswana_bug-2814808 SQL> Rem gviswana 05/28/03 - Created SQL> Rem SQL> SQL> SET VERIFY OFF; SQL> SQL> SELECT dbms_registry_sys.time_stamp('utlrp_bgn') as timestamp from dual; TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2018-02-15 10:08:43 1 row selected. SQL> SQL> DOC DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC> objects in the database. Recompilation time is proportional to the DOC> number of invalid objects in the database, so this command may take DOC> a long time to execute on a database with a large number of invalid DOC> objects. DOC> DOC> Use the following queries to track recompilation progress: DOC> DOC> 1. Query returning the number of invalid objects remaining. This DOC> number should decrease with time. DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6); DOC> DOC> 2. Query returning the number of objects compiled so far. This number DOC> should increase with time. DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED; DOC> DOC> This script automatically chooses serial or parallel recompilation DOC> based on the number of CPUs available (parameter cpu_count) multiplied DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu). DOC> On RAC, this number is added across all RAC nodes. DOC> DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel DOC> recompilation. Jobs are created without instance affinity so that they DOC> can migrate across RAC nodes. Use the following queries to verify DOC> whether UTL_RECOMP jobs are being created and run correctly: DOC> DOC> 1. Query showing jobs created by UTL_RECOMP DOC> SELECT job_name FROM dba_scheduler_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC> DOC> 2. Query showing UTL_RECOMP jobs that are running DOC> SELECT job_name FROM dba_scheduler_running_jobs DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%'; DOC># SQL> SQL> DECLARE 2 threads pls_integer := &&1; 3 BEGIN 4 utl_recomp.recomp_parallel(threads); 5 END; 6 / PL/SQL procedure successfully completed. SQL> SQL> SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual; TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_END 2018-02-15 10:11:31 1 row selected. SQL> SQL> Rem SQL> Rem Re-enable functional indexes disabled by the recompile SQL> Rem SQL> DECLARE 2 TYPE tab_char IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER; 3 commands tab_char; 4 table_exists number; 5 BEGIN 6 -- Check for existence of the table marking disabled functional indices 7 SELECT count(*) INTO table_exists FROM DBA_OBJECTS 8 WHERE owner = 'SYS' and object_name = 'UTLIRP_ENABLED_FUNC_INDEXES' and 9 object_type = 'TABLE'; 10 11 IF (table_exists > 0) THEN 12 -- Select indices to be re-enabled 13 EXECUTE IMMEDIATE q'+ 14 SELECT 'ALTER INDEX "' || u.name || '"."' || o.name || '" ENABLE' 15 FROM utlirp_enabled_func_indexes e, ind$ i, obj$ o, user$ u 16 WHERE e.obj# = i.obj# AND i.obj# = o.obj# and o.owner# = u.user# 17 AND bitand(i.flags, 1024) != 0+' 18 BULK COLLECT INTO commands; 19 20 IF (commands.count() > 0) THEN 21 FOR i IN 1 .. commands.count() LOOP 22 EXECUTE IMMEDIATE commands(i); 23 END LOOP; 24 END IF; 25 26 EXECUTE IMMEDIATE 'DROP TABLE utlirp_enabled_func_indexes'; 27 END IF; 28 END; 29 / PL/SQL procedure successfully completed. SQL> SQL> DOC DOC> The following query reports the number of objects that have compiled DOC> with errors (objects that compile with errors have status set to 3 in DOC> obj$). If the number is higher than expected, please examine the error DOC> messages reported with each object (using SHOW ERRORS) to see if they DOC> point to system misconfiguration or resource constraints that must be DOC> fixed before attempting to recompile these objects. DOC># SQL> select COUNT(*) "OBJECTS WITH ERRORS" from obj$ where status = 3; OBJECTS WITH ERRORS ------------------- 88 1 row selected. SQL> SQL> SQL> DOC DOC> The following query reports the number of errors caught during DOC> recompilation. If this number is non-zero, please query the error DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors DOC> are due to misconfiguration or resource constraints that must be DOC> fixed before objects can compile successfully. DOC># SQL> select COUNT(*) "ERRORS DURING RECOMPILATION" from utl_recomp_errors; ERRORS DURING RECOMPILATION --------------------------- 4 1 row selected. SQL> SQL> SQL> Rem ===================================================================== SQL> Rem Run component validation procedure SQL> Rem ===================================================================== SQL> SQL> SET serveroutput on SQL> EXECUTE dbms_registry_sys.validate_components; PL/SQL procedure successfully completed. SQL> SET serveroutput off SQL> SQL> SQL> Rem =========================================================================== SQL> Rem END utlrp.sql SQL> Rem =========================================================================== SQL> SQL> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) comp_id,substr(version,1,12) version,status from dba_registry; 2 COMP_NAME COMP_ID VERSION STATUS ------------------------------ ---------- ------------ ----------- Oracle Database Catalog Views CATALOG 10.2.0.4.0 VALID Oracle Database Packages and T CATPROC 10.2.0.4.0 VALID Oracle Workspace Manager OWM 10.2.0.4.3 VALID JServer JAVA Virtual Machine JAVAVM 10.2.0.4.0 VALID Oracle XDK XML 10.2.0.4.0 VALID Oracle Database Java Packages CATJAVA 10.2.0.4.0 VALID Oracle Expression Filter EXF 10.2.0.4.0 VALID Oracle Data Mining ODM 10.2.0.4.0 VALID Oracle Text CONTEXT 10.2.0.4.0 VALID Oracle XML Database XDB 10.2.0.4.0 VALID Oracle Rule Manager RUL 10.2.0.4.0 VALID Oracle interMedia ORDIM 10.2.0.4.0 VALID OLAP Analytic Workspace APS 10.2.0.4.0 VALID Oracle OLAP API XOQ 10.2.0.4.0 VALID OLAP Catalog AMD 10.2.0.4.0 VALID Spatial SDO 10.2.0.4.0 VALID Oracle Enterprise Manager EM 10.2.0.4.0 VALID Oracle Real Application Cluste RAC 10.2.0.4.0 VALID Oracle Application Express APEX 3.1.2.00.02 VALID 19 rows selected. |
Problema resolvido!
Read moreOracle 12c Grid Infrastructure for a Standalone Server on Oracle Linux 7
Nesse artigos ,vou mostra passo a passo como instalar o Oracle Grid infrastrutura 12.2 for a Standalone Server . Instalando pacotes
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 |
yum install binutils -y yum install compat-libcap1 -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libXi -y yum install libXi.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install make -y yum install nfs-utils -y yum install net-tools -y yum install smartmontools -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel –y yum install binutils -y yum install compat-libstdc++-33 -y yum install compat-libstdc++-33.i686 -y yum install gcc -y yum install gcc-c++ -y yum install glibc -y yum install glibc.i686 -y yum install glibc-devel -y yum install glibc-devel.i686 -y yum install ksh -y yum install libgcc -y yum install libgcc.i686 -y yum install libstdc++ -y yum install libstdc++.i686 -y yum install libstdc++-devel -y yum install libstdc++-devel.i686 -y yum install libaio -y yum install libaio.i686 -y yum install libaio-devel -y yum install libaio-devel.i686 -y yum install libXext -y yum install libXext.i686 -y yum install libXtst -y yum install libXtst.i686 -y yum install libX11 -y yum install libX11.i686 -y yum install libXau -y yum install libXau.i686 -y yum install libxcb -y yum install libxcb.i686 -y yum install libXi -y yum install libXi.i686 -y yum install make -y yum install sysstat -y yum install unixODBC -y yum install unixODBC-devel -y yum install zlib-devel -y yum install zlib-devel.i686 –y yum install tigervnc-server |
Altere o arquivo /etc/sysctl.conf vi /etc/sysctl.conf
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 5242880 kernel.shmmax = 10737418240 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 |
Altere o arquivo limits.conf
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
vi /etc/security/limits.conf # Oracle configuration - zmsolution @oinstall soft nproc 16384 @oinstall hard nproc 16384 @oinstall soft nofile 8192 @oinstall hard nofile 65536 @oinstall soft stack 10240 @oinstall hard stack 32768 @oinstall hard memlock 134217728 @oinstall soft memlock 134217728 @root soft nproc 4096 @root hard nproc 16384 @root soft nofile 8192 @root hard nofile 65536 |
Criei os novos usuários e grupos
|
1 2 3 4 5 6 7 8 9 |
groupadd -g 1300 dba groupadd -g 1301 oper groupadd -g 1000 oinstall groupadd -g 1200 asmadmin groupadd -g 1201 asmdba groupadd -g 1202 asmoper useradd -u 1100 -g oinstall -G dba,oper,asmadmin,asmdba,asmoper grid useradd -u 1101 -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle |
Altere as senhas
|
1 2 |
passwd grid passwd oracle |
Edite o arquivo /etc/hosts
|
1 2 3 4 |
vi /etc/hosts 127.0.0.1 localhost.localdomain localhost 192.168.56.101 zmsol1.localdomain zmsol1 |
Desabiltando o SELINUX
|
1 2 3 4 |
Altere o arquivo /etc/selinux/config vi /etc/selinux/config SELINUX=permissive |
Desabilite o firewall
|
1 2 |
systemctl stop firewalld systemctl disable firewalld |
Make sure NTP (Chrony on OL7/RHEL7) is enabled.
|
1 2 |
systemctl enable chronyd.service systemctl start chronyd.service |
Crie os Directórios
|
1 2 3 4 5 6 7 8 9 |
mkdir -p /u01/app/oraInventory chown -R grid:oinstall /u01/app/oraInventory chmod -R 775 /u01/app/oraInventory chmod -R 775 /u01/ mkdir -p /u01/app/oracle/product/12.2.0.1/grid mkdir -p /u01/app/oracle/product/12.2.0.1/db_1 mkdir -p /u01/app/oracle/product/11.2.0.4/db_1 chown -R grid:oinstall /u01 chmod -R 775 /u01/ |
Instalando o ASM
|
1 2 3 4 |
[root@zmsol1 Packages]# rpm -Uvh ./oracleasm-support-2.1.8-3.1.el7.x86_64.rpm Preparing... ################################# [100%] Updating / installing... 1:oracleasm-support-2.1.8-3.1.el7 #################################[100%] |
Note:[…]
Read moreObjetos inválidos apos executar um grant de select no Oracle EBS Release 12.2
No EBS 12.2 foram adicionadas muitas novidades, entre elas a utilização do Edition Bases Redefinition(EBR) no Banco de Dados. O EBR faz com que o EBS trabalhe com versões de objetos no banco facilitando a aplicação de patchs online. Contudo, o EBR tem alguns pontos negativos. Um deles é na hora de executar um grant em um objeto em que esteja ativado o EBR, se o objeto estiver em utilização na hora do grant , vai[…]
Read moreORA-38760: This database instance failed to turn on flashback database
Solução Rapida.. Drop o ponto do FlashBack
|
1 |
SQL> drop restore point VERSION_2_109_0_0; |
Restore point dropped.
|
1 |
SQL> alter database open; |
Database altered.
Read moreDropping Plans e Baselines
Para apagar um Baselines e bem simples , logue como sys e coloque o ID do seu Baselines no bloco abaixo:
|
1 2 3 4 5 6 7 8 9 10 11 |
SET SERVEROUTPUT ON DECLARE l_plans_dropped PLS_INTEGER; BEGIN l_plans_dropped := DBMS_SPM.drop_sql_plan_baseline ( sql_handle => NULL, plan_name => 'SQL_PLAN_4s77gz996aammee82b912'); DBMS_OUTPUT.put_line(l_plans_dropped); END; / |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 28 10:03:25 2017 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security, OLAP, Data Mining and Real Application Testing options SQL> SET SERVEROUTPUT ON DECLARE l_plans_dropped PLS_INTEGER; BEGIN l_plans_dropped := DBMS_SPM.drop_sql_plan_baseline ( sql_handle => NULL, plan_name => 'SQL_PLAN_4s77gz996aammee82b912'); DBMS_OUTPUT.put_line(l_plans_dropped); END; /SQL> 2 3 4 5 6 7 8 9 10 1 PL/SQL procedure successfully completed. |
Read more