| ORA-00922 on install [message #103918] |
Tue, 18 May 2004 13:13  |
Strom Domer
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
Installing 9i v9.2.0.1.0 on WinNT 4 (sp 6a)
First time install. No upgrade. Selected "general database".
Database Configuration Assistant is asking me to change passwords for SYS and SYSTEM. After providing passwords and clicking OK,
ORA-00922: missing or invalid option
All references to this error I've seen on the web point to a mal-formed SQL statement. I ain't writing any SQL here. No cancel available. No help. Stuck here with force quit as my only option. Don't want to do that.
Help?
|
|
|
|
|
|
| Re: ORA-00922 on install [message #103942 is a reply to message #103918] |
Fri, 28 May 2004 12:00  |
Nittaya Th.
Messages: 1
Registered: May 2004
|
Junior Member |
|
|
I found that problem like you.
As I was installing Database Configuration Assistant, there was a Dos Window popup behind the installing.
Did you see it?
The Dos Window was trying(many times) to run "$ORACLE_HOMEbinsqlplus.exe" to create DB, but it couldn't do successfully.
I tried 3-4 times to OK till the Dos Window closed.
(I didn't know why).
I tried one more time to click OK again, after that the Dos Window re-popuped again. I didn't see "ORA-00922: missing or invalid option" and the installation of ORACLE was successful.
Try to do it again and I hope this will help.
|
|
|
|
| Re: ORA-00922 on install [message #103943 is a reply to message #103918] |
Fri, 28 May 2004 12:03 |
RB
Messages: 11
Registered: April 2002
|
Junior Member |
|
|
We have a winner -- the app asking for the password doesn't seem to be smart enough to tease out bad characters. I'm not sure if Oracle allows the characters in the passwords in other situations, but this part screwed up for me apparently because I was using passwords that contained the "+" character.
Simple passwords and *poof*, no problem. I guess I'll change 'em later... Hope that's your problem too. Too bad you were using passwords that would have actually been hard to guess. Looks like the Oracle set-up doesn't appreciate that much.
|
|
|
|
|
|
| Re: ORA-00922 on install [message #104361 is a reply to message #104076] |
Tue, 28 September 2004 03:19 |
Jonathan
Messages: 10
Registered: May 2002
|
Junior Member |
|
|
I've tried my name followed with a random number, and it passed.
It seems there're only few characters allowed in password string. you might try your name with followed a number and it might works.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
