Skip to Main Content

Breadcrumb

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

Hi,

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
Erro:
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.

Rating

  (1 rating)

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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

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