dbca per crear/configurar la base de dades
lsnrctl start per iniciar l’escoltador
dbstart $ORACLE_HOME per iniciar la base de dades
dbshut $ORACLE_HOME per parar la base de dades
Per evitar que la contrasenya expiri:
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Script per iniciar [/home/oracle/scripts/start_all.sh]
#!/bin/bash . /home/oracle/scripts/setEnv.sh export ORAENV_ASK=NO . oraenv export ORAENV_ASK=YES dbstart $ORACLE_HOME
Script per parar [/home/oracle/scripts/stop_all.sh]
#!/bin/bash . /home/oracle/scripts/setEnv.sh export ORAENV_ASK=NO . oraenv export ORAENV_ASK=YES dbshut $ORACLE_HOME
Servei [/etc/systemd/system/dbora.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. 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