vanberto zuim, Autor em - Página 2 de 4

Instalando o Oracle SOA 12.2.1 – Parte 2

11 de março de 2018 vanberto zuim Apps, EBS, Oracle BPM, Oracle SOA Suite, OSB, Weblogic

Parte 2 – Instalando o Oracle SOA Suíte 12.2.1.3.

yum install  binutils-2.*
yum install  compat-libstdc++-33*
yum install  elfutils-libelf-0.*
yum install  libaio-0.*
yum install  libaio-devel-0.*
yum install  sysstat-9.*
yum install  glibc-2.*
yum install  glibc-common-2.*
yum install  glibc-devel-2.* glibc-headers-2.*
yum install  ksh-2*
yum install  make-3.*
yum install  libgcc-4.*
yum install  libstdc++-4.*
yum install  libstdc++-4.*.i686*
yum install  libstdc++-devel-4.*
yum install  gcc-4.*x86_64*
yum install  gcc-c++-4.*x86_64*
yum install  allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*
yum install  elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*
yum install  libtool-ltdl*i686*
yum install  ncurses*i686*
yum install  readline*i686*
yum install  unixODBC*

yum install binutils-2.*

yum install compat-libstdc++-33*

yum install elfutils-libelf-0.*

yum install libaio-0.*

yum install libaio-devel-0.*

yum install sysstat-9.*

yum install glibc-2.*

yum install glibc-common-2.*

yum install glibc-devel-2.* glibc-headers-2.*

yum install ksh-2*

yum install make-3.*

yum install libgcc-4.*

yum install libstdc++-4.*

yum install libstdc++-4.*.i686*

yum install libstdc++-devel-4.*

yum install gcc-4.*x86_64*

yum install gcc-c++-4.*x86_64*

yum install allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*

yum install elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*

yum install libtool-ltdl*i686*

yum install ncurses*i686*

yum install readline*i686*

yum install unixODBC*

Edite o Arquivo sysctl.conf

vi  /etc/sysctl.conf

fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall=1048576
kernel.shmmax=2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

sysctl –p

vi /etc/sysctl.conf

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall=1048576

kernel.shmmax=2147483648

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

sysctl –p

Criando o Usuário

groupadd -g 521 oinstall
useradd -g oinstall oracle
passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.
Senha oracle

groupadd -g 521 oinstall

useradd -g oinstall oracle

passwd oracle

Changing password for user oracle.

New password:

Retype new password:

passwd: all authentication tokens updated successfully.

Senha oracle

Edite o Arquivo hosts.conf

vi /etc/hosts

127.0.0.1       localhost localhost.localdomain
192.168.56.109   soaapp.localdomain soaapp

vi /etc/hosts

127.0.0.1 localhost localhost.localdomain

192.168.56.109 soaapp.localdomain soaapp

Linux firewall desabilite o firewall.

chkconfig iptables off
chkconfig ip6tables off

1 2	chkconfig iptables off chkconfig ip6tables off

Altere o SELinux de “enforcing” para “permissive”.

vi /etc/selinux/config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
SELINUX=permissive
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted

vi /etc/selinux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - No SELinux policy is loaded.

SELINUX=permissive

# SELINUXTYPE= can take one of these two values:

# targeted - Targeted processes are protected,

# mls - Multi Level Security protection.

SELINUXTYPE=targeted

Editando o arquivo limits.conf

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
@root             soft nproc  4096
@root             hard nproc  16384
@root             soft nofile 8192
@root             hard nofile 65536

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

@root soft nproc 4096

@root hard nproc 16384

@root soft nofile 8192

@root hard nofile 65536

Criando os Diretórios da aplicação:

mkdir -p /u01/app/oracle/product/12.2.1.2/fmw
mkdir -p /u02/middleware/config/domains/
mkdir -p /u02/middleware/config/applications/
mkdir -p /u01/app/oracle/java/
chown -R oracle:oinstall /u01
chmod -R 775 /u01/
chmod -R 775 /u02/

mkdir -p /u01/app/oracle/product/12.2.1.2/fmw

mkdir -p /u02/middleware/config/domains/

mkdir -p /u02/middleware/config/applications/

mkdir -p /u01/app/oracle/java/

chown -R oracle:oinstall /u01

chmod -R 775 /u01/

chmod -R 775 /u02/

Instalando o JAVA(JDK). Faça o download do java no site da Oracle. http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

cp jdk-8u161-linux-x64.tar.gz  /u01/app/oracle/java
tar -xvzf  jdk-8u161-linux-x64.tar.gz

1 2	cp jdk-8u161-linux-x64.tar.gz /u01/app/oracle/java tar -xvzf jdk-8u161-linux-x64.tar.gz

Adicione o JAVA_HOME no .bash_profile do usuario oracle

vi .bash_profile
export JAVA_HOME=/u01/app/oracle/java/jdk1.8.0_161
export PATH=$JAVA_HOME/bin:$PATH

vi .bash_profile

export JAVA_HOME=/u01/app/oracle/java/jdk1.8.0_161

export PATH=$JAVA_HOME/bin:$PATH

Downloads dos instaladores do[…]

Instalando o Oracle SOA 12.2.1 – Parte 1

3 de março de 2018 vanberto zuim Apps, Database, Linux, Oracle BPM, Oracle SOA Suite, OSB, Weblogic

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.

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

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

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%]

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

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

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

/sbin/sysctl -p

1	/sbin/sysctl -p

Adicione as linhas no arquivo “/etc/security/limits.conf”.

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

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:

groupadd -g 1000 oinstall
groupadd -g 1200 asmadmin
groupadd -g 1201 asmdba
groupadd -g 1202 asmoper
groupadd -g 1300 dba
groupadd -g 1301 oper

groupadd -g 1000 oinstall

groupadd -g 1200 asmadmin

groupadd -g 1201 asmdba

groupadd -g 1202 asmoper

groupadd -g 1300 dba

groupadd -g 1301 oper

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

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:

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/

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.

chkconfig iptables off
chkconfig ip6tables off

1 2	chkconfig iptables off chkconfig ip6tables off

Formatando um novo disco[…]

Reparando invalid Oracle Database Packages and Type

16 de fevereiro de 2018 vanberto zuim Database

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

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

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(*)

----------

Vamos executar os scripts catalog.sql,catproc.sql,utlrp.sql

sqlplus / as sysdba
SQL> startup restrict
SQL > @?/rdbms/admin/catalog.sql
SQL > @?/rdbms/admin/catproc.sql
SQL > @?/rdbms/admin/utlrp.sql

sqlplus / as sysdba

SQL> startup restrict

SQL > @?/rdbms/admin/catalog.sql

SQL > @?/rdbms/admin/catproc.sql

SQL > @?/rdbms/admin/utlrp.sql

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.

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.

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>

SQL> @?/rdbms/admin/catalog.sql

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

no rows selected

Package created.

Package body created.

Grant succeeded.

Package created.

Synonym created.

Grant succeeded.

PL/SQL procedure successfully completed.

SQL>

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

SQL> @?/rdbms/admin/catproc.sql

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

PL/SQL procedure successfully completed.

View created.

Comment created.

....

SQL> execute ORACLE_OCM.MGMT_CONFIG.run_now;

PL/SQL procedure successfully completed.

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

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>

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

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;

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;

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

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

1 row selected.

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

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

1 row selected.

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> Rem ===========================================================================

SQL> Rem END utlrp.sql

SQL> Rem ===========================================================================

SQL>

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.

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!

Oracle 12c Grid Infrastructure for a Standalone Server on Oracle Linux 7

14 de fevereiro de 2018 vanberto zuim Database

Nesse artigos ,vou mostra passo a passo como instalar o Oracle Grid infrastrutura 12.2 for a Standalone Server . Instalando pacotes

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

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

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

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

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

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

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

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

passwd grid
passwd oracle

1 2	passwd grid passwd oracle

Edite o arquivo /etc/hosts

vi  /etc/hosts

127.0.0.1      localhost.localdomain   localhost
192.168.56.101 zmsol1.localdomain zmsol1

vi /etc/hosts

127.0.0.1 localhost.localdomain localhost

192.168.56.101 zmsol1.localdomain zmsol1

Desabiltando o SELINUX

Altere o arquivo /etc/selinux/config

vi /etc/selinux/config
SELINUX=permissive

Altere o arquivo /etc/selinux/config

vi /etc/selinux/config

SELINUX=permissive

Desabilite o firewall

systemctl stop firewalld
systemctl disable firewalld

1 2	systemctl stop firewalld systemctl disable firewalld

Make sure NTP (Chrony on OL7/RHEL7) is enabled.

systemctl enable chronyd.service
systemctl start chronyd.service

1 2	systemctl enable chronyd.service systemctl start chronyd.service

Crie os Directórios

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/

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

[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%]

[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:[…]

Objetos inválidos apos executar um grant de select no Oracle EBS Release 12.2

7 de fevereiro de 2018 vanberto zuim Apps, Database, EBS

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[…]

Entendendo a Arvore de Log do EBS 12.2

2 de fevereiro de 2018 vanberto zuim Apps, EBS, Oracle SOA Suite, Weblogic

No Oracle EBS 12.2 mudou bastante os caminhos para encontrarmos os logs que nos ajudam tanto, segue abaixo o desenho da nova arvore de logs do EBS.

Criando um usuário no Oracle EBS por API

31 de janeiro de 2018 vanberto zuim Apps, EBS

As vezes precisamos automatizar o processo de criação de usuários no Oracle EBS ou ter mais agilidade na criação , alguns casos podemos criar os usuários pelo Banco, não necessitando acesso as telas do EBS. Para criar é muito simples. Inicialmente execute o bloco anônimo passado o novo usuário.

DECLARE

v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’);

 v_description VARCHAR2 (100) := ‘new test user';

BEGIN

 fnd_user_pkg.createuser

(x_user_name => v_user_name,

 x_owner => NULL,

 x_unencrypted_password => ‘&input_password’,

 x_session_number => 0,

 x_start_date => SYSDATE,

 x_end_date => NULL,

 x_last_logon_date => NULL,

 x_description => v_description,

 x_password_date => NULL,

 x_password_accesses_left => NULL,

 x_password_lifespan_accesses => NULL,

 x_password_lifespan_days => NULL,

 x_employee_id => NULL,

 x_email_address => NULL,

 x_fax => NULL,

 x_customer_id => NULL,

 x_supplier_id => NULL,

 x_user_guid => NULL,

 x_change_source => NULL

 );

 COMMIT;

END;

 /

SHOW ERR;

DECLARE

v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’);

v_description VARCHAR2 (100) := ‘new test user';

BEGIN

fnd_user_pkg.createuser

(x_user_name => v_user_name,

x_owner => NULL,

x_unencrypted_password => ‘&input_password’,

x_session_number => 0,

x_start_date => SYSDATE,

x_end_date => NULL,

x_last_logon_date => NULL,

x_description => v_description,

x_password_date => NULL,

x_password_accesses_left => NULL,

x_password_lifespan_accesses => NULL,

x_password_lifespan_days => NULL,

x_employee_id => NULL,

x_email_address => NULL,

x_fax => NULL,

x_customer_id => NULL,

x_supplier_id => NULL,

x_user_guid => NULL,

x_change_source => NULL

);

COMMIT;

END;

SHOW ERR;

Esse segundo bloco e para adicionar uma responsabilidade ao novo usuário.

DECLARE

 v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’);

BEGIN

fnd_user_pkg.addresp(username => v_user_name

 ,resp_app => ‘&APPLICATION_SHORT_NAME’

 ,resp_key => ‘&RESPONSIBILITY_KEY’

 ,security_group => ‘STANDARD’

 ,description => NULL

 ,start_date => SYSDATE

 ,end_date => null);

 commit;

END;

 /

SHOW ERR;

DECLARE

v_user_name VARCHAR2 (100) := upper(‘&Enter_User_Name’);

BEGIN

fnd_user_pkg.addresp(username => v_user_name

,resp_app => ‘&APPLICATION_SHORT_NAME’

,resp_key => ‘&RESPONSIBILITY_KEY’

,security_group => ‘STANDARD’

,description => NULL

,start_date => SYSDATE

,end_date => null);

commit;

END;

SHOW ERR;

Caso você tenha dificuldades em encontra os parâmetros para a nova responsabilidade, o[…]

JPS-00027: There was an internal error: oracle.net.ns.NetException: Unknown host specified

25 de janeiro de 2018 vanberto zuim Oracle BPM, Oracle SOA Suite, OSB, Weblogic

Encontrei esse erro na hora de subir um OSB, o problema ocorre devido a maquina não esta com o arquivo resolv.conf configurado corretamente . Alguns erros semelhantes:

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160526-8f41838): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLRecoverableException: IO Error: Unknown host specified
Error Code: 17002

oracle.security.jps.JpsException: JPS-00027: There was an internal error: oracle.net.ns.NetException: Unknown host specified

Caused By: oracle.net.ns.NetException: Unknown host specified

Caused by: java.sql.SQLRecoverableException: IO Error: Unknown host specified
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:800)

Caused by: oracle.net.ns.NetException: Unknown host specified
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:208)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:132)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:539)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:620)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:239)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1606)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:539)
... 100 more

Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.3.v20160526-8f41838): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLRecoverableException: IO Error: Unknown host specified

Error Code: 17002

oracle.security.jps.JpsException: JPS-00027: There was an internal error: oracle.net.ns.NetException: Unknown host specified

Caused By: oracle.net.ns.NetException: Unknown host specified

Caused by: java.sql.SQLRecoverableException: IO Error: Unknown host specified

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:800)

Caused by: oracle.net.ns.NetException: Unknown host specified

at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:208)

at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:132)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:539)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:620)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:239)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1606)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:539)

... 100 more

Solução corrija o arquivo resolv.conf ou adicione as maquinas no arquivo host

ORA-38760: This database instance failed to turn on flashback database

29 de dezembro de 2017 vanberto zuim Database

Solução Rapida.. Drop o ponto do FlashBack

SQL> drop restore point VERSION_2_109_0_0;

1	SQL> drop restore point VERSION_2_109_0_0;

Restore point dropped.

SQL> alter database open;

1	SQL> alter database open;

Database altered.

Could not initialize class run.awt.X11GraphicsEnviroment

30 de novembro de 2017 vanberto zuim Apps, EBS, Oracle BPM, Oracle SOA Suite, OSB, Weblogic

O problema “not initialize class run.awt.X11GraphicsEnviroment” ocorre devido a falta de um parâmetros nos managers que permite a utilização de Gráficos, a correção e bem simples , Abra os managers serves e adicione nas variáveis de inicialização os seguinte parâmetro:

-Djava.awt.headless=true

1	-Djava.awt.headless=true

Apos reinicie os managers.