Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

startup database

happy10319Aug 1 2016 — edited Aug 1 2016

Hi all,

on 11.2.0.4 on AIX

Here is the situation :

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 1 09:39:31 2016 Copyright (c) 1982, 2013, Oracle.  All rights reserved. Connected.

SQL> desc v$instance;

ERROR: ORA-01012: not logged on

SQL> connect

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> shutdown immediate;

ORA-04031: unable to allocate 760 bytes of shared memory ("shared pool","unknown object","KKSSP^263","kglss")

SQL>

In alertlog :

ORA-04031: unable to allocate 760 bytes of shared memory ("shared pool","unknown object","KKSSP^1145","kglss") Process W000 died, see its trace file

And it is generating trace file every minute and saturate file system.

Can I

shutdown abort

startup

without any harm?

Thank you.

This post has been answered by Aman.... on Aug 1 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 29 2016
Added on Aug 1 2016
5 comments
1,348 views