1 2 Previous Next 18 Replies Latest reply: Sep 10, 2013 3:11 PM by maddymahi RSS

    DBCA issue

    948527
      I am SQL Server DBA and want to learn ORACLE

      I have just installed Oracle Developer Day package (prebuilt VM consist of Oracle 11GR2 & Enterprise Linux) in Oracle VM Virtual Box for demo & learning purpose. But whenever I am trying to invoke DBCA utility using dbca , the below error messages is coming:-

      Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sysman/assistants/dbca/Dbca
      Caused by: java.lang.ClassNotFoundException: oracle.sysman.assistants.dbca.Dbca
      at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
      at java.security.AccessController.doPrivileged(Native Method)
      at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
      at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
      at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
      Could not find the main class: oracle.sysman.assistants.dbca.Dbca. Program will exit.


      When I run which dbca in terminal window it shows correct path
      ~/app/oracle/product/11.2.0/dbhome_2/bin/dbca

      echo $PATH shows
      /home/oracle/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin

      How to resolve this issue ?

      Edited by: 945524 on Jul 10, 2012 8:43 AM
        • 1. Re: DBCA issue
          sb92075
          945524 wrote:
          I am SQL Server DBA and want to learn ORACLE

          I have just installed Oracle Developer Day package (prebuilt VM consist of Oracle 11GR2 & Enterprise Linux) in Oracle VM Virtual Box for demo & learning purpose. But whenever I am trying to invoke DBCA utility using dbca , the below error messages is coming:-

          Exception in thread "main" java.lang.NoClassDefFoundError: oracle/sysman/assistants/dbca/Dbca
          Caused by: java.lang.ClassNotFoundException: oracle.sysman.assistants.dbca.Dbca
          at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
          at java.security.AccessController.doPrivileged(Native Method)
          at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
          at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
          at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
          at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
          Could not find the main class: oracle.sysman.assistants.dbca.Dbca. Program will exit.


          When I run which dbca in terminal window it shows correct path
          ~/app/oracle/product/11.2.0/dbhome_2/bin/dbca

          echo $PATH shows
          /home/oracle/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin

          How to resolve this issue ?

          Edited by: 945524 on Jul 10, 2012 8:43 AM
          issue follow OS commands

          id
          env | sort
          ls -ltr /home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs

          COPY commands & results then PASTE all back here
          • 2. Re: DBCA issue
            948527
            ANT_HOME=/home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/ant
            CLASSPATH=/home/oracle/app/oracle/product/11.2.0/dbhome_2/ucp/lib/ucp.jar:/home/oracle/app/oracle/product/11.2.0/dbhome_2/jdbc/lib/ojdbc6.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/lib/ttjdbc6.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/lib/orai18n.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/lib/timestenjmsxla.jar:/home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/jms1.1/lib/jms.jar:.:/home/oracle/app/oracle/product/11.2.0/dbhome_2/ucp/lib/ucp.jar:/home/oracle/app/oracle/product/11.2.0/dbhome_2/jdbc/lib/ojdbc6.jar
            COLORTERM=gnome-terminal
            DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-i6mZJFTWoF,guid=9fd93602f18f2b715dca9d004ffc4959
            DESKTOP_SESSION=default
            DISPLAY=:0.0
            EDITOR=vi
            G_BROKEN_FILENAMES=1
            GDMSESSION=default
            GDM_XSERVER_LOCATION=local
            GNOME_DESKTOP_SESSION_ID=Default
            GNOME_KEYRING_SOCKET=/tmp/keyring-x8CIWR/socket
            GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
            HISTSIZE=1000
            HOME=/home/oracle
            HOSTNAME=localhost.localdomain
            INPUTRC=/etc/inputrc
            JAVA_HOME=/usr/java/latest
            LANG=en_US.UTF-8
            LD_LIBRARY_PATH=/home/oracle/app/oracle/product/11.2.0/dbhome_2/lib
            LESSOPEN=|/usr/bin/lesspipe.sh %s
            LOGNAME=oracle
            LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
            MAIL=/var/spool/mail/oracle
            ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_2
            ORACLE_SID=orcl
            PATH=/usr/java/latest/bin:/home/oracle/app/oracle/product/TimesTen/tt1121/bin:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/oci:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc/xla:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/jdbc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/odbc_drivermgr:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/proc:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/ttclasses:/home/oracle/app/oracle/product/TimesTen/tt1121/quickstart/sample_code/ttclasses/xla:/home/oracle/app/oracle/product/TimesTen/tt1121/ttoracle_home/instantclient_11_1:/home/oracle/app/oracle/product/TimesTen/tt1121/ttoracle_home/instantclient_11_1/sdk:/home/oracle/app/oracle/product/TimesTen/tt1121/3rdparty/ant/bin:/usr/java/latest/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin:/home/oracle/bin:/home/oracle/app/oracle/product/11.2.0/dbhome_2/bin
            PWD=/home/oracle
            SESSION_MANAGER=local/localhost.localdomain:/tmp/.ICE-unix/2737
            SHELL=/bin/bash
            SHLVL=2
            SSH_AGENT_PID=2801
            SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
            SSH_AUTH_SOCK=/tmp/ssh-nPnjIH2737/agent.2737
            TERM=xterm
            TNS_ADMIN=/home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin
            TT_HOME=/home/oracle/app/oracle/product/TimesTen/tt1121
            TT_RESET=/home/oracle/Desktop/Database Track/TimesTen Scripts/imdb_cache/.reset
            TT_SCRIPTS=/home/oracle/Desktop/Database Track/TimesTen Scripts/imdb_cache
            USERNAME=oracle
            USER=oracle
            _=/usr/bin/env
            WINDOWID=16777298
            XAUTHORITY=/tmp/.gdmNQ9BHW
            XDB_HOL=/home/oracle/Desktop/Database*/XMLDB*/2011
            XMODIFIERS=@im=none
            [oracle@localhost ~]$ ls -ltr /home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs
            total 28
            -rw-r--r-- 1 oracle oracle 2851 May 15 2009 init.ora
            -rw-rw---- 1 oracle oracle 1544 Oct 2 2010 hc_DBUA0.dat
            -rw-r----- 1 oracle oracle 621 Oct 2 2010 initorcl.ora
            -rw-r----- 1 oracle oracle 24 Oct 2 2010 lkORCL
            -rw-r----- 1 oracle oracle 1536 Oct 2 2010 orapworcl
            -rw-rw---- 1 oracle oracle 1544 Jul 10 08:15 hc_orcl.dat
            -rw-r----- 1 oracle oracle 3584 Jul 10 08:15 spfileorcl.ora
            • 3. Re: DBCA issue
              948527
              Hi any help you can provide (I just imported pre built VM and MD5 checksum matched download size with one posted on ORACLE site). This not a good strart for me (being with SQL Server for 13 years I am spoiled)

              Edited by: 945524 on Jul 10, 2012 9:22 AM
              • 4. Re: DBCA issue
                EdStevens
                945524 wrote:
                Hi any help you can provide (I just imported pre built VM and MD5 checksum matched download size with one posted on ORACLE site).
                Patience, Grasshopper

                You posted this follow-up a mere 22 minutes after your previous post.

                This forum is not a chat line, and it is not paid support.

                No one is responsible for monitoring it and giving a quick response.

                Furthermore, it is a global forum. The person with the information you seek may very well live 20 time zones away from you and was going to bed just as you posted. He will not even see your post for several more hours.

                Your original post went up in the middle of the night for half the world.

                No one with the information you seek is deliberately withholding it until you sound sufficiently desperate.

                This not a good strart for me (being with SQL Server for 13 years
                the first thing you need to learn about oracle vs. SQL Server is that the similarity begins AND ENDS with 'SELECT * FROM EMP;' You need to forget about 90% of what you learned with SQL Server. The internal differences and the implementation of their progamming languages (t-sql vs. pl/sql) are vast. The very term 'database' has a completely different meaning.

                That said, welcome to the world of a real rdbms product.
                ;-)

                I am spoiled)
                mmm....
                >

                Now, to your original question: How much linux experience do you have? The dbca runs as an x-windows GUI, and so requires the ability to support that. I have a full virtual lab of linux servers running on my laptop. I access them (as well as my real production and dev servers) from my desktop OS via an ssh session using the free utility 'putty'. I use the free utility 'xming' as the x-server on the host os. I configure my putty session to allow x11 port forwarding. when I need to access a GUI utility such as dbca, netca, asmcia, I fire up xming, then make my connection to the server. There is a simple x-utility on linux call 'xclock'. If you can run that, you should be able to run dbca. If you can't run xclock, you'll not be able to run dbca.
                Edited by: 945524 on Jul 10, 2012 9:22 AM
                • 5. Re: DBCA issue
                  948527
                  Xclock runs fine.... this is oracle enterprise linux with GNOME GUI.... I have unix background and I also knwo how to use Exceed and hummigbird...



                  By the way...
                  That said, welcome to the world of a real rdbms product
                  I am not going to fight a religious war :-) In each and every release MS SQL is getting better.... that is all I can say....

                  If you can help me with DBCA issue.....

                  Edited by: 945524 on Jul 10, 2012 10:57 AM

                  Edited by: 945524 on Jul 10, 2012 11:01 AM
                  • 6. Re: DBCA issue
                    sb92075
                    humor me & try the following from terminal window where you are logged on the OS as user "oracle"

                    type the lines below EXACTLY as presented here

                    sqlplus
                    / as sysdba
                    startup
                    select * from v$version;

                    COPY commands & results then PASTE all back here
                    • 7. Re: DBCA issue
                      948527
                      BANNER
                      --------------------------------------------------------------------------------
                      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
                      PL/SQL Release 11.2.0.2.0 - Production
                      CORE 11.2.0.2.0 Production
                      TNS for Linux: Version 11.2.0.2.0 - Production
                      NLSRTL Version 11.2.0.2.0 - Production
                      • 8. Re: DBCA issue
                        sb92075
                        945524 wrote:
                        BANNER
                        --------------------------------------------------------------------------------
                        Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
                        PL/SQL Release 11.2.0.2.0 - Production
                        CORE 11.2.0.2.0 Production
                        TNS for Linux: Version 11.2.0.2.0 - Production
                        NLSRTL Version 11.2.0.2.0 - Production
                        Well, you do have a functioning DB.
                        dbca is java code & unfortunately does not really log its activity.

                        I have never seen it fail as you posted its trace dump.
                        something is mis-configured at OS level, but I am at a loss to discern what it might be.
                        Sorry!
                        • 9. Re: DBCA issue
                          Catch 22
                          Your problem might be due to defective software:

                          Check Problems running DBCA on Linux
                          • 10. Re: DBCA issue
                            948527
                            Hopefully ORACLE will fix it one day....
                            • 11. Re: DBCA issue
                              EdStevens
                              945524 wrote:
                              Xclock runs fine.... this is oracle enterprise linux with GNOME GUI.... I have unix background and I also knwo how to use Exceed and hummigbird...
                              Ok. That's good. I had to ask because we get a LOT of people here who find themselves thrown into *nix and are completely clueless about what to do with a command prompt.  Since you hadn't stated otherwise, and coming from a long SQL-Server background you very easily could have been amongst them and we needed to get a better idea of what level you were at on this. 
                              >
                              >
                              By the way...
                              That said, welcome to the world of a real rdbms product
                              I am not going to fight a religious war :-) In each and every release MS SQL is getting better.... that is all I can say....

                              If you can help me with DBCA issue.....
                              Personally, I've never seen it have any issue as long as the necesseary x-server and redirection was in place. So I'm already out of ideas on that and will be interested to see what else this thread reveals.

                              Sorry I couldn't be more help; :-(
                              >
                              Edited by: 945524 on Jul 10, 2012 10:57 AM

                              Edited by: 945524 on Jul 10, 2012 11:01 AM
                              • 12. Re: DBCA issue
                                Srini Chavali-Oracle
                                As noted above, the VM you installed comes with a functioning database whose SID seems to be "orcl" - is there a reason for you to create another database using dbca ?

                                I have no experience with MSSQL so have no idea what a "database" in MSSQL is in Oracle terms. An Oracle database can host multiple/users schemas.

                                HTH
                                Srini
                                • 13. Re: DBCA issue
                                  EdStevens
                                  Srini Chavali wrote:
                                  As noted above, the VM you installed comes with a functioning database whose SID seems to be "orcl" - is there a reason for you to create another database using dbca ?

                                  I have no experience with MSSQL so have no idea what a "database" in MSSQL is in Oracle terms. An Oracle database can host multiple/users schemas.

                                  HTH
                                  Srini
                                  A MSSql 'database' is roughly equivalent of an oracle schema.
                                  • 14. Re: DBCA issue
                                    Srini Chavali-Oracle
                                    Thanks Ed - I figured as much - hence the reason why OP wants to create another "database", as opposed to creating a new schema in the existing database

                                    HTH
                                    Srini
                                    1 2 Previous Next