Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Uninstall does not appear to uninstall

DarraghMay 3 2016 — edited May 3 2016

Having an issue with installing ORDS as standalone, was getting /i folder does not exist, so I uninstalled, but it seems this is not a complete uninstall.

----

downloaded ords.3.0.4.60.12.48

extracted the scripts for a manual uninstall

java -jar ords.war ords-scripts --scriptdir ./scripts


ran the ords_uninstall script from ./ords.3.0.4.60.12.48/scripts/uninstall/core under my SYS account


All Good no errors - then performed an install


I created a params folder, adding a file ords_param.properties file


db.hostname=portaldev.corehr.com

db.port=1521

db.servicename=portaldev

db.username=APEX_PUBLIC_USER

schema.tablespace.default=COREHR

schema.tablespace.temp=COREHR_TEMP

standalone.http.port=8383

standalone.mode=true

standalone.static.images=

user.tablespace.default=COREHR

user.tablespace.temp=COREHR_TEMP

ran an install

java -jar ords.war install simple


tried running in standalone mode, getting errors with /i folder, running following for standalone


java -jar ords.war standalone --port 8383


so, decided to uninstall again and do an advanced install, this time I ran the uninstall from JAVA, ran


java -jar ords.war uninstall


No errors, then I removed the params folder and running the advanced install option


java -jar ords.war install advanced


and the first message says


verify ORDS schema in Database Configuration apex with connection host: portaldevdb.corehr.com port: 1521 service name: PORTALDEV


why, I just performed an uninstall, why is ORDS remembering the previous configuration options ? I want ORDS to ask me all the installation questions again.


this is the install questions, it simply asks for tablespace names, nothing on other questions mentioned in the documentation

Verify ORDS schema in Database Configuration apex with connection host: portaldevdb.corehr.com port: 1521 service name: PORTALDEV

Please login with SYSDBA privileges to verify Oracle REST Data Services schema. Installation may be required.

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

Enter the database password for SYS:

Confirm password:

May 03, 2016 4:39:39 PM oracle.dbtools.rt.config.setup.SchemaSetup addSchemaParams

INFO:

Oracle REST Data Services schema does not exist and will be created.

Enter the default tablespace for ORDS_METADATA [SYSAUX]:COREHR

Enter the temporary tablespace for ORDS_METADATA [TEMP]:COREHR_TEMP

Enter the default tablespace for ORDS_PUBLIC_USER [USERS]:COREHR

Enter the temporary tablespace for ORDS_PUBLIC_USER [TEMP]:COREHR_TEMP

May 03, 2016 4:40:07 PM oracle.dbtools.installer.Installer installORDS

INFO:

Installing Oracle REST Data Services version 3.0.4.60.12.48

... Log file written to /Users/darragh.duffy/GoogleDrive/labs/ords.3.0.4.60.12.48/logs/ordsinstall_2016-05-03_164007_00485.log

... Verified database prerequisites

... Created Oracle REST Data Services schema

... Created Oracle REST Data Services proxy user

... Granted privileges to Oracle REST Data Services

... Created Oracle REST Data Services database objects

May 03, 2016 4:40:45 PM oracle.dbtools.installer.Installer installORDS

INFO: Completed installation for Oracle REST Data Services version 3.0.4.60.12.48. Elapsed time: 00:00:38.147

Enter 1 if you wish to start in standalone mode or 2 to exit [1]:



So, I want to completely remove ORDS and start afresh, then run in standalone mode via java -jar ords.war standalone --port 8383


I have upload my log file from the installation.



This post has been answered by Kris Rice-Oracle on May 3 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2016
Added on May 3 2016
3 comments
1,673 views