Autor: vanberto zuim

Instalando o Oracle 11.2.0.4 no grid infrastructure 19c

Database

Quando vamos instalar o Oracle 11.2.0.4 no Grid infrastructure 19c , encontramos um bug na nora do runInstaller  do rdbms, o bug Bug 19947777 , esse bug faz que telas do Oracle não abram corretamente , A forma mais facil de passar por esse problema infelizmente e executar  o runInstaller  com a opção ignorePrereq.  🙁 ./runInstaller -ignorePrereq   Doc ID 1962046.1 Triste mais é verdade..

Read more

Instalando o Oracle 19c

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

Read more

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

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

Read more

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

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

Read more

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

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

Read more

Erro no Clone EBS12.2.7

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 Erro: SEVERE : oct 21, 2019 6:26:12 AM – ERROR – CLONE-20372 Server port validation failed. SEVERE : oct 21, 2019 6:26:12 AM -[…]

Read more

Erro netca

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.

Read more

PO Output For Communication Performance is very slow

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

Read more