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