- zmsolution

Instalando o Oracle 19c

17 de janeiro de 2020 vanberto zuim Database

Nesse Artigo, Vamos instalar o Oracle 19c no virtual Box Vamos iniciar criando a maquina Virtual. Agora Vamos iniciar a instalação do SO Vamos instalar os pacotes:

yum -y update 
yum -y install oracle-database-preinstall-19c.x86_64 
yum -y install unzip wget screen gcc #
yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm # 
yum -y install oracleasm-support gcc gcc-c++ make
yum -y update # yum -y install rlwrap
yum install tigervnc-server
yum install -y bc 
yum install -y binutils
yum install -y compat-libcap1
yum install -y compat-libstdc++-33
yum install -y dtrace-modules
yum install -y dtrace-modules-headers
yum install -y dtrace-modules-provider-headers
yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC

wget http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.12-1.el7.x86_64.rpm
rpm -Uvh oracleasmlib-2.0.12-1.el7.x86_64.rpm

yum -y update

yum -y install oracle-database-preinstall-19c.x86_64

yum -y install unzip wget screen gcc #

yum -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm #

yum -y install oracleasm-support gcc gcc-c++ make

yum -y update # yum -y install rlwrap

yum install tigervnc-server

yum install -y bc

yum install -y binutils

yum install -y compat-libcap1

yum install -y compat-libstdc++-33

yum install -y dtrace-modules

yum install -y dtrace-modules-headers

yum install -y dtrace-modules-provider-headers

yum install -y dtrace-utils

yum install -y elfutils-libelf

yum install -y elfutils-libelf-devel

yum install -y fontconfig-devel

yum install -y glibc

yum install -y glibc-devel

yum install -y ksh

yum install -y libaio

yum install -y libaio-devel

yum install -y libdtrace-ctf-devel

yum install -y libXrender

yum install -y libXrender-devel

yum install -y libX11

yum install -y libXau

yum install -y libXi

yum install -y libXtst

yum install -y libgcc

yum install -y librdmacm-devel

yum install -y libstdc++

yum install -y libstdc++-devel

yum install -y libxcb

yum install -y make

yum install -y net-tools # Clusterware

yum install -y nfs-utils # ACFS

yum install -y python # ACFS

yum install -y python-configshell # ACFS

yum install -y python-rtslib # ACFS

yum install -y python-six # ACFS

yum install -y targetcli # ACFS

yum install -y smartmontools

yum install -y sysstat

yum install -y unixODBC

wget http://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.12-1.el7.x86_64.rpm

rpm -Uvh oracleasmlib-2.0.12-1.el7.x86_64.rpm

Configure o arquivo /etc/hosts:

127.0.0.1 localhost localhost.localdomain

192.168.56.79  zmol7.localdomain zmol7

127.0.0.1 localhost localhost.localdomain

192.168.56.79 zmol7.localdomain zmol7

Configure o Usuario Oracle

groupadd asmadmin 

groupadd asmdba

groupadd asmoper

usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle

groupadd asmadmin

groupadd asmdba

groupadd asmoper

usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle

Criei os diretorios

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/product/19.3.0.0/grid

chown -R  oracle:oinstall /u01/app/

chmod -R 775 /u01/

mkdir -p /u01/app/oracle/product/19.3.0.0/db_1

chown oracle:oinstall /u01/app/oracle/product/19.3.0.0/db_1

chmod -R 775 /u01/

mkdir -p /u01/app/oracle

mkdir -p /u01/app/oracle/product/19.3.0.0/grid

chown -R oracle:oinstall /u01/app/

chmod -R 775 /u01/

mkdir -p /u01/app/oracle/product/19.3.0.0/db_1

chown oracle:oinstall /u01/app/oracle/product/19.3.0.0/db_1

chmod -R 775 /u01/

desabilite o firewall, o avahi e o chronyd. #

systemctl disable firewalld

systemctl disable avahi-daemon

systemctl enable chronyd

systemctl disable firewalld

systemctl disable avahi-daemon

systemctl enable chronyd

altere o SELinux para o modo permissive.

vi /etc/selinux/config ...

SELINUX=permissive

vi /etc/selinux/config ...

SELINUX=permissive

adicione um novo disco Acesse o terminal e execute os comando abaixo:

fdisk -l

Disk /dev/sdb: 24.8 GB, 24843845632 bytes, 48523136 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes

Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p): p
Partition number (1-4, default 1): 1
First sector (2048-48523135, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-48523135, default 48523135):
Using default value 48523135
Partition 1 of type Linux and of size 23.1 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@zmol7 ~]#

fdisk -l

Disk /dev/sdb: 24.8 GB, 24843845632 bytes, 48523136 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Command (m for help): n

Partition type:

p primary (0 primary, 0 extended, 4 free)

e extended

Select (default p): p

Partition number (1-4, default 1): 1

First sector (2048-48523135, default 2048):

Using default value 2048

Last sector, +sectors or +size{K,M,G} (2048-48523135, default 48523135):

Using default value 48523135

Partition 1 of type Linux and of size 23.1 GiB is set

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

[root@zmol7 ~]#

Configurando 0[…]

CRS-2552: There are no available instances of resource ‘ora.asm’ to start

3 de janeiro de 2020 vanberto zuim Database

$ srvctl start asm -n rachost4
PRCR-1013 : Failed to start resource ora.asm
PRCR-1064 : Failed to start resource ora.asm on node rachost4
CRS-2552: There are no available instances of resource 'ora.asm' to start

$ srvctl start asm -n rachost4

PRCR-1013 : Failed to start resource ora.asm

PRCR-1064 : Failed to start resource ora.asm on node rachost4

CRS-2552: There are no available instances of resource 'ora.asm' to start

Quando trabalhamos com Oracle na versão 12.2 Com o Oracle Flex ASM o defaul é que Independentemente do número de nós no cluster, apenas três instâncias do ASM serão criadas. Para alterar esse valor modifiquei o numero de instancias com os comandos abaixo:

srvctl modify asm -count 5

ou

srvctl modify asm -count ALL

srvctl modify asm -count 5

srvctl modify asm -count ALL

sun.security.validator.ValidatorException: PKIX path building failed:

29 de novembro de 2019 vanberto zuim Apps, EBS, Oracle BPM, Oracle SOA Suite, OSB, Weblogic

No momento que configuramos uma keystore no SOA 12C alguns problemas podem ocorrer.

Caused By: oracle.j2ee.ws.wsdl.LocalizedWSDLException: WSDLException: 
faultCode=PARSER_ERROR: Failed to read wsdl file 
at: "https://SOA_SERVER:8002/soa-infra/services/default/DocumentRouting/documentrouting_client_ep?WSDL", caused by: 
javax.net.ssl.SSLHandshakeException. : javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: 
PKIX path building failed: 
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Caused By: oracle.j2ee.ws.wsdl.LocalizedWSDLException: WSDLException:

faultCode=PARSER_ERROR: Failed to read wsdl file

at: "https://SOA_SERVER:8002/soa-infra/services/default/DocumentRouting/documentrouting_client_ep?WSDL", caused by:

javax.net.ssl.SSLHandshakeException. : javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException:

PKIX path building failed:

sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

<bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException: 
javax.xml.ws.WebServiceException: Could not determine wsdl ports. WSDLException: faultCode=PARSER_ERROR: Failed to read wsdl file at: 
"https://sandbox.zmsolution.com.br/ws2/ZMsolutionBean?wsdl", caused by: javax.net.ssl.SSLHandshakeException.: javax.net.ssl.SSLHandshakeException: 
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: 
unable to find valid certification path to requested target</summary></part><part name="code"><code>null</code></part><part name="detail"><detail>unable to 
find valid certification path to requested target</detail></part></remoteFault></bpelFault>

<bpelFault><faultType>0</faultType><remoteFault xmlns="http://schemas.oracle.com/bpel/extension"><part name="summary"><summary>oracle.fabric.common.FabricInvocationException:

javax.xml.ws.WebServiceException: Could not determine wsdl ports. WSDLException: faultCode=PARSER_ERROR: Failed to read wsdl file at:

"https://sandbox.zmsolution.com.br/ws2/ZMsolutionBean?wsdl", caused by: javax.net.ssl.SSLHandshakeException.: javax.net.ssl.SSLHandshakeException:

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException:

unable to find valid certification path to requested target</summary></part><part name="code"><code>null</code></part><part name="detail"><detail>unable to

find valid certification path to requested target</detail></part></remoteFault></bpelFault>

O erro ocorre devido ao arquivo setDomainEnv ter uma configuração para a keystore demo(DemoTrust.jks) para solucionar, altere o arquivo setDomainEnv.sh e retire a linha abaixo: -Djavax.net.ssl.trustStore=${WL_HOME}/server/lib/DemoTrust.jks e reiniciei todo o SOA 12c . Com isso o problema estará solucionado.

OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.

1 de novembro de 2019 vanberto zuim Database, Exadata

O erro OPATCHAUTO-72141 ocorre devido a um bug:

As part of bug 26367944, development added a validation to enforce user to pass -nonrolling along with opatchauto in single node GI.

So mentioned error message is coming is due to this fix, hence –nonrolling has to be passed to avoid this error. This is already present in 12.2.0.1.10.

As part of bug 26367944, development added a validation to enforce user to pass -nonrolling along with opatchauto in single node GI.

So mentioned error message is coming is due to this fix, hence –nonrolling has to be passed to avoid this error. This is already present in 12.2.0.1.10.

Vamos para a solução do problema:

[root@zmmaq1~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/install/psu/30116789/

OPatchauto session is initiated at Fri Nov 1 11:53:06 2019

System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-11-01_11-53-08AM.log.

Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2019-11-01_11-53-11AM.log
The id for this session is KJMJ
OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode.
OPATCHAUTO-72141: Grid is installed only on a single node.
OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
OPatchAuto failed.

OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode.
OPATCHAUTO-72141: Grid is installed only on a single node.
OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
OPatchAuto failed.

[root@zmmaq1~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/install/psu/30116789/

OPatchauto session is initiated at Fri Nov 1 11:53:06 2019

System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-11-01_11-53-08AM.log.

Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2019-11-01_11-53-11AM.log

The id for this session is KJMJ

OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode.

OPATCHAUTO-72141: Grid is installed only on a single node.

OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.

OPatchAuto failed.

OPATCHAUTO-72141: Grid patching cannot be performed in rolling mode.

OPATCHAUTO-72141: Grid is installed only on a single node.

OPATCHAUTO-72141: Execute opatchauto in non-rolling mode.

OPatchAuto failed.

Adicione nonrolling no comando do patch

[root@zmmaq1~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/install/psu/30116789/ -nonrolling

OPatchauto session is initiated at Fri Nov 1 11:55:44 2019

System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-11-01_11-55-46AM.log.

Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2019-11-01_11-55-49AM.log
The id for this session is M6BD

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0.0/grid
Patch applicability verified successfully on home /u01/app/19.3.0.0/grid


Bringing down CRS service on home /u01/app/19.3.0.0/grid
CRS service brought down successfully on home /u01/app/19.3.0.0/grid


Start applying binary patch on home /u01/app/19.3.0.0/grid
Binary patch applied successfully on home /u01/app/19.3.0.0/grid


Starting CRS service on home /u01/app/19.3.0.0/grid
CRS service started successfully on home /u01/app/19.3.0.0/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:zmmaq1
CRS Home:/u01/app/19.3.0.0/grid
Version:19.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /u01/install/psu/30116789/29401763
Reason: This patch is already been applied, so not going to apply again.


==Following patches were SUCCESSFULLY applied:

Patch: /u01/install/psu/30116789/30122149
Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

Patch: /u01/install/psu/30116789/30122167
Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

Patch: /u01/install/psu/30116789/30125133
Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

OPatchauto session completed at Fri Nov 1 12:08:15 2019
Time taken to complete the session 12 minutes, 31 seconds
[root@zmmaq1 ~]#

[root@zmmaq1~]# $ORACLE_HOME/OPatch/opatchauto apply /u01/install/psu/30116789/ -nonrolling

OPatchauto session is initiated at Fri Nov 1 11:55:44 2019

System initialization log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-11-01_11-55-46AM.log.

Session log file is /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/opatchauto2019-11-01_11-55-49AM.log

The id for this session is M6BD

Executing OPatch prereq operations to verify patch applicability on home /u01/app/19.3.0.0/grid

Patch applicability verified successfully on home /u01/app/19.3.0.0/grid

Bringing down CRS service on home /u01/app/19.3.0.0/grid

CRS service brought down successfully on home /u01/app/19.3.0.0/grid

Start applying binary patch on home /u01/app/19.3.0.0/grid

Binary patch applied successfully on home /u01/app/19.3.0.0/grid

Starting CRS service on home /u01/app/19.3.0.0/grid

CRS service started successfully on home /u01/app/19.3.0.0/grid

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:zmmaq1

CRS Home:/u01/app/19.3.0.0/grid

Version:19.0.0.0.0

Summary:

==Following patches were SKIPPED:

Patch: /u01/install/psu/30116789/29401763

Reason: This patch is already been applied, so not going to apply again.

==Following patches were SUCCESSFULLY applied:

Patch: /u01/install/psu/30116789/30122149

Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

Patch: /u01/install/psu/30116789/30122167

Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

Patch: /u01/install/psu/30116789/30125133

Log: /u01/app/19.3.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-11-01_11-58-42AM_1.log

OPatchauto session completed at Fri Nov 1 12:08:15 2019

Time taken to complete the session 12 minutes, 31 seconds

[root@zmmaq1 ~]#

Erro no Clone EBS12.2.7

22 de outubro de 2019 vanberto zuim EBS

O erro ocorre na hora da execução do clone do patch System File Edition.

/u01/app/oracle/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/app/oracle/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/java:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/app/oracle/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/app/oracle/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/app/oracle/fs1/inst/apps/ebshmg_ebshmgapp/appl/admin/ebshmg_ebshmgapp.xml -stage /u01/app/oracle/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/app/oracle/fs1/inst/apps/ebshmg_ebshmgapp/admin/log/clone/ApplyAppsTier_10212035.log
/ 100% completed
ERROR while running Apply...
Mon Oct 21 21:02:32 2019

Enabling EBS_LOGON Trigger...

ERROR: Failed to execute /u01/app/oracle/fs1/EBSapps/comn/clone/bin/adclone.pl

/u01/app/oracle/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/app/oracle/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/java:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/app/oracle/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/app/oracle/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/app/oracle/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/app/oracle/fs1/inst/apps/ebshmg_ebshmgapp/appl/admin/ebshmg_ebshmgapp.xml -stage /u01/app/oracle/fs1/EBSapps/comn/clone -showProgress -nopromptmsg

Log file located at /u01/app/oracle/fs1/inst/apps/ebshmg_ebshmgapp/admin/log/clone/ApplyAppsTier_10212035.log

/ 100% completed

ERROR while running Apply...

Mon Oct 21 21:02:32 2019

Enabling EBS_LOGON Trigger...

ERROR: Failed to execute /u01/app/oracle/fs1/EBSapps/comn/clone/bin/adclone.pl

Erro:

SEVERE : oct 21, 2019 6:26:12 AM - ERROR - CLONE-20372 Server port validation failed.
SEVERE : oct 21, 2019 6:26:12 AM - CAUSE - CLONE-20372 Ports of following servers - oacore_server2(7226),forms_server2(7
426),oafm_server2(7626),forms-c4ws_server2(7826) - are not available.
SEVERE : oct 21, 2019 6:26:12 AM - ACTION - CLONE-20372 Provide valid free ports.
oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.

SEVERE : oct 21, 2019 6:26:12 AM - ERROR - CLONE-20372 Server port validation failed.

SEVERE : oct 21, 2019 6:26:12 AM - CAUSE - CLONE-20372 Ports of following servers - oacore_server2(7226),forms_server2(7

426),oafm_server2(7626),forms-c4ws_server2(7826) - are not available.

SEVERE : oct 21, 2019 6:26:12 AM - ACTION - CLONE-20372 Provide valid free ports.

oracle.as.t2p.exceptions.FMWT2PPasteConfigException: PasteConfig failed. Make sure that the move plan and the values specified in moveplan are correct.

Communication error with the OPMN server local port.
Check the OPMN log files
SEVERE : Mar 31, 2015 3:37:31 PM - ERROR - CLONE-20218   Cloning is not 
successful.
SEVERE : Mar 31, 2015 3:37:31 PM - CAUSE - CLONE-20218   An internal 
operation failed.
SEVERE : Mar 31, 2015 3:37:31 PM - ACTION - CLONE-20218   Provide the clone 
log and error file for investigation.
oracle.as.clone.cloner.exception.ApplyCloneException:  Instance "Create &amp; 
Start" step  failed.

Communication error with the OPMN server local port.

Check the OPMN log files

SEVERE : Mar 31, 2015 3:37:31 PM - ERROR - CLONE-20218 Cloning is not

successful.

SEVERE : Mar 31, 2015 3:37:31 PM - CAUSE - CLONE-20218 An internal

operation failed.

SEVERE : Mar 31, 2015 3:37:31 PM - ACTION - CLONE-20218 Provide the clone

log and error file for investigation.

oracle.as.clone.cloner.exception.ApplyCloneException: Instance "Create &

Start" step failed.

Para a solução do problema, Antes de iniciar o clone do patch File system, execute o comando abaixo:

 export T2P_JAVA_OPTIONS="-Dt2p.temporary.port.range=5001-5050"
 ./adcfgclone.pl appsTier

1 2	export T2P_JAVA_OPTIONS="-Dt2p.temporary.port.range=5001-5050" ./adcfgclone.pl appsTier

Treinamento Oracle 19c Administrator

7 de outubro de 2019 vanberto zuim Database

Turma confirmada para o dia 18/11/2019!

Erro netca

2 de outubro de 2019 vanberto zuim Database

O erro: Use another port number . The information provided for this listener is currently in use by other software on this computer. You can proceed with the configuration as it is, but it will not be possible to start this listener until the conflict is resolved. Pode ocorrer se o arquivo /etc/hosts estiver configurado errado. Analise a configuração correta e execute novamente o netca.

Habilitando o vnc no Exadata

2 de outubro de 2019 vanberto zuim Exadata

Para habilitar o VNC no exadata instale os pacotes abaixo:

yum install xorg-x11-xauth

yum install xorg-x11-utils

yum install xterm

yum install twm

yum install tigervnc-server

yum install xorg-x11-xauth

yum install xorg-x11-utils

yum install xterm

yum install twm

yum install tigervnc-server

Apos instalar os pacotes entre no usuário oracle e execute os comandos abaixo:

su – oracle

vncpasswd

vncserver

su – oracle

vncpasswd

vncserver

PO Output For Communication Performance is very slow

1 de outubro de 2019 vanberto zuim EBS

Alguns dias tivemos um problema de lentidão no concurrent PO Output For Communication , apos um grande período de analise ,verificamos que a lentidão esta ocorrendo na geração do PDF do concurrent . pesquisei bastante sobre o que poderia estar causando essa lentidão e acabei encontrando o seguinte note no metalink: PO Output For Communication Performance Issues But SQL Trace Show No Performance Problems (Doc ID 1575175.1) o que explica a oracle sobre o problema: This is[…]

How to Replace a Hard Drive in an Exadata Storage Server (Predictive Failure) X7

2 de setembro de 2019 vanberto zuim Exadata

Segue um How to para alterar um disco no exadata (Predictive Failure)) 1- Encontre o disco que deve ser alterado. Normalmente a oracle envia no SR um texto assim: Slot Number: 6 Drive’s postion: DiskGroup: 6, Span: 0, Arm: 0 Enclosure position: 0 Device Id: 9 WWN: 5000CCA267226EC7 Sequence Number: 2 Media Error Count: 83 <<<<<<<<<<<<<<<<< Other Error Count: 187 <<<<<<<<<<<<<<<<<<<<<<<< Predictive Failure Count: 0 Last Predictive Failure Event Seq Number: 0 PD Type: SAS Para[…]