Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, sai.

Asked: September 06, 2023 - 2:16 pm UTC

Last updated: September 08, 2023 - 7:20 am UTC

Version: 21c (XE)Express Edition, APEX 22.1

Viewed 1000+ times

You Asked


When I start the ords server file I am getting following error (ORA-12514) TNS:Listner does not currently know of service requested in connect descriptor.

I have tried connecting using SQL PLUS as sys

SQL> conn/ as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

I have tried STARTUP command
SQL> startup
ORA-00093 : pga_aggregate_limit must be between 6000M and 100000G
ORA-01078 : failure in processing system parameters

I have set my pga_aggreagte_limit to 4G

and Connor said...

In the alert log, we'll dump out the values of the parameters we found.

Can you get the alert log and paste in the parameters from the *last* attempted startup and post that as a comment, and we'll work from there.


  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

More to Explore


Need more information on Administration? Check out the Administrators guide for the Oracle Database