rl_marton
asked on
Database Configuration Assistant not working
I cannot at all get the Database Config Ass to work [at all]. Click on it in the menu and nothing. Zilch. Doesn't even bring up the screen.
This prob may be related [or not related] to my recent installation of 9i DS on the same machine. It worked before then and I'd rather not do a complete reinstall if it's something simple. Anyway ideas?
This prob may be related [or not related] to my recent installation of 9i DS on the same machine. It worked before then and I'd rather not do a complete reinstall if it's something simple. Anyway ideas?
ASKER
Hi,
Never actually done that b4. Whats the syntax for that please?
Never actually done that b4. Whats the syntax for that please?
You will find the command for starting it from the command prompt in the DBCA.CL file in your <ORACLE_HOME>\assistants\d bca directory.
Some other points to check:
1. Is your Oracle HOME set correctly? Make sure that it is set to home for the installation that includes the DBCA;
2. Are you running under Terminal Services or X Windows? There are numerous issues with running the Oracle Configuration Assistants with these so try running it from the server console - even if you ran it successfully this way prior to the new 9iDS installation.
3. Chech the task manager for orphaned jrew.exe processes that could be left around from previous failures - these can cause problems as well.
I hope that helps
Chedgey
Some other points to check:
1. Is your Oracle HOME set correctly? Make sure that it is set to home for the installation that includes the DBCA;
2. Are you running under Terminal Services or X Windows? There are numerous issues with running the Oracle Configuration Assistants with these so try running it from the server console - even if you ran it successfully this way prior to the new 9iDS installation.
3. Chech the task manager for orphaned jrew.exe processes that could be left around from previous failures - these can cause problems as well.
I hope that helps
Chedgey
No, dbca executable is in the ORACLE_HOME/bin directory
C:\>dbca will invoke it if you have set ORACLE_HOME/bin in the PATH
C:\>dbca will invoke it if you have set ORACLE_HOME/bin in the PATH
ASKER
Right then. That tells a tale.
Went to ORACLE_HOME/bin directory. Clicked on DBCA [MS Dos batch file] and the DB Config assistant kicked in. So it's there OK, why isn't it loading from the start menu? Strange one this.
Went to ORACLE_HOME/bin directory. Clicked on DBCA [MS Dos batch file] and the DB Config assistant kicked in. So it's there OK, why isn't it loading from the start menu? Strange one this.
ASKER
Just to say the shortcut target in the properties of the start menu is:
C:\oracle\ora92\bin\launch .exe C:\oracle\ora92\assistants \dbca dbca.cl
and it 'Start's in': C:\oracle\ora92\assistants \dbca
C:\oracle\ora92\bin\launch
and it 'Start's in': C:\oracle\ora92\assistants
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Can I not recreate the short cut in some way or is that very difficult? Also will the DBCA work 'properly' via starting through the BIn directory?
DBCA in bin will work just fine.
As for the resolution for this, you probably won't get it here... but the error message might help a lot even when you call up Oracle support