Hello,
In our company, we have server oracle on Suse Linux with two instances TETA and TETA201.
One day on a server broke down, because there are no free space due increasing files "archivelog".
After that I removed manually several oldest archivelog files, but after rebooting the server error occurs when connecting to the database:
"ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0 "
$ ORACLE_SID is set to TETA, if export it to TETA201 connection is working properly
When Oracle service starts there are no errors, but runs only instance TETA201 running properly
#############################################################################
# Begin of O R A C L E startup section #
#############################################################################
SETTINGS start from /etc/sysconfig/oracle
- Set Kernel Parameters for Oracle: yes
- Start Oracle Listener: yes
- Start Oracle Database: yes
- Start Oracle Webserver: no
- Start Oracle EManager: yes
- Start Oracle iSQLPLUS Manager: yes
- Start Oracle Agent: no
- Start Oracle Internet Filesystem: no
- Start Oracle Directory Manager: no
Can't find needed file: isqlplusctl - Setting START_ORACLE_DB_ISQLPLUS = no
Oracle Agent undefinied or not properly set. Please check.
Setting kernel parameters for Oracle, see file
/etc/sysconfig/oracle for explanations.
Shared memory: SHMMAX=3294967296 SHMMNI=4096 SHMALL=2097152
Semaphore values: SEMMSL=1250 SEMMNS=32000 SEMOPM=100 SEMMNI=256
Other values: FILE_MAX_KERNEL=131072 IP_LOCAL_PORT_RANGE=1024 65000
RMEM_DEFAULT=4194304 WMEM_DEFAULT=262144 RMEM_MAX=4194304 WMEM_MAX=262144
Huge Pages:
ULIMIT values: MAX_CORE_FILE_SIZE_SHELL=unlimited
FILE_MAX_SHELL=65536 PROCESSES_MAX_SHELL=16384
Kernel parameters set for Oracle: done
- Starting Listener... done
+ Starting Database(s)...
No start entry for SID TETATEST at /oracle/product/11.2.0/dbhome_1/ inskippedratab
Processing Database instance "TETA": log file /oracle/product/11.2.0/dbhome_2/startup.log
Processing Database instance "TETA201": log file /oracle/product/11.2.0/dbhome_1/startup.log
Status of Oracle database(s) start: done
- Starting Apache... unused
- Starting Application Server... unused
- Starting Application Server Console... unused
- Starting Agent... unused
- Starting Enterprise Manager...
Starting DB Console for TETA Starting DB Console for TETA201 done
- Starting iSQLPLUS Manager... skipped
- Starting Oracle Internet Filesystem... unused
- Starting Oracle Internet Directory... unused
#############################################################################
# End of O R A C L E section #
#############################################################################
#############################################################################
# End of O R A C L E section #
#############################################################################
/oracle/product/11.2.0/dbhome_1/startup.log
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 18 11:43:00 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> Polaczono.
SQL> Instancja ORACLE zostala zamknieta.
SQL> Odlaczono od Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 18 11:43:01 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 1043886080 bytes
Fixed Size 2234960 bytes
Variable Size 603981232 bytes
Database Buffers 432013312 bytes
Redo Buffers 5656576 bytes
Baza danych zostala zamontowana.
Baza danych zostala otwarta.
SQL> Odlaczono od Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
/oracle/product/11.2.0/dbhome_2/bin/dbstart: Database instance "TETA201" warm started.
/oracle/product/11.2.0/dbhome_2/startup.log
pon sty 18 11:42:52 CET 2016
SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 18 11:42:52 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 4175568896 bytes
Fixed Size 2259840 bytes
Variable Size 1409287296 bytes
Database Buffers 2751463424 bytes
Redo Buffers 12558336 bytes
Baza danych zostala zamontowana.
ORA-03113: end-of-file on communication channel
ID procesu: 10080
ID sesji: 33, numer seryjny: 3
SQL> Odlaczono od Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
/oracle/product/11.2.0/dbhome_2/bin/dbstart: Database instance "TETA" warm started.
linux:~ # service oracle status
#############################################################################
# Begin of O R A C L E status section #
#############################################################################
Kernel Parameters
Shared memory: SHMMAX= 3294967296 SHMMNI= 4096 SHMALL= 2097152
Semaphore values: SEMMSL, SEMMNS, SEMOPM, SEMMNI: 1250 32000 100 256
Database-Instances
Instance TETA is down (autostart: Y)
Instance TETATEST is down (autostart: N)
Instance TETA201 is down (autostart: Y)
TNS-Listener: up
Web-Server (Apache httpd): down (0 processes)
Process list for user oracle:
PID TTY STAT TIME COMMAND
9855 ? Ssl 0:00 /oracle/product/11.2.0/dbhome_2/bin/tnslsnr LISTENER
10128 ? Ss 0:00 ora_pmon_TETA201
10130 ? Ss 0:00 ora_psp0_TETA201
10132 ? Ss 0:00 ora_vktm_TETA201
10136 ? Ss 0:00 ora_gen0_TETA201
10138 ? Ss 0:00 ora_diag_TETA201
10140 ? Ss 0:00 ora_dbrm_TETA201
10142 ? Ss 0:00 ora_dia0_TETA201
10144 ? Ss 0:00 ora_mman_TETA201
10146 ? Ss 0:00 ora_dbw0_TETA201
10148 ? Ss 0:00 ora_lgwr_TETA201
10150 ? Ss 0:00 ora_ckpt_TETA201
10152 ? Ss 0:00 ora_smon_TETA201
10154 ? Ss 0:00 ora_reco_TETA201
10156 ? Ss 0:00 ora_mmon_TETA201
10158 ? Ss 0:00 ora_mmnl_TETA201
10166 ? Ss 0:00 ora_qmnc_TETA201
10338 ? Ss 0:00 ora_cjq0_TETA201
11195 ? Ss 0:00 ora_q000_TETA201
11197 ? Ss 0:00 ora_q001_TETA201
#############################################################################
# End of O R A C L E section #
#############################################################################
Please help