Solve Oracle Apex ORDS Error - ORA-12514 – TNS : Listener - ORA-01109: database not open

In this blog post, I will show how to handle two different error messages after starting ORDS.

Step 1: Start ORDS

Start ORDS with the following command:

 

Bash

xxxxxxxxxx

 

1

java -jar ords.war serve

Step 2: Fix "ORA-12514" Error

If you see the error message ORA-12514 – TNS:listener does not currently know of service requested in connect descriptor, it means that it is not possible to connect to the database. This could happen if ORDS started too early before the database was ready.

• Click on "Start" and open "Services".
• Search for the Oracle service, e.g., OracleOraDB19Home1TNSListener.
• Right-click on it and select "Restart".

Step 3: Restart ORDS

Restart ORDS. If APEX still does not work and you see the error message ORA-01109: database not open, it means that the database is not open.

Step 4: Open the Database

Open the command prompt (cmd) and execute the following SQL commands:

 

SQL

xxxxxxxxxx

17

 

1

-- Open SQL Plus and connect as sysdba:

2

sqlplus sys as sysdba

3

​

4

-- Check the PDBs:

5

SELECT name, open_mode FROM v$pdbs;

6

​

7

-- Ensure the target PDB is open:

8

ALTER PLUGGABLE DATABASE orclpdb OPEN;

9

​

10

-- Register the database:

11

ALTER SYSTEM REGISTER;

12

​

13

-- Exit SQL Plus:

14

exit

15

​

16

-- Check the listener:

17

lsnrctl status

Step 5: Restart ORDS

Restart ORDS. APEX should now work. If not, check if the user accounts are locked.

Step 6: Unlock User Accounts

Log in to SQL Plus and execute the following commands to unlock the user accounts:

 

SQL

xxxxxxxxxx

17

 

1

-- Unlock ORDSYS user:

2

ALTER USER ORDSYS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

3

​

4

-- Unlock ANONYMOUS user:

5

ALTER USER ANONYMOUS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

6

ALTER USER ANONYMOUS IDENTIFIED BY "Password1!" ACCOUNT UNLOCK CONTAINER=ALL;

7

​

8

-- Switch container:

9

SHOW PDBS;

10

ALTER SESSION SET CONTAINER = orclpdb;

11

SHOW PDBS;

12

​

13

-- Unlock other users:

14

ALTER USER APEX_LISTENER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

15

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

16

ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

17

ALTER USER APEX_240100 IDENTIFIED BY "Password1!" ACCOUNT UNLOCK;

Step 7: Restart ORDS

Restart ORDS. If it still does not work, you need to reconfigure ORDS.

Step 8: Reconfigure ORDS

First, delete the following two folders in your ORDS directory:

• Folder 1: databases
• Folder 2: global

Then navigate to the directory where you unzipped ORDS (e.g., C:\ords) and open a command prompt there.

Run the following command to reinstall ORDS:

 

Shell

xxxxxxxxxx

 

1

java -jar ords.war install

Step 9: Answer Installation Prompts

• Hostname: localhost
• Port: 1521
• Service Name: The service name entered during the Oracle DB installation (e.g., orclpdb).
• Username: sys
• Password: Enter the sys password.
• When asked if all is correct, press A to agree and proceed.

Hopefully, after these steps, ORDS will start, and APEX should work.

Good luck!

 {fullWidth}