Fala pessoal! Ocorreu o erro abaixo na minha tentativa de instalar o Kubernetes em tres maquinas no virtualbox failed to load Kubelet config file /var/lib/kubelet/config.yaml, error failed to read kubelet config file “/var/lib/kubelet/config.yaml”, error: open/var/lib/kubelet/config.yaml: no such file or directory O erro ocorreu devido a configuração de rede que não estava bacana…. para uma solução facil , criei duas placas de rede, uma como placa de rede modo Bridge e outra como Placa de rede[…]
Read moreÚltimos Artigos
ORA-01000: maximum open cursors exceeded
Na Hora da execução do comando nid que é utilizado para alterar o dbname do banco de dados, ocorreu o seguinte erro: ORA-01000: maximum open cursors exceeded
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[oracle@zmsol1 dbs]$ nid target=sys/zmsenha dbname=dbzm1 DBNEWID: Release 11.2.0.4.0 - Production on Fri Mar 6 11:03:43 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to database ZMDB(DBID=2727256655) Connected to server version 11.2.0 Control Files in database: +DATA/zmdb1/controlfile/control01.ctl +DATA/zmdb1/controlfile/control02.ctl Change database ID and database name ZMDB to dbzm1 ? (Y/[N]) => y Proceeding with operation Changing database ID from 2727256655 to 4198393936 |
|
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 |
Changing database name from ZMDB to zmdb1 Control File +DATA/zmdb1/controlfile/control01.ctl - modified Control File +DATA/zmdb1/controlfile/control02.ctl - modified Datafile +DATA/zmdb1/datafile/system.559.103428254 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab11_ind.549.103428225 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/sysaux.261.103425829 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/integra_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/opme_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/opme_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/users.657.103428547 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab41_1_ind_au - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/cadastro_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/cadastro_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/prestador_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab41_ind_au - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/clapmlote_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/clapmlote_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/notas_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/historico_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/historico_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/servicos_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/guias_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab42_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/manut_tab_ - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/carnets_tab - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab4_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab08_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/tiss_tab_ - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab7_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab8_in - dbid changed, wrote new name NID-00111: Oracle error reported from target database while executing begin dbms_backup_restore.nidprocessdf(:fno, :istemp, :skipped, :idchged, :nmchged); end; ORA-01000: maximum open cursors exceeded Change of database name and database ID failed. Must finish change or REVERT changes before attempting any database operation. DBNEWID - Completed with errors. |
O erro ocorre devido ao numero de cursores sem baixo, aumente o numero de cursores e refaça o processo.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> select name,open_mode from v$database; NAME OPEN_MODE --------- -------------------- FINDB MOUNTED SQL> show parameter open_cursor NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ open_cursors integer 300 SQL> alter system set open_cursors=1000; |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
[oracle@zmsol1 dbs]$ nid target=sys/zmsenha dbname=dbzm1 DBNEWID: Release 11.2.0.4.0 - Production on Fri Mar 6 11:03:43 2020 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Connected to database ZMDB(DBID=2727256655) Connected to server version 11.2.0 Control Files in database: +DATA/zmdb1/controlfile/control01.ctl +DATA/zmdb1/controlfile/control02.ctl Change database ID and database name ZMDB to dbzm1 ? (Y/[N]) => y Proceeding with operation Changing database ID from 2727256655 to 4198393936 |
|
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 |
Changing database name from ZMDB to zmdb1 Control File +DATA/zmdb1/controlfile/control01.ctl - modified Control File +DATA/zmdb1/controlfile/control02.ctl - modified Datafile +DATA/zmdb1/datafile/system.559.103428254 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab11_ind.549.103428225 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/sysaux.261.103425829 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/integra_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/opme_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/opme_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/users.657.103428547 - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab41_1_ind_au - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/cadastro_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/cadastro_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/prestador_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab41_ind_au - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/clapmlote_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/clapmlote_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/notas_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/historico_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/historico_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/servicos_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/guias_ta - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab42_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/manut_tab_ - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/carnets_tab - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab4_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab08_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/tiss_tab_ - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab7_in - dbid changed, wrote new name Datafile +DATA/zmdb1/datafile/zmtab8_in - dbid changed, wrote new name Database name changed to dbzm1 . Modify parameter file and generate a new password file before restarting. Database ID for database dbzm1 changed to 4198393936. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully. |
Criando um Restore Point
Um restore point já existe algum tempo no Oracle, mais muita gente ainda tem bastante duvida na sua utilização, algum tempo atras eu utilizava bastante esse recurso nas minhas bases de homologação, Antes de cada nova versão ser aplicada no sistema, existia o habito de criar um restore point, Isso nos ajudava a voltar a base rapidamente se ocorre-se algum problema na aplicação da versão ou nos testes, Hoje mudamos isso com a criação de[…]
Read moreInstalando o Oracle 11.2.0.4 no grid infrastructure 19c
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. 🙁
|
1 |
./runInstaller -ignorePrereq |
Doc ID 1962046.1 Triste mais é verdade..
Read moreInstalando 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:
|
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 |
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:
|
1 2 3 |
127.0.0.1 localhost localhost.localdomain 192.168.56.79 zmol7.localdomain zmol7 |
Configure o Usuario Oracle
|
1 2 3 4 5 6 7 |
groupadd asmadmin groupadd asmdba groupadd asmoper usermod -g oinstall -G dba,oper,asmadmin,asmdba,asmoper oracle |
Criei os diretorios
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
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. #
|
1 2 3 4 5 |
systemctl disable firewalld systemctl disable avahi-daemon systemctl enable chronyd |
altere o SELinux para o modo permissive.
|
1 2 3 |
vi /etc/selinux/config ... SELINUX=permissive |
adicione um novo disco Acesse o terminal e execute os comando abaixo:
|
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 |
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[…]
Read moreCRS-2552: There are no available instances of resource ‘ora.asm’ to start
|
1 2 3 4 |
$ 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:
|
1 2 3 4 5 |
srvctl modify asm -count 5 ou srvctl modify asm -count ALL |
Read more
sun.security.validator.ValidatorException: PKIX path building failed:
No momento que configuramos uma keystore no SOA 12C alguns problemas podem ocorrer.
|
1 2 3 4 5 6 |
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
|
1 2 3 4 5 6 |
<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.
Read moreOPATCHAUTO-72141: Execute opatchauto in non-rolling mode.
O erro OPATCHAUTO-72141 ocorre devido a um bug:
|
1 2 3 |
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
[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
|
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 |
[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 ~]# |
Read more
Erro no Clone EBS12.2.7
O erro ocorre na hora da execução do clone do patch System File Edition.
|
1 2 3 4 5 6 7 8 9 |
/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:
|
1 2 3 4 5 |
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. |
Ou
|
1 2 3 4 5 6 7 8 9 10 |
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:
|
1 2 |
export T2P_JAVA_OPTIONS="-Dt2p.temporary.port.range=5001-5050" ./adcfgclone.pl appsTier |
Read more
Treinamento Oracle 19c Administrator
Turma confirmada para o dia 18/11/2019!
Read more