5 Replies Latest reply: Nov 25, 2012 12:31 PM by 974328 RSS

    Unknown SID Error Message/Unable To Login to VM Manager

    974328
      Hello,

      I have installed VM Server and VM Manager on the latest Virtual Box install for Windows 7.

      When I attempt to login into the VM Manager (ID: ovm , Default Password: Welcome1) - I get
      the error message:

      "... [APP: ovm_console] An incorrect username or password was specified. ...."


      I selected all default passwords and database config values during installation (e.g., SID=XE).
      (Note: I am able to login to VM Manager GNOME desktop but I am unable to log into the VM Manager UI.
      I can log in as root in a Xterm window and the ovm Welcome1 password allows me into the GNOME environment. )


      The critical error message in the AdminServer.log IS an unknown 'SID' message (even though the default SID=XE was selected):

      *****************************************************************************************

      "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

      *****************************************************************************************

      I reviewed the responses to the "Unable to Login to VM Manager" thread so I decided to try the recommended response (unlocking ovs oracle password) even though the logs responses were different in certain areas. I logged in as Oracle with the correct user env and attempted to start the XE database via sqlplus sys user and startup command. I was unable to start the database due to the below error message:

      ******************************************************************************************

      2012-11-23 14:13:46.210
      18 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance.
      19 Failed to acquire instance startup/shutdown serialization primitive
      ~

      ******************************************************************************************

      Shutdown abort also did not get rid of this message. Symptons suggest there is a lock not being released (e.g., primitive file that needs to be cleaned up/removed.) I did remove oracle *.lck files from /tmp directory but this did not help either. The ps -elf output also reveals there are no oracle pmon processes running.

      If anybody has additional information on this matter - it would be greatly appreciated.


      ******************************************************************************************
      SUMMARY/EXCERPT OF AdminServer.log AND AdminServer-diagnostic.log

      The AdminServer.log squawks an "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"


      <> <> <1353697919018> <WL-001129> <Received exception while creating connection for pool "OVMDS": Listener refused the connection with the following error:
      198 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
      199 >
      200 ####<Nov 23, 2012 11:11:59 AM PST> <Info> <JDBC> <mjcmanager.example.com> <AdminServer> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1353697919019> <WL-001156> <Stack trace associated with message 001129 follows:
      201
      202 java.sql.SQLException: Listener refused the connection with the following error:
      203 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
      204
      205 at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:443)
      206 at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:670)

      ******************************************************************************************

      The critical AdminServer-diagnostic.log error messages are:


      AdminServer-diagnostic.log:[2012-11-23T11:17:51.872-08:00] [AdminServer] [ERROR] [] [com.oracle.ovm.mgr.faces.backing.Login] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 79deca6682202612:4258bdee:13b2eaec5e4:-8000-0000000000000099,0] [APP: ovm_console] An incorrect username or password was specified. [Security:090304]Authentication Failed: User ovm javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User ovm denied

      69 AdminServer-diagnostic.log:[2012-11-23T09:09:27.835-08:00] [AdminServer] [ERROR] [] [oracle.help.web.rich.converter.RichTopicConverter] [tid: [ACTIVE].ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 79deca6682202612:16d2c063:13b250c1b7c:-8000-0000000000000147,0] [APP: ovm_help] /u01/app/oracle/ovm-manager-3/machine1/base_adf_domain/servers/AdminServer/tmp/_WL_user/ovm_help/33se2m/war/helpsets/ovmHelp/qstart.html (No such file or directory)
      70 AdminServer-diagnostic.log:[2012-11-23T11:16:32.629-08:00] [AdminServer] [ERROR] [] [com.oracle.ovm.mgr.faces.backing.Login] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 79deca6682202612:4258bdee:13b2eaec5e4:-8000-0000000000000079,0] [APP: ovm_console] An incorrect username or password was specified. [Security:090304]Authentication Failed: User ovs javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User ovs denied
      71 AdminServer-diagnostic.log:[2012-11-23T11:16:53.672-08:00] [AdminServer] [ERROR] [] [com.oracle.ovm.mgr.faces.backing.Login] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 79deca6682202612:4258bdee:13b2eaec5e4:-8000-000000000000007f,0] [APP: ovm_console] An incorrect username or password was specified. [Security:090304]Authentication Failed: User ovm javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User ovm denied
      72 AdminServer-diagnostic.log:[2012-11-23T11:17:51.872-08:00] [AdminServer] [ERROR] [] [com.oracle.ovm.mgr.faces.backing.Login] [tid: [ACTIVE].ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 79deca6682202612:4258bdee:13b2eaec5e4:-8000-0000000000000099,0] [APP: ovm_console] An incorrect username or password was specified. [Security:090304]Authentication Failed: User ovm javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User ovm denied


      ******************************************************************************************
        • 1. Re: Unknown SID Error Message/Unable To Login to VM Manager
          budachst
          Looks like OVM can't connect to its database. Did you perform a simple install using Oracle XE as the database backend?
          If yes, Oracle XE might not be running. If you chose to install agains a Oracle SE/EE, it seems that OVM can't connect to that one.
          • 2. Re: Unknown SID Error Message/Unable To Login to VM Manager
            974328
            Thanks for the feedback but it was the default XE install (not SE, EE).
            The "Unknown SID" suggests the Oracle environment is not set up correctly or the server naming lookup is not correct.

            The install was all default values selected so these config values should have been properly set.
            • 3. Re: Unknown SID Error Message/Unable To Login to VM Manager
              974328
              Further investigation reveals the reason why I can't manually start the database as oracle user. The permissions on the oracle directories via the default install are incorrect. Running the command chown -R oracle:dba /u01/app/oracle/ allowed the database to start.. OVS user is now able to login into the XE database.

              Now logging in w/ admin user in VM results in the following error message:
              " Unexpected error during login (com.oracle.ovm.mgr.api.exception.FailedOperationException: OVMAPI_6000E Internal Error: Connection refused Connection refused Sat Nov 24 11:39:22 PST 2012), please consult logs for details.
              "

              I am spending way too much time on this Virtual box install. Any feedback would be appreciated.
              • 4. Re: Unknown SID Error Message/Unable To Login to VM Manager
                budachst
                Hi,

                if the database has not been started before OVMM started, you will get this kind of error. I think that OVM itself grabs data from the database when starting up.
                Have you tried to restart OVMM?

                On the other hand, if you're just starting to explore OVM, maybe it would be an option to try out the (currently in beta) OVM 3.2 which uses MySQL as it's database, which many people will be more comfortable with.
                • 5. Re: Unknown SID Error Message/Unable To Login to VM Manager
                  974328
                  I have it working now and I am able to log in to the VM Manager.
                  I deleted the original vm manager and reinstalled with 4 GIG of memory allocated (instead of 2G).
                  My initial install had the / directory as read-only. After it was re-installed the / directory was read write and I verified the database was started before I logged in which was not the case in the original install.

                  I am now able to login to VM manager and I am reviewing the documentation.

                  Thanks for your response though.