ORA-01012: not logged on

I was testing to restore a database from a VEEAM backup. After it reports it is finished I try to connect to the database and there is where I got this error.

ORA-01012: not logged on


[oracle@serpentcustom trace]$ tail -f $ORACLE_BASE/diag/tnslsnr/$(hostname -s)/listener/trace/listener.log
30-APR-2020 17:07:24 * service_update * wind * 0
2020-04-30T17:09:20.655123+08:00
30-APR-2020 17:09:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=epchrs.ecp.priv)(CID=(PROGRAM=sqlplus)(HOST=serpentcustom.ecp.priv)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.131.128.39)(PORT=27398)) * establish * epchrs.ecp.priv * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12547: TNS:lost contact
  TNS-12560: TNS:protocol adapter error
   TNS-00517: Lost contact
    Linux Error: 32: Broken pipe
2020-04-30T17:09:30.499809+08:00
30-APR-2020 17:09:30 * service_update * epchrs * 0


There is no problem with the listener since I still cannot connect using local oracle


[oracle@serpentcustom bin]$ sysresv

----TOP HALF NOT SHOWN

***************** End of Resource Limits Dump ******************
Maximum map count configured per process:  65530
Total /dev/shm size: 4100820992 bytes, used: 0 bytes
Shared Memory:
ID              KEY
5210115         0x00000000
5242884         0x00000000
5177346         0x00000000
5275653         0x3b6212a0
Semaphores:
ID              KEY
3440640         0x6466d928
3473409         0x6466d929
Oracle Instance alive for sid "epchrs"
[oracle@serpentcustom bin]$

[oracle@serpentcustom bin]$ ipcrm -m 5210115

[oracle@serpentcustom bin]$ ipcrm -m 5242884

[oracle@serpentcustom bin]$ ipcrm -m 5177346

[oracle@serpentcustom bin]$ ipcrm -m 5275653

This caused the database to shutdown.

I opened it but got an errror

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4731170856 bytes

Fixed Size                  8667176 bytes

Variable Size             989855744 bytes

Database Buffers         3724541952 bytes

Redo Buffers                8105984 bytes

ORA-01102: cannot mount database in EXCLUSIVE mode

-- So I bounce the database

SQL> shutdown immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 4731170856 bytes

Fixed Size                  8667176 bytes

Variable Size             989855744 bytes

Database Buffers         3724541952 bytes

Redo Buffers                8105984 bytes

Database mounted.

Database opened.

SQL> select * from chrs.backup_test;

DESCRIPTION

--------------------

CAP_DATE

----------------------------------------------------------

First One

29-APR-20 12.36.12.170958 PM

Second One

30-APR-20 09.27.12.569540 AM

SQL>

SQL> conn system/N3ptun30n3@epchrs

Connected.

SQL>