Home > Oracle > ORA-00922: missing or invalid option

ORA-00922: missing or invalid option

if you get the above error when you create a database from the gui, make sre you have used a more user friendly password for sys and system

Check out the log file /u01/app/oracle/cfgtoollogs/dbca/<DBNAME>trace.log


[Thread-36] [ 2011-09-08 16:57:10.530 BST ] [SQLEngine.setSpool:1945]  old Spool  = null
[Thread-36] [ 2011-09-08 16:57:10.530 BST ] [SQLEngine.setSpool:1946]  Setting Spool  = /u01/app/oracle/cfgtoollogs/dbca/ORAREPOPR/postScripts.log
[Thread-36] [ 2011-09-08 16:57:10.530 BST ] [SQLEngine.setSpool:1947]  Is spool appendable? --> true
[Thread-36] [ 2011-09-08 16:57:11.508 BST ] [ClonePostCreateScripts.executeImpl:284]  OraNLSLanguage: ENGLISH
[Thread-42] [ 2011-09-08 16:57:11.521 BST ] [BasicStep.handleNonIgnorableError:430]  <a href="mailto:oracle.sysman.assistants.util.UIMessageHandler@28a7bd7a:messageHandler">oracle.sysman.assistants.util.UIMessageHandler@28a7bd7a:messageHandler</a>
[Thread-42] [ 2011-09-08 16:57:11.521 BST ] [BasicStep.handleNonIgnorableError:431]  ORA-00922: missing or invalid option

 

 

 

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: