Oracle 19 автостарт базы

systemctl status имя_сервиса

[oracle@erip ~]$ systemctl status dbora.service
● dbora.service - The Oracle Database Service
   Loaded: loaded (/usr/lib/systemd/system/dbora.service; enabled; vendor preset: disabled)
   Active: active (running) since Thu 2022-08-18 16:54:57 +03; 54s ago
  Process: 1055 ExecStart=/bin/bash -c /home/oracle/scripts/start_all.sh (code=exited, status=0/SUCCESS)
 Main PID: 1324 (tnslsnr)
    Tasks: 2 (limit: 22933)
   Memory: 259.8M
   CGroup: /system.slice/dbora.service
           └─1324 /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr LISTENER -inherit

Aug 18 16:54:49 erip systemd[1]: Starting The Oracle Database Service...
Aug 18 16:54:53 erip bash[1374]: Processing Database instance "erip": log file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/log/startup.log
Aug 18 16:54:57 erip systemd[1]: Started The Oracle Database Service.

[Unit]
Description=The Oracle Database Service
After=syslog.target network.target

[Service]
# systemd ignores PAM limits, so set any necessary limits in the service.
# Not really a bug, but a feature.
# https://bugzilla.redhat.com/show_bug.cgi?id=754285
LimitMEMLOCK=infinity
LimitNOFILE=65535

#Type=simple
# idle: similar to simple, the actual execution of the service binary is delayed
#       until all jobs are finished, which avoids mixing the status output with shell output of services.
Type=forking
RemainAfterExit=yes
User=oracle
Group=oinstall
Restart=no
ExecStart=/bin/bash -c '/home/oracle/scripts/start_all.sh'
ExecStop=/bin/bash -c '/home/oracle/scripts/stop_all.sh'

[Install]
WantedBy=multi-user.target

/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbstart: Starting up database "erip"
Thu Aug 18 16:54:53 +03 2022


SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 18 16:54:54 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

SQL> ERROR:
ORA-01017: invalid username/password; logon denied


SQL> SP2-0640: Not connected
SQL> 
/u01/app/oracle/product/19.0.0/dbhome_1/bin/dbstart: Database instance "erip" warm started.

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=erip
export ORACLE_UNQNAME=erip
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=erip
export PDB_NAME=eripdb
export DATA_DIR=/u02/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export ORAENV_ASK=NO
export ORAENV_ASK=YES
dbstart \$ORACLE_HOME