to question 1 & 2:
- make sure that all related User are unlocked in your DB ( ALL "APEX_USERS", FLOWS_FILES & all "ORD... Users")
The Question is: How can i check the Functionality of Rest ?
Thanks to your response!
Here are my accounts:
select username,account_status from dba_users
where username like 'APEX%' or username in ('FLOWS_FILES','ORDS_METADATA','ORDS_PUBLIC_USER')
order by 1;
APEX_180100 EXPIRED & LOCKED
FLOWS_FILES EXPIRED & LOCKED
ORDS_METADATA EXPIRED & LOCKED
@Franck: As far as i know should flows_files stay locked
Exactly. You should unlock & unexpire all of them.
just in case you have issues with that, you can refer to this doku : https://anargodjaev.wordpress.com/2013/12/04/to-open-account-expired-locked-in-oracle/.
After unlocking all of them please try again.
If it doesnt solve the issue we will look for something else.
i have a other Installation with the same Locking status for the users. And there it is working perfect. So I think it isn´t the locking status.
I guess it´s a network problem, but to be honest i am a network dummy and i don´t know what ords do in the background (for example: why is there a jdbc download on the ords download page?)
Is there any check for the ords.war File i can use?
I see there is a new ords Version available.Can i use two Versions of ords.war in parallel (when i change the name of one?)
or can it a problem of /dev/urandom ?
I have installed:
Java(TM) SE Runtime Environment (build 1.8.0_171-b11)
Java HotSpot(TM) 64-Bit Server VM (build 25.171-b11, mixed mode)
did you unlocked the users as recommanded above?
you can reinstall ords again if you wich to do that but having 2 ords version running for one Apex is not going to work.
to Validate your ords Installation just do this:
Navigate to the location where you have the war file you used to install or upgrade the ORDS using the command line.
Execute the command below, which will prompt you to enter the config location, database connection details. Once you enter it properly, you will have validation output for your review.
java -jar ords.war validate
i have the solution for the hanging ords.war File Problem.
The Problem (on my machine) is the missing entrophie for /dev/random
This works for me:
java -Djava.security.egd=file:///dev/urandom -jar ords.war
If somebody has the same problem try::
java -verbose -jar ords.war
and see where it is hanging..