Solution to not logged on error and up the database
ORA-01012: not logged on error
ERROR
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
Cause for the error
STEP 1
- To the error run sysresv in command prompt
IPC Resources for ORACLE_SID “orcl” :
Maximum shared memory segment size (shmmax): 4398046511104 bytes
Total system shared memory (shmall): 4398046511104 bytes
Total system shared memory count (shmmni): 4096
*********************** Dumping ipcs output ********************
—— Message Queues ——–
key msqid owner perms used-bytes messages
—— Shared Memory Segments ——–
key shmid owner perms bytes nattch status
0x00000000 196608 oracle 600 524288 2 dest
0x00000000 229377 oracle 600 4194304 2 dest
0x00000000 2490370 oracle 600 2097152 2 dest
0x00000000 2523139 oracle 600 524288 2 dest
0x00000000 2686980 oracle 600 8900608 60
0x00000000 2719749 oracle 600 2415919104 30
0x00000000 2752518 oracle 600 7876608 30
0x26529038 2785287 oracle 600 16384 30
0x00000000 524296 oracle 600 8900608 73
0x00000000 557065 oracle 600 2415919104 37
0x00000000 589834 oracle 600 7876608 37
0x6b3f5b70 622603 oracle 600 16384 37
—— Semaphore Arrays ——–
key semid owner perms nsems
0x3c2a8d5c 753664 oracle 600 250
0x3c2a8d5d 786433 oracle 600 250
0x5c09307c 262146 oracle 600 250
0x5c09307d 294915 oracle 600 250
*********************** End of ipcs command dump **************
***************** Dumping Resource Limits(s/h) *****************
core file size 0 KB/UNLIMITED
data seg size UNLIMITED/UNLIMITED
scheduling priority 0 KB/0 KB
file size UNLIMITED/UNLIMITED
pending signals 30 KB/30 KB
max locked memory 128 GB/128 GB
max memory size UNLIMITED/UNLIMITED
open files 64 KB/64 KB
POSIX message queues 800 KB/800 KB
real-time priority 0 KB/0 KB
stack size 32 MB/32 MB
cpu time UNLIMITED/UNLIMITED
max user processes 16 KB/16 KB
virtual memory UNLIMITED/UNLIMITED
file locks UNLIMITED/UNLIMITED
***************** End of Resource Limits Dump ******************
Maximum map count configured per process: 65530
Total /dev/shm size: 4041465856 bytes, used: 196608 bytes
Shared Memory:
ID KEY
557065 0x00000000
589834 0x00000000
524296 0x00000000
622603 0x6b3f5b70
Semaphores:
ID KEY
262146 0x5c09307c
294915 0x5c09307d
Oracle Instance alive for sid “orcl”
STEP 2
- Using ipcrm -m remove all theshared memory segment using sysresv utility.
STEP 3
- Connect to the database
SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jun 24 23:34:53 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2432695144 bytes
Fixed Size 8899432 bytes
Variable Size 536870912 bytes
Database Buffers 1879048192 bytes
Redo Buffers 7876608 bytes
Database mounted.
SQL>ALTER DATABASE OPEN;
