Advertisement
ExaGridDba

12c expdp character string buffer too small

Sep 29th, 2013
805
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.75 KB | None | 0 0
  1. [oracle@waipio1 WAILUA dpump]$ cat expdp.brian.texpdp.par
  2. directory=dpump
  3. logfile=expdp.brian.texpdp.log
  4. dumpfile=expdp.brian.texpdp.%U.dat
  5. logtime=all
  6. compression=all
  7. reuse_dumpfiles=yes
  8. tables=
  9. brian.texpdp
  10. [oracle@waipio1 WAILUA dpump]$ export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI'
  11. [oracle@waipio1 WAILUA dpump]$ expdp "'/ as sysdba'" parfile=expdp.brian.texpdp.par
  12.  
  13. Export: Release 12.1.0.1.0 - Production on Sun Sep 29 15:32:45 2013
  14.  
  15. Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
  16.  
  17. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  18. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  19. and Real Application Testing options
  20.  
  21. UDE-31623: operation generated ORACLE error 31623
  22. ORA-31623: a job is not attached to this session via the specified handle
  23. ORA-06512: at "SYS.DBMS_DATAPUMP", line 3874
  24. ORA-06512: at "SYS.DBMS_DATAPUMP", line 5161
  25. ORA-06512: at line 1
  26.  
  27.  
  28. [oracle@waipio1 WAILUA trace]$ cat WAILUA_dm00_16678.trc
  29. Trace file /app/oracle/diag/rdbms/wailua/WAILUA/trace/WAILUA_dm00_16678.trc
  30. Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  31. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  32. and Real Application Testing options
  33. ORACLE_HOME = /app/oracle/product/12.1.0/db_1
  34. System name: Linux
  35. Node name: waipio1
  36. Release: 3.8.13-13.el6uek.x86_64
  37. Version: #1 SMP Wed Aug 21 14:28:36 PDT 2013
  38. Machine: x86_64
  39. Instance name: WAILUA
  40. Redo thread mounted by this instance: 1
  41. Oracle process number: 39
  42. Unix process pid: 16678, image: oracle@waipio1 (DM00)
  43.  
  44.  
  45. *** 2013-09-29 15:32:46.642
  46. *** SESSION ID:(418.77) 2013-09-29 15:32:46.642
  47. *** CLIENT ID:() 2013-09-29 15:32:46.642
  48. *** SERVICE NAME:(SYS$USERS) 2013-09-29 15:32:46.642
  49. *** MODULE NAME:(Data Pump Master) 2013-09-29 15:32:46.642
  50. *** ACTION NAME:(SYS_EXPORT_TABLE_06) 2013-09-29 15:32:46.642
  51.  
  52. KUPC: Setting remote flag for this process to FALSE
  53. KUPP: Initialization complete for master process DM00
  54.  
  55. *** 2013-09-29 15:32:47.774
  56. ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0
  57. ksvp2penabled: ep = 0x7f9fa0b80e30, rpr = 0x1eee90910
  58. KUPP: Error 6502 detected in master process DM00
  59. OPIRIP: Uncaught error 447. Error stack:
  60. ORA-00447: fatal error in background process
  61. ORA-31666: Master process DM00 had an unhandled exception.
  62. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  63. ORA-06512: at "SYS.KUPM$MCP", line 16913
  64. ORA-06512: at "SYS.KUPM$MCP", line 16804
  65. ORA-06512: at "SYS.KUPM$MCP", line 16599
  66. ORA-06512: at "SYS.KUPM$MCP", line 1104
  67. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  68. ORA-06512: at "SYS.KUPM$MCP", line 16913
  69. ORA-06512: at "SYS.KUPM$MCP", line 16804
  70. ORA-06512: at "SYS.KUPM$MCP", line 16599
  71. ORA-06512: at "SYS.KUPM$MCP", line 1622
  72. ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  73. ORA-06512: at line 2
  74.  
  75. [oracle@waipio1 WAILUA dpump]$ export NLS_DATE_FORMAT='YYYYMMDD HH24:MI'
  76. [oracle@waipio1 WAILUA dpump]$ expdp "'/ as sysdba'" parfile=expdp.brian.texpdp.par
  77.  
  78. Export: Release 12.1.0.1.0 - Production on Sun Sep 29 15:33:10 2013
  79.  
  80. Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
  81.  
  82. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
  83. With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
  84. and Real Application Testing options
  85. 20130929 15:33 15:33:13.526: Starting "SYS"."SYS_EXPORT_TABLE_07": "/******** AS SYSDBA" parfile=expdp.brian.texpdp.par
  86. 20130929 15:33 15:33:13.864: Estimate in progress using BLOCKS method...
  87. 20130929 15:33 15:33:14.575: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
  88. 20130929 15:33 15:33:14.595: Total estimation using BLOCKS method: 64 KB
  89. 20130929 15:33 15:33:16.697: Processing object type TABLE_EXPORT/TABLE/TABLE
  90. 20130929 15:33 15:33:17.015: Processing object type TABLE_EXPORT/TABLE/IDENTITY_COLUMN
  91. 20130929 15:33 15:33:17.357: Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
  92. 20130929 15:33 15:33:17.361: Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
  93. 20130929 15:33 15:33:31.716: . . exported "BRIAN"."TEXPDP" 4.703 KB 1 rows
  94. 20130929 15:33 15:33:31.969: Master table "SYS"."SYS_EXPORT_TABLE_07" successfully loaded/unloaded
  95. 20130929 15:33 15:33:31.972: ******************************************************************************
  96. 20130929 15:33 15:33:31.973: Dump file set for SYS.SYS_EXPORT_TABLE_07 is:
  97. 20130929 15:33 15:33:31.975: /home/oracle/sql/dpump/expdp.brian.texpdp.01.dat
  98. 20130929 15:33 15:33:31.977: Job "SYS"."SYS_EXPORT_TABLE_07" successfully completed at Sun Sep 29 15:33:31 2013 elapsed 0 00:00:20
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement