Solved

Database Configuration Assistant not working

Posted on 2004-10-23
2,312 Views
Last Modified: 2008-03-03
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?
0
Question by:rl_marton
    9 Comments
     
    LVL 23

    Expert Comment

    by:seazodiac
    try to start DBCA at the command line, you can see the error message this way....


    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
    0
     

    Author Comment

    by:rl_marton
    Hi,

    Never actually done that b4. Whats the syntax for that please?

    0
     
    LVL 6

    Expert Comment

    by:chedgey
    You will find the command for starting it from the command prompt in the DBCA.CL file in your <ORACLE_HOME>\assistants\dbca 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
    0
     
    LVL 23

    Expert Comment

    by:seazodiac
    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
    0
     

    Author Comment

    by:rl_marton
    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.
    0
     

    Author Comment

    by:rl_marton
    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
    0
     
    LVL 23

    Accepted Solution

    by:
    use the DBCA in the BIn directory. this is a known bug in windows platform.

    the short cut is inproperly created.
    0
     

    Author Comment

    by:rl_marton
    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?

    0
     
    LVL 23

    Expert Comment

    by:seazodiac
    DBCA in bin will work just fine.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to recover a database from a user managed backup

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now