Posts

Showing posts with the label Oracle Apex

Oracle APEX 20.1 Admin Account Locked - Troubleshooting

I'm working on the Upgrade project where Oracle APEX 19.1 to Oracle APEX 20.1. All the steps which are given in the documentation I've followed. Able to login the the APEX Admin as well. Here the story begans, my other team members didn't observed there is a change in the ADMIN password and tried multiple times with OLD Password, then the ADMIN user was locked. Now even though I've correct password could not able to login to the APEX admin user.  How do we know this? Oracle Apex Workspace Admin login had an issue, where it was configured with a passwd which was mistakenly used old and that leads to lock the ADMIN user blocked. This APEX Login failed and say that account is blocked. There could be two reasons. First, the browser cache holding the old and wrong password so not allowing you to log in to the ADMIN account. You could try on a different browser if you are in Chrome(login issue), use Firefox or Internet Explorer try to login. Changing browser did not work!  Th...

SOA Database Adapter experiment

Image
Hey, Here I am going to create a Database user which can be used for demonstrate the database adapter. grant connect, resource to soademo identified by soademo; create a table CREATE TABLE CREDITCARDINFO ( SSN VARCHAR2(15) NOT NULL, FIRST_NAME VARCHAR2(30), LAST_NAME VARCHAR2(30), CCNUMBER VARCHAR2(20) NOT NULL, CREDITRATING NUMBER, STATUS VARCHAR2(20) NOT NULL ); create a Table using XE Apex tool Insert records in to table Now, lets do insert operation on the table that was created following records for testing purpose insert into CREDITCARDINFO VALUES ( '111-11-1111', 'Neena', 'Kochhar', '1234-1234-1234-1234', '3' , 'VALID' ); insert into CREDITCARDINFO VALUES ( '222-22-2222', 'Steven', 'King', '5678-5678-5678-5678', '4' , 'VALID' ); insert into CREDITCARDINFO VALUES ( '333-33-3333', 'Lex', 'Devarakonda...