Master Note - Troubleshooting DBCA Issues (文件 ID 1269459.1)
Master Note - Troubleshooting DBCA Issues (文件 ID 1269459.1)
Applies to:Oracle Database Configuration Assistant - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Information in this document applies to any platform. Purpose***Checked for relevance on 12-Jun-2012***
This Master Note is intended to provide a jumping off point for DBCA related issues in the Oracle RDBMS, including: Includes a list of relevant notes to progress issues, and helpful tips for filing SRs if needed. Troubleshooting StepsThis Master Note is provided to assist you to understand and troubleshoot DBCA related issues. Step by step approach
Issue Clarification ==> Issue Verification ==> Cause Determination ==> Potential Solutions
It is important to describe the problem as best as possible.
The log location may vary but they are typicallyfound in a directory below this one: DBCA is a GUI tool and generally the problems are reported while creating database using DBCA or managing database using DBCA.
Examples of problem descriptions:
When you have a starting problem description it is time to collect facts in a structured way.
Issue Clarification --> Issue Verification --> Cause Determination --> Potential Solutions
What is the problem / what is not a problem? What are the symptoms? What are the different errors generated? What 5-digit version of Oracle software reproduces the problem? What 5-digit version of Oracle software works? (if any) (For Windows platform confirm patch number bundle used) When is the problem seen / when is the problem not seen? Is the problem constant? Is the problem reported intermittently? Is there any pattern to the failure? What resolves the problem? Has this ever worked or is this a fresh installation / setup? Where is the problem / Where is the problem not?
Issue Clarification --> Issue Verification --> Cause Determination --> Potential Solutions
* What changes happened around time the first failure / problem was reported? While searching for potential solutions on My Oracle Support, for more refined search results use error specific keywords. For e.g searching for problem - DBCA failing with "java.lang.UnsatisfiedLinkError: no OsUtils in shared library path" error, use search keywords as 'DBCA UnsatisfiedLinkError OsUtils'. Avoid using generic error codes for the search.
Issue Clarification --> Issue Verification --> Cause Determination --> Potential Solutions
A brief description of the corrective actions that will remove the cause of the problem: in some cases there is only one solution linked to the cause. But in many cases, there are more. * Install a patch to remove the bug from the system, avoid the problem by using alternatives / workaround. For example in critical situation if you are not able to create database using DBCA try using manual method of creating database. --- SR Creation --- If you are blocked in the resolution process of your problem it is best to log a Service Request (SR). When logging a SR please provide all the information you collected in the previous steps. The support engineer serving you will follow a very similar approach to come to the resolution of your problem. The more detailed you can describe the problem by using your issue clarification and verification, the better we will be able to solve you.--- Diagnostic Tools ---note.428118.1Tracing DBCANote.428118.1 How to enable Java code tracing for DBUA, DBCA and NETCA? Note 188134.1 Tracing the Database Configuration Assistant (DBCA) Note 859016.1 How does DBCA (Database Configuration Assistant) connect to the database? Basic Checks Note 111796.1 How to Resolve Database Creation Assistant (DBCA) Errors Note 333467.1 Database Configuration Assistant (DBCA) Errors with TNS-04404 Note 404075.1 Database Configuration Assistant (DBCA) reports ORA-12547 creating a new database on Linux Note 388488.1 Database Configuration Assistant (DBCA) is Failing With ORA-01034. Note 345038.1 Database Configuration Assistant (DBCA) Reports The Error `java.lang.UnsatisfiedLinkError: no OsUtils in shared library path` Note 786372.1 DBCA fails to Launch, Errors With UnsatisfiedLinkError Exception Loading Native Library: NLDAPJ11 Note 460695.1 DBCA Fails with "Exception In Thread "Main" Java.Lang.Noclassdeffounderror: oracle/sysman/oip/oipc/oipch/OipchKernelProperty" Note 159324.1 ORA-1092 Instance Terminated When Creating A Database Via DBCA Note 289879.1 Create Database Fails With Ora-00058 Blocksize Must Be 8k Note 747243.1 ORA-12560 - Database Creation Assistant (DBCA) Fails With TNS Error Note 444811.1 ORA-09925 When Using DBCA Template Note 847784.1 How to change DB_BLOCK_SIZE while creating database using DBCA?
Note 1609516.1 DBCA does not Recognize Database if it is Created With RMAN
Note 1590570.1 CONTAINER DATABASE creation using DBCA no option to uncheck the database components OpenVMS specific issues Note 247901.1 How to Generate Database Creation Scripts Using DBCA on OpenVMS Note 226184.1 DBCA tips for Oracle RDBMS 9.2.X on OpenVMS Note 391598.1 DBCA tips for Oracle RDBMS 10.2.X on OpenVMS DBCA with ASM Note 468941.1 Could Not Access Asm In Dbca To Create New Database Note 403644.1 How to get the DBCA to see an ASM instance without the standard +ASM instance name? Note 744237.1 DBCA in Silent mode with ASM
Note 1177483.1 - DBCA Does Not Display ASM Disk Groups In 11.2
DBCA Templates Note 148676.1 DBCA Templates Note 456631.1 Altering an Existing DBCA Template using the Same Template Name Note 387598.1 DBCA Cannot Find Template Files ORA-19870 Note 404292.1 Unable To Supply Variable To Dbca Template In Silent Mode Generic Note 454631.1 11g DBCA New features / Enhancements |
|
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1407041/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Master Note for Tablespace IssuesAST
- Master Note: Troubleshooting Oracle Tablespace Management (文件 ID 1522807.1)ASTOracle
- Master Note: Troubleshooting Redo Logs and Archiving (文件 ID 1507157.1)AST
- Troubleshooting Database Hang Issues (Doc ID 1378583.1)Database
- Master Note for Handling Oracle Database Corruption Issues [ID 1088018.1]ASTOracleDatabase
- Master Note: Troubleshooting Oracle Background Processes_1509616.1ASTOracle
- Master Note: Overview of Database ControlFiles (文件 ID 1493674.1)ASTViewDatabase
- Troubleshooting Database Control Startup IssuesDatabase
- TROUBLESHOOTING - ASM disk not found/visible/discovered issuesASM
- 【MOS】Top 5 Grid Infrastructure Startup Issues (文件 ID 1368382.1)ASTStruct
- Checkpoint Tuning and Troubleshooting Guide (文件 ID 147468.1)GUIIDE
- * Master Note: Database Performance Overview (Doc ID 402983.1)ASTDatabaseORMView
- Master Note For ASM For OS Administrators [ID 1345562.1]ASTASM
- Master Note - Oracle GoldenGate (Doc ID 1298817.1)ASTOracleGo
- How to Collect Diagnostics for Database Hanging Issues (文件 ID 452358.1)Database
- Master Note for Oracle Disk Manager (Doc ID 1226653.1)ASTOracle
- Master Note of Linux OS Requirements for Database Server [ID 851598.1]ASTLinuxUIREMDatabaseServer
- Master Note: Locks, Enqueues and Deadlocks [ID 1392319.1]ASTENQ
- 【MOS】Troubleshooting 'enq: TX - index contention' Waits (文件 ID 873243.1)ENQIndexAI
- High Version Count Issues(SQL高Version Count) (文件 ID 296377.1)SQL
- Master Note of Linux OS Requirements for Database Server (Doc ID 851598.1)ASTLinuxUIREMDatabaseServer
- Master Note for Streams Recommended Configuration [ID 418755.1]AST
- Master Note Parallel Execution Wait Events [ID 1097154.1]ASTParallelAI
- Troubleshooting ServeRAIDServerAI
- Master Note for RAC Oracle Clusterware and Oracle Grid Infrastructure 1096952.ASTOracleStruct
- Master Note: Overview of Oracle Tablespace Management (Doc ID 1493350.1)ASTViewOracle
- Master Note for Automatic Storage Management (ASM) [ID 1187723.1]ASTASM
- Master Note Oracle GoldenGate Management Pack - Director [ID 1307305.1]ASTOracleGo
- Master Note: Oracle Transaction Management (Local) Overview (Doc ID 1506115.1)ASTOracleView
- Master Note For PL/SQL UTL_FILE Package (Doc ID 1155024.1)ASTSQLPackage
- 【Oracle】Master Note for Parallel Execution Wait EventsOracleASTParallelAI
- Master-Worker工具使用文件AST
- WAITEVENT: "row cache lock" Reference Note (文件 ID 34609.1)AI
- TOP Note: Solutions for Typical GI /RAC Database runInstaller Issues_1056713.1Database
- How to Troubleshoot Grid Infrastructure Startup IssuesASTStruct
- Oracle 18c - 配置只讀 OracleHome / DBCA / Patching / Upgrade (文件 ID 2469646.1)Oracle
- Checkpoint Tuning and Troubleshooting GuideGUIIDE
- Troubleshooting Session Administration [ID 805586.1]Session