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 moreAutor: vanberto zuim
Instalando o Oracle 19c
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 moreCRS-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[…]
Read moresun.security.validator.ValidatorException: PKIX path building failed:
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 moreOPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
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 moreErro no Clone EBS12.2.7
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 moreTreinamento Oracle 19c Administrator
Turma confirmada para o dia 18/11/2019!
Read moreErro netca
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 moreHabilitando o vnc no 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 Apos instalar os pacotes entre no usuário oracle e execute os comandos abaixo: su – oracle vncpasswd vncserver
Read morePO Output For Communication Performance is very slow
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