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
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
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
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..
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
Oh Silly mistake , let me check thanks .. Seems power of observation has decreased
or have become lazy..
Anyway thanks will get back.