Home » Other » General » ORA-00922 on install
ORA-00922 on install [message #103918] Tue, 18 May 2004 13:13 Go to next message
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 #103937 is a reply to message #103918] Wed, 26 May 2004 12:47 Go to previous messageGo to next message
RB
Messages: 11
Registered: April 2002
Junior Member
Well, you're not alone. Got the same error installing 9i.
Re: ORA-00922 on install [message #103942 is a reply to message #103918] Fri, 28 May 2004 12:00 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #104076 is a reply to message #103943] Thu, 22 July 2004 03:17 Go to previous messageGo to next message
dritan
Messages: 1
Registered: July 2004
Junior Member
i had the same problem, and i solved it after i red this. i was also using "+" in pasword. thx.
Re: ORA-00922 on install [message #104361 is a reply to message #104076] Tue, 28 September 2004 03:19 Go to previous message
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.
Previous Topic: RDBMS APPLICATIONS
Next Topic: printer problem
Goto Forum:
  


Current Time: Thu Mar 28 06:23:19 CDT 2024