5 Replies Latest reply on Jul 12, 2017 10:54 AM by pauljohny100

    unable to  uninstall ords ..

    pauljohny100

      I have installed ords  but seems its not done properly

      i tried to uninstall but  i receive the following error

      i type

      java -jar ords.war uninstall

       

      i receive Failed to connect to user sys as sysdba error Kindly help guide

        • 1. Re: unable to  uninstall ords ..
          pauljohny100

          Also see additional error

          C:\ords>java -jar ords.war validate

          Enter the name of the database server [XE]:

          Enter the database listen port [1521]:

          Enter the database service name [XE]:

          Please login with SYSDBA privileges to verify Oracle REST Data Services schema.

           

           

          Enter the username with SYSDBA privileges to verify the installation [SYS]:

          Enter the database password for SYS:

          Confirm password:

          Jul 12, 2017 6:33:28 AM oracle.dbtools.rt.config.setup.SchemaSetup verifyDBAUser

          Connection

          WARNING: Failed to connect to user SYS AS SYSDBA jdbc:oracle:thin:@//XE:1521/XE

           

           

          IO Error: Unknown host specified

          • 2. Re: unable to  uninstall ords ..
            Kiran Pawar

            Hi pauljohny100,

            pauljohny100 wrote:

             

            Also see additional error

            C:\ords>java -jar ords.war validate

            Enter the name of the database server [XE]:

            Are you specifying the correct "Database Server" name. This is the name of the server on which database is installed.(for e.g. "localhost" if database is installed on local machine or FQDN Fully Qualified Domain Name (myserver.mydomain.com) if you have a another machine (in network) on which database is installed).

            NOTE: I don't think XE is your database server name, it may be SID/Service Name of your database. Same applies for "uninstall" command for ORDS.

             

            Hope this helps!

             

            Regards,

            Kiran

            • 3. Re: unable to  uninstall ords ..
              pauljohny100

              SQL> select sys_context('userenv','db_name') from dual;

               

               

              SYS_CONTEXT('USERENV','DB_NAME')

              ---------------------------------------------------------------------

               

               

              XE

              Also select name from v$databae;

              XE

              SQL> select sys_context('userenv','db_name') from dual;

               

               

              SYS_CONTEXT('USERENV','DB_NAME')

              ---------------------------------------------------------------------

               

               

              XE

              Still trying to find the solution..

              • 4. Re: unable to  uninstall ords ..
                Kiran Pawar

                Hi pauljohny100,

                pauljohny100 wrote:

                 

                SQL> select sys_context('userenv','db_name') from dual;

                SYS_CONTEXT('USERENV','DB_NAME')

                ---------------------------------------------------------------------

                XE

                Still you are looking the wrong one. The "hostname" of the server where the database is installed not the database name. That should be input for the command:

                C:\ords>java -jar ords.war validate
                Enter the name of the database server [XE]:
                

                or command

                C:\ords>java -jar ords.war uninstall
                Enter the name of the database server [XE]:
                

                and in the both the above commands you are using XE as database server hostname, hence it is causing errors.

                 

                Check the database server hostname by:

                SELECT SYS_CONTEXT('USERENV','SERVER_HOST') FROM dual;
                

                or by:

                SELECT host_name FROM v$instance;
                

                 

                Regards,

                Kiran

                1 person found this helpful
                • 5. Re: unable to  uninstall ords ..
                  pauljohny100

                  Oh Silly mistake , let me check thanks .. Seems power of observation has decreased

                  or  have become lazy..

                  Anyway thanks will get back.