Версия ОС :
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
NAME="Oracle Linux Server"
VERSION="7.7"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.7"
PRETTY_NAME="Oracle Linux Server 7.7"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:7:7:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"
ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7"
ORACLE_BUGZILLA_PRODUCT_VERSION=7.7
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=7.7
Версия БД 12.2.0.1
----------
Данный скрипт на 11.2 версии работает норм
/etc/oratab
1.
dbprod:/u01/app/oracle/product/12.2.0.1/dbhome_1:Y
/etc/init.d/dbora
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
#!/bin/bash
ORA_HOME=/u01/app/oracle/product/12.2.0.1/dbhome_1
ORA_OWNER=oracle
case "$1" in
'start')
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;
'stop')
su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
;;
esac
Все привилегии в норме
1.
2.
3.
4.
5.
6.
7.
chgrp dba /etc/init.d/dbora
chmod 755 /etc/init.d/dbora
chkconfig --add dbora
chkconfig --list | grep dbora
Фишка в том что если база включена , норм работает
/etc/init.d/dbora stop
при старте досада
/etc/init.d/dbora start
1.
2.
3.
4.
5.
6.
7.
8.
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 13-DEC-2019 09:44:28
Copyright (c) 1991, 2016, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/product/12.2.0.1/dbhome_1/bin/dbstart ORACLE_HOME
Processing Database instance "dbprod": log file /u01/app/oracle/product/12.2.0.1/dbhome_1/startup.log
Вот что показывает startup.log
1.
2.
3.
4.
5.
/u01/app/oracle/product/12.2.0.1/dbhome_1/bin/dbstart: Starting up database "dbprod"
Fri Dec 13 09:36:55 EST 2019
root: No init file found for Database instance "dbprod".
root: Error: Database instance "dbprod" NOT started.
база на ASM
В чем может быть проблема ?
Спасибо
Да забыл база на ASM
