Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
Топик располагается на нескольких страницах: Ctrl  назад   1 [2] 3   вперед  Ctrl      все
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
123йй
15823560
SoRa
Не работает, листенер не запускается.
..
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
 

смешались люди - кони ?


132йй, Что ты хочешь ? Да этот лог с виртуальной машине.
Или ты хочешь чтобы при каждом твоем рекомендации я ребутнул серваки?

+

virtual-oracledb:/ # cat /etc/hosts
#
# hosts This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# "named" name server.
# Syntax:
#
# IP-Address Full-Qualified-Hostname Short-Hostname
#

127.0.0.1 localhost
192.168.0.57 virtual-oracledb virtual-oracledb
# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback

fe00::0 ipv6-localnet

ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts

3 апр 14, 14:16    [15827215]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa
Что ты хочешь ?

я ничего не хочу. только в каждом твоем посте идет информация с разных хостов.
т.ч если хочешь что-нибудь сделать, то сделай это вначале на одном хосте и логи выкладывай, что сделал- что получилось
3 апр 14, 14:57    [15827489]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
123йй,
Ок, я тебя понял.
Подскажи пожалуйста, почему при старте ОС, бд запускается а листенер нет ?
3 апр 14, 15:09    [15827558]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,
Всё очень просто
давай попробуем поднять слушатель на виртуальной машине
итак
1)
$ping virtual-oracledb
64 bytes from virtual-oracledb.mydomen.local (192.168.0.57): icmp_seq=1 ttl=64 time=0.028 ms
64 bytes from virtual-oracledb.mydomen.local (192.168.0.57): icmp_seq=1 ttl=64 time=0.028 ms
64 bytes from virtual-oracledb.mydomen.local (192.168.0.57): icmp_seq=1 ttl=64 time=0.028 ms

адрес статический и не меняется после перезагрузки? (dhcp off) так?
3 апр 14, 15:49    [15827878]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
dba123
адрес статический и не меняется после перезагрузки? (dhcp off) так?

Да
virtual-oracledb:/ # ping virtual-oracledb
PING virtual-oracledb (192.168.0.57) 56(84) bytes of data.
64 bytes from virtual-oracledb (192.168.0.57): icmp_seq=1 ttl=64 time=0.032 ms
64 bytes from virtual-oracledb (192.168.0.57): icmp_seq=2 ttl=64 time=0.047 ms
64 bytes from virtual-oracledb (192.168.0.57): icmp_seq=3 ttl=64 time=0.116 ms
64 bytes from virtual-oracledb (192.168.0.57): icmp_seq=4 ttl=64 time=0.047 ms
^C
--- virtual-oracledb ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 2999ms
rtt min/avg/max/mdev = 0.032/0.060/0.116/0.033 ms
3 апр 14, 16:05    [15828001]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,

2) установлен Rdbms Oracle в 1 хоум от пользователя oracle
root# su - oracle

oracle$ id
...

oracle$ env |grep -E "PATH|ora"
..

oracle$exit

root# su oracle
oracle$ env |grep -E "PATH|ora"
...

или есть еще GI ?
3 апр 14, 16:21    [15828130]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa
123йй,
Ок, я тебя понял.
Подскажи пожалуйста, почему при старте ОС, бд запускается а листенер нет ?

stff вечная тема
3 апр 14, 16:37    [15828253]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
dba123
SoRa,
2) установлен Rdbms Oracle в 1 хоум от пользователя oracle
или есть еще GI ?


+

virtual-oracledb:/ # su - oracle
Directory: /home/oracle
Thu Apr  3 17:38:13 TJT 2014


oracle@virtual-oracledb:~> id
uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),1001(dba)
oracle@virtual-oracledb:~> env |grep -E "PATH|ora"
MANPATH=/usr/local/man:/usr/share/man
HOSTNAME=virtual-oracledb
HOST=virtual-oracledb
USER=oracle
LD_LIBRARY_PATH=/app/oracle/product/11.2.0/dbhome_1/lib:/app/oracle/product/11.2.0/dbhome_1/ctx/lib
ORA_NLS10=/app/oracle/product/11.2.0/dbhome_1/nls/data
XNLSPATH=/usr/share/X11/nls
ORACLE_BASE=/app/oracle
TNS_ADMIN=/app/oracle/product/11.2.0/dbhome_1/network/admin
MAIL=/var/spool/mail/oracle
PATH=/home/oracle/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/app/oracle/product/11.2.0/dbhome_1/bin
INPUTRC=/home/oracle/.inputrc
PWD=/home/oracle
AGENT_HOME=/app/oracle/product/11.2.0/agent
HOME=/home/oracle
LOGNAME=oracle
CLASSPATH=/app/oracle/product/11.2.0/dbhome_1/JRE:/app/oracle/product/11.2.0/dbhome_1/jlib:/app/oracle/product/11.2.0/dbhome_1/rdbms/jlib:/app/oracle/product/11.2.0/dbhome_1/network/jlib
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1


oracle@virtual-oracledb:~> exit
logout


virtual-oracledb:/ # su oracle
oracle@virtual-oracledb:/> env |grep -E "PATH|ora"
ORBIT_SOCKETDIR=/tmp/orbit-oracle
MANPATH=/usr/local/man:/usr/share/man
HOSTNAME=virtual-oracledb
HOST=virtual-oracledb
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
USER=oracle
ORA_NLS10=/app/oracle/product/11.2.0/dbhome_1/nls/data
XNLSPATH=/usr/share/X11/nls
ORACLE_BASE=/app/oracle
SESSION_MANAGER=local/virtual-oracledb:@/tmp/.ICE-unix/3538,unix/virtual-oracledb:/tmp/.ICE-unix/3538
USERNAME=oracle
MAIL=/var/spool/mail/oracle
TNS_ADMIN=/app/oracle/product/11.2.0/dbhome_1/network/admin
PATH=/home/oracle/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/app/oracle/product/11.2.0/dbhome_1/bin
INPUTRC=/home/oracle/.inputrc
AGENT_HOME=/app/oracle/product/11.2.0/agent
ICEAUTHORITY=/home/oracle/.ICEauthority
HOME=/home/oracle
ALSA_CONFIG_PATH=/etc/alsa-pulse.conf
LOGNAME=oracle
CLASSPATH=/app/oracle/product/11.2.0/dbhome_1/JRE:/app/oracle/product/11.2.0/dbhome_1/jlib:/app/oracle/product/11.2.0/dbhome_1/rdbms/jlib:/app/oracle/product/11.2.0/dbhome_1/network/jlib
INFOPATH=/usr/local/info:/usr/share/info:/usr/info
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1
oracle@virtual-oracledb:/> 

3 апр 14, 16:44    [15828306]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,

/home/oracle/bin - что там установлено?

root# su - oracle
oracale$ lsnrctl stop
oracale$ lsnrctl start
oracale$ lsnrctl status
4 апр 14, 08:38    [15831050]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa,

ORACLE_HOME_LISTNER=$ORACLE_HOME
установлено при запуске?
4 апр 14, 09:20    [15831145]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa,

ну и дока
4 апр 14, 09:27    [15831172]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
dba123
SoRa,
/home/oracle/bin - что там установлено?

Ничего.
oracle@virtual-oracledb:~/Desktop> cd /home/oracle/bin
oracle@virtual-oracledb:~/bin> ls -la
total 8
drwxr-xr-x  2 oracle users 4096 Aug 27  2013 .
drwxr-xr-x 26 oracle users 4096 Apr  4 10:24 ..

dba123
root# su - oracle
oracale$ lsnrctl stop
oracale$ lsnrctl start
oracale$ lsnrctl status

+

virtual-oracledb:/ # su - oracle
Directory: /home/oracle
Fri Apr 4 11:20:02 TJT 2014
oracle@virtual-oracledb:~> lsnrctl stop;

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 11:20:22

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@virtual-oracledb:~> lsnrctl start;

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 11:20:27

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /app/oracle/diag/tnslsnr/virtual-oracledb/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.57)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-APR-2014 11:20:28
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/virtual-oracledb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.57)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "work" has 1 instance(s).
Instance "work", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
oracle@virtual-oracledb:~> lsnrctl status;

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 11:20:49

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-APR-2014 11:20:28
Uptime 0 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/virtual-oracledb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.57)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "work" has 2 instance(s).
Instance "work", status UNKNOWN, has 1 handler(s) for this service...
Instance "work", status READY, has 1 handler(s) for this service...
Service "workXDB" has 1 instance(s).
Instance "work", status READY, has 1 handler(s) for this service...
The command completed successfully
4 апр 14, 10:26    [15831508]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
123йй
SoRa,
ORACLE_HOME_LISTNER=$ORACLE_HOME
установлено при запуске?


Нет, по умолчанию было ORACLE_HOME_LISTNER=$1 поменял на ORACLE_HOME_LISTNER=/app/oracle/product/11.2.0/dbhome_1.

Щас проверю вариант с ORACLE_HOME_LISTNER=$ORACLE_HOME.
4 апр 14, 10:34    [15831553]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,

очень хорошо
тогда и такая команда должна пройти:
root# su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl start>/dev/null" 
4 апр 14, 10:48    [15831669]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
dba123
SoRa,
очень хорошо
тогда и такая команда должна пройти:
root# su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl start>/dev/null" 


Результат:
+

oracle@virtual-oracledb:~/Desktop> lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 13:37:51

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@virtual-oracledb:~/Desktop> cd /
oracle@virtual-oracledb:/> su root
Password:
virtual-oracledb:/ # su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl start>/dev/null"
virtual-oracledb:/ # lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 13:41:53

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-APR-2014 13:41:33
Uptime 0 days 0 hr. 0 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/virtual-oracledb/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.57)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "work" has 2 instance(s).
Instance "work", status UNKNOWN, has 1 handler(s) for this service...
Instance "work", status READY, has 1 handler(s) for this service...
Service "workXDB" has 1 instance(s).
Instance "work", status READY, has 1 handler(s) for this service...
The command completed successfully
4 апр 14, 12:44    [15832470]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,

теперь если добавить эти команды(su - oracle ... lsnrctl start|stop) прямо в dbora перед
su oracle ... dbstart su oracle ... dbshut,

то должен стартануть/остановиться слушатель,
а переменную оракле_хоум_листнер в dbstart/dbshut обнулить

это самый простой из вариантов, когда 1 хоум, 1 слушатель...
хотя установить при инсталляции СуСе orarun и настроить сервис oracle, на мой взгляд, проще
4 апр 14, 13:08    [15832641]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
[quot SoRa]
123йй
Щас проверю вариант с ORACLE_HOME_LISTNER=$ORACLE_HOME.


Листенер не стартовал!
4 апр 14, 13:14    [15832679]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa,

показывай код dbstart/dbstop/dbora
4 апр 14, 14:09    [15833029]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
dba123
SoRa,
это самый простой из вариантов, когда 1 хоум, 1 слушатель...
хотя установить при инсталляции СуСе orarun и настроить сервис oracle, на мой взгляд, проще

Добавил строчку в файле dbora перед dbstart. К сожалению листенер не запустился.
su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl start>>/app/listener.log

dba123, что думаешь про это:
irbis_al
Возникает ощущение,что он(скрипт запуска) раньше чем "поднятие сетевых интерфейсов"


+

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-APR-2014 15:05:55

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /app/oracle/diag/tnslsnr/virtual-oracledb/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.57)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 99: Cannot assign requested address

Listener failed to start. See the error message(s) above...
4 апр 14, 14:14    [15833060]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
123йй
SoRa,
показывай код dbstart/dbstop/dbora


dbora:
+

virtual-oracledb:/app # cat /etc/init.d/dbora 
e@orcdb1:/> cat /etc/init.d/dbora
#!/bin/sh -x
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.

ORA_HOME=/app/oracle/product/11.2.0/dbhome_1
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then
    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
	su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl start>>/app/listener.log"
        su $ORA_OWNER -c $ORA_HOME/bin/dbstart
        touch /var/lock/subsys/dbora
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
	su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export PATH=/app/oracle/product/11.2.0/dbhome_1/bin:/usr/bin;lsnrctl stop>>/app/listener.log"
        su $ORA_OWNER -c $ORA_HOME/bin/dbshut
        rm -f /var/lock/subsys/dbora
        ;;
esac


dbstart:
+

oracle@virtual-oracledb:/app/oracle/product/11.2.0/dbhome_1/bin> cat dbstart 
#!/bin/sh
#
# $Id: dbstart.sh 22-may-2008.05:05:45 arogers Exp $ 
# Copyright (c) 1991, 2008, Oracle. All rights reserved.  
#

###################################
# 
# usage: dbstart $ORACLE_HOME
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
# This script will start all databases listed in the oratab file
# whose third field is a "Y".  If the third field is set to "Y" and
# there is no ORACLE_SID for an entry (the first field is a *),
# then this script will ignore that entry.
#
# This script requires that ASM ORACLE_SID's start with a +, and 
# that non-ASM instance ORACLE_SID's do not start with a +.
#
# If ASM instances are to be started with this script, it cannot
# be used inside an rc*.d directory, and should be invoked from
# rc.local only. Otherwise, the CSS service may not be available
# yet, and this script will block init from completing the boot
# cycle.
#
# If you want dbstart to auto-start a single-instance database that uses
# an ASM server that is auto-started by CRS (this is the default behavior
# for an ASM cluster), you must change the database's ORATAB entry to use
# a third field of "W" and the ASM's ORATAB entry to use a third field of "N".
# These values specify that dbstart auto-starts the database only after
# the ASM instance is up and running.
#
# Note:
# Use ORACLE_TRACE=T for tracing this script.
#
# The progress log for each instance bringup plus Error and Warning message[s]
# are logged in file $ORACLE_HOME/startup.log. The error messages related to 
# instance bringup are also logged to syslog (system log module).
# The Listener log is located at $ORACLE_HOME_LISTNER/listener.log
# 
# On all UNIX platforms except SOLARIS
# ORATAB=/etc/oratab
#
# To configure, update ORATAB with Instances that need to be started up
#    Entries are of the form:
#    $ORACLE_SID:$ORACLE_HOME:<N|Y|W>:
#    An example entry:
#    main:/usr/lib/oracle/emagent_10g:Y
#
# Overall algorithm:
# 1) Bring up all ASM instances with 'Y' entry in status field in oratab entry
# 2) Bring up all Database instances with 'Y' entry in status field in
#    oratab entry
# 3) If there are Database instances with 'W' entry in status field
#    then
#      iterate over all ASM instances (irrespective of 'Y' or 'N') AND
#      wait for all of them to be started
#    fi
# 4) Bring up all Database instances with 'W' entry in status field in
#    oratab entry
#
#####################################

LOGMSG="logger -puser.alert -s "

trap 'exit' 1 2 3

# for script tracing
case $ORACLE_TRACE in
  T) set -x ;;
esac
    
# Set path if path not set (if called from /etc/rc)
SAVE_PATH=/bin:/usr/bin:/etc:${PATH} ; export PATH
SAVE_LLP=$LD_LIBRARY_PATH

# First argument is used to bring up Oracle Net Listener
#ORACLE_HOME_LISTNER=/app/oracle/product/11.2.0/dbhome_1
if [ ! $ORACLE_HOME_LISTNER ] ; then
  echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener"
  echo "Usage: $0 ORACLE_HOME"
else
  LOG=$ORACLE_HOME_LISTNER/listener.log

  # Set the ORACLE_HOME for the Oracle Net Listener, it gets reset to
  # a different ORACLE_HOME for each entry in the oratab.
  export ORACLE_HOME=$ORACLE_HOME_LISTNER

  # Start Oracle Net Listener
  if [ -x $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
    echo "$0: Starting Oracle Net Listener" >> $LOG 2>&1
    $ORACLE_HOME_LISTNER/bin/lsnrctl start >> $LOG 2>&1 &
    VER10LIST=`$ORACLE_HOME_LISTNER/bin/lsnrctl version | grep "LSNRCTL for " | cut -d' ' -f5 | cut -d'.' -f1`
    export VER10LIST
  else
    echo "Failed to auto-start Oracle Net Listener using $ORACLE_HOME_LISTNER/bin/tnslsnr"
  fi
fi

# Set this in accordance with the platform
ORATAB=/etc/oratab
if [ ! $ORATAB ] ; then
  echo "$ORATAB not found"
  exit 1;
fi

# Checks Version Mismatch between Listener and Database Instance.
# A version 10 listener is required for an Oracle Database 10g database.
# Previous versions of the listener are not supported for use with an Oracle
# Database 10g database. However, it is possible to use a version 10 listener
# with previous versions of the Oracle database.
checkversionmismatch() {
  if [ $VER10LIST ] ; then
    VER10INST=`sqlplus -V | grep "Release " | cut -d' ' -f3 | cut -d'.' -f1`
    if [ $VER10LIST -lt $VER10INST ] ; then
      $LOGMSG "Listener version $VER10LIST NOT supported with Database version $VER10INST"
      $LOGMSG "Restart Oracle Net Listener using an alternate ORACLE_HOME_LISTNER:"
      $LOGMSG "lsnrctl start"
    fi
  fi
}

# Starts a Database Instance
startinst() {
  # Called programs use same database ID
  export ORACLE_SID

  # Put $ORACLE_HOME/bin into PATH and export.
  PATH=$ORACLE_HOME/bin:${SAVE_PATH} ; export PATH
  # add for bug # 652997
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${SAVE_LLP} ; export LD_LIBRARY_PATH
  PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
  SPFILE=${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora
  SPFILE1=${ORACLE_HOME}/dbs/spfile.ora

  echo ""
  echo "$0: Starting up database \"$ORACLE_SID\""
  date
  echo ""

  checkversionmismatch

  # See if it is a V6 or V7 database
  VERSION=undef
  if [ -f $ORACLE_HOME/bin/sqldba ] ; then
    SQLDBA=sqldba
    VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
      /SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
      print V[1]}'`
    case $VERSION in
      "6") ;;
      *) VERSION="internal" ;;
    esac
  else
    if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
      SQLDBA=svrmgrl
      VERSION="internal"
    else
      SQLDBA="sqlplus /nolog"
    fi
  fi

  STATUS=1
  if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf ] ; then
    STATUS="-1"
  fi
  if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora ] ; then
    STATUS="-1"
  fi
  pmon=`ps -ef | grep -w "ora_pmon_$ORACLE_SID"  | grep -v grep`
  if [ "$pmon" != "" ] ; then
    STATUS="-1"
    $LOGMSG "Warning: ${INST} \"${ORACLE_SID}\" already started."
  fi

  if [ $STATUS -eq -1 ] ; then
    $LOGMSG "Warning: ${INST} \"${ORACLE_SID}\" possibly left running when system went down (system crash?)."
    $LOGMSG "Action: Notify Database Administrator."
    case $VERSION in
      "6")  sqldba "command=shutdown abort" ;;
      "internal")  $SQLDBA $args <<EOF
connect internal
shutdown abort
EOF
        ;;
      *)  $SQLDBA $args <<EOF
connect / as sysdba
shutdown abort
quit
EOF
        ;;
    esac

    if [ $? -eq 0 ] ; then
      STATUS=1
    else
      $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started."
    fi
  fi

  if [ $STATUS -eq 1 ] ; then
    if [ -e $SPFILE -o -e $SPFILE1 -o -e $PFILE ] ; then
      case $VERSION in
        "6")  sqldba command=startup ;;
        "internal")  $SQLDBA <<EOF 
connect internal
startup
EOF
          ;;
        *)  $SQLDBA <<EOF 
connect / as sysdba
startup
quit
EOF
          ;;
      esac

      if [ $? -eq 0 ] ; then
        echo "" 
        echo "$0: ${INST} \"${ORACLE_SID}\" warm started." 
      else
        $LOGMSG "" 
        $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started." 
      fi
    else
      $LOGMSG "" 
      $LOGMSG "No init file found for ${INST} \"${ORACLE_SID}\"." 
      $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started." 
    fi
  fi
}

# Starts an ASM Instance
startasminst() {
  # Called programs use same database ID
  export ORACLE_SID
  ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
  # Called scripts use same home directory
  export ORACLE_HOME

  # For ASM instances, we have a dependency on the CSS service.
  # Wait here for it to become available before instance startup.

  # Is the 10g install intact? Are all necessary binaries present?
  if [ ! -x $ORACLE_HOME/bin/crsctl ]; then
    $LOGMSG "$ORACLE_HOME/bin/crsctl not found when attempting to start"
    $LOGMSG "  ASM instance $ORACLE_SID."

  else 
    COUNT=0
    $ORACLE_HOME/bin/crsctl check css
    RC=$?
    while [ "$RC" != "0" ];
      do
      COUNT=`expr $COUNT + 1`
      if [ $COUNT = 15 ] ; then
        # 15 tries with 20 sec interval => 5 minutes timeout
        $LOGMSG "Timed out waiting to start ASM instance $ORACLE_SID"         
        $LOGMSG "  CSS service is NOT available."
        exit $COUNT
      fi
      $LOGMSG "Waiting for Oracle CSS service to be available before starting "
      $LOGMSG " ASM instance $ORACLE_SID. Wait $COUNT."
      sleep 20
      $ORACLE_HOME/bin/crsctl check css
      RC=$?
    done
  fi
  startinst
}

# Start of dbstartup script
#
# Loop for every entry in oratab file and and try to start
# that ORACLE.
#
# ASM instances need to be started before 'Database instances'
# ASM instance is identified with '+' prefix in ORACLE_SID
# Following loop brings up ASM instance[s]

cat $ORATAB | while read LINE
do
case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
    # same as NULL SID - ignore this entry
    ORACLE_SID=""
    continue
  fi
  # Proceed only if last field is 'Y'.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
    # If ASM instances
    if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
      INST="ASM instance"
      ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
      # Called scripts use same home directory
      export ORACLE_HOME
      # file for logging script's output
      LOG=$ORACLE_HOME/startup.log
      touch $LOG
      chmod a+r $LOG
      echo "Processing $INST \"$ORACLE_SID\": log file $ORACLE_HOME/startup.log"
      startasminst >> $LOG 2>&1
    fi
  fi
  ;;
esac
done

# exit if there was any trouble bringing up ASM instance[s]
if [ "$?" != "0" ] ; then
  exit 2
fi

#
# Following loop brings up 'Database instances'
#
cat $ORATAB | while read LINE
do
case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
    # same as NULL SID - ignore this entry
    ORACLE_SID=""
    continue
  fi
  # Proceed only if last field is 'Y'.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
    # If non-ASM instances
    if [ `echo $ORACLE_SID | cut -b 1` != '+' ]; then
      INST="Database instance"
      ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
      # Called scripts use same home directory
      export ORACLE_HOME
      # file for logging script's output
      LOG=$ORACLE_HOME/startup.log
      touch $LOG
      chmod a+r $LOG
      echo "Processing $INST \"$ORACLE_SID\": log file $ORACLE_HOME/startup.log"
      startinst >> $LOG 2>&1
    fi
  fi
  ;;
esac
done

#
# Following loop brings up 'Database instances' that have wait state 'W'
#
cat $ORATAB | while read LINE
do
case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
    # same as NULL SID - ignore this entry
    ORACLE_SID=""
    continue
  fi
  # Proceed only if last field is 'W'.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "W" ] ; then
    W_ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
    # DB instances with 'W' (wait state) have a dependency on ASM instances via CRS.
    # Wait here for 'all' ASM instances to become available.
    cat $ORATAB | while read LINE
    do
    case $LINE in
      \#*)                ;;        #comment-line in oratab
      *)
      ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
      if [ "$ORACLE_SID" = '*' ] ; then
        # same as NULL SID - ignore this entry
        ORACLE_SID=""
        continue
      fi
      if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
        INST="ASM instance"
        ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
        if [ -x $ORACLE_HOME/bin/srvctl ] ; then
          COUNT=0
          NODE=`olsnodes -l`
          RNODE=`srvctl status asm -n $NODE | grep "$ORACLE_SID is running"`
          RC=$?
          while [ "$RC" != "0" ]; # wait until this comes up!
          do
            COUNT=$((COUNT+1))
            if [ $COUNT = 5 ] ; then
              # 5 tries with 60 sec interval => 5 minutes timeout
              $LOGMSG "Error: Timed out waiting on CRS to start ASM instance $ORACLE_SID"         
              exit $COUNT
            fi
            $LOGMSG "Waiting for Oracle CRS service to start ASM instance $ORACLE_SID"
            $LOGMSG "Wait $COUNT."
            sleep 60
            RNODE=`srvctl status asm -n $NODE | grep "$ORACLE_SID is running"`
            RC=$?
          done
        else
          $LOGMSG "Error: \"${W_ORACLE_SID}\" has dependency on ASM instance \"${ORACLE_SID}\""
          $LOGMSG "Error: Need $ORACLE_HOME/bin/srvctl to check this dependency"
        fi
      fi     # asm instance
      ;;
    esac
    done # innner while
  fi
  ;;
esac
done # outer while

# by now all the ASM instances have come up and we can proceed to bring up
# DB instance with 'W' wait status

cat $ORATAB | while read LINE
do
case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
    # same as NULL SID - ignore this entry
    ORACLE_SID=""
    continue
  fi
  # Proceed only if last field is 'W'.
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "W" ] ; then
    INST="Database instance"
    if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
      $LOGMSG "Error: ${INST} \"${ORACLE_SID}\" NOT started"
      $LOGMSG "Error: incorrect usage: 'W' not allowed for ASM instances"
      continue
    fi
    ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
    # Called scripts use same home directory
    export ORACLE_HOME
    # file for logging script's output
    LOG=$ORACLE_HOME/startup.log
    touch $LOG
    chmod a+r $LOG
    echo "Processing $INST \"$ORACLE_SID\": log file $ORACLE_HOME/startup.log"
    startinst >> $LOG 2>&1
  fi
  ;;
esac
done


dbshut:
+

oracle@virtual-oracledb:/app/oracle/product/11.2.0/dbhome_1/bin> cat dbshut 
#!/bin/sh
#
# $Id: dbshut.sh 22-may-2008.05:19:31 arogers Exp $
# Copyright (c) 1991, 2008, Oracle. All rights reserved.  
#

###################################
# 
# usage: dbshut $ORACLE_HOME
#
# This script is used to shutdown ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
# This script will shutdown all databases listed in the oratab file
# whose third field is a "Y" or "W".  If the third field is set to "Y" and
# there is no ORACLE_SID for an entry (the first field is a *),
# then this script will ignore that entry.
#
# This script requires that ASM ORACLE_SID's start with a +, and 
# that non-ASM instance ORACLE_SID's do not start with a +.
#
# Note:
# Use ORACLE_TRACE=T for tracing this script.
# Oracle Net Listener is also shutdown using this script.
#
# The progress log for each instance shutdown is logged in file 
# $ORACLE_HOME/shutdown.log.
#
# On all UNIX platforms except SOLARIS
# ORATAB=/etc/oratab
#
# To configure, update ORATAB with Instances that need to be shutdown
#    Entries are of the form:
#    $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#    An example entry:
#    main:/usr/lib/oracle/emagent_10g:Y
#
#####################################

trap 'exit' 1 2 3
case $ORACLE_TRACE in
  T) set -x ;;
esac

# Set path if path not set (if called from /etc/rc)
SAVE_PATH=/bin:/usr/bin:/etc:${PATH} ; export PATH
SAVE_LLP=$LD_LIBRARY_PATH

# The  this to bring down Oracle Net Listener
#ORACLE_HOME_LISTNER=/app/oracle/product/11.2.0/dbhome_1
if [ ! $ORACLE_HOME_LISTNER ] ; then
  echo "ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener"
  echo "Usage: $0 ORACLE_HOME"
else
  LOG=$ORACLE_HOME_LISTNER/listener.log

  # Set the ORACLE_HOME for the Oracle Net Listener, it gets reset to
  # a different ORACLE_HOME for each entry in the oratab.
  export ORACLE_HOME=$ORACLE_HOME_LISTNER

  # Stop Oracle Net Listener
  if [ -f $ORACLE_HOME_LISTNER/bin/tnslsnr ] ; then
    echo "$0: Stoping Oracle Net Listener" >> $LOG 2>&1
    $ORACLE_HOME_LISTNER/bin/lsnrctl stop >> $LOG 2>&1 &
  else
    echo "Failed to auto-stop Oracle Net Listener using $ORACLE_HOME_LISTNER/bin/tnslsnr"
  fi
fi

# Set this in accordance with the platform
ORATAB=/etc/oratab
if [ ! $ORATAB ] ; then
  echo "$ORATAB not found"
  exit 1;
fi

# Stops an instance
stopinst() {
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
    ORACLE_SID=""
  fi
# Called programs use same database ID
  export ORACLE_SID
  ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
# Called scripts use same home directory
  export ORACLE_HOME
# Put $ORACLE_HOME/bin into PATH and export.
  PATH=$ORACLE_HOME/bin:${SAVE_PATH} ; export PATH
# add for bug 652997
  LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${SAVE_LLP} ; export LD_LIBRARY_PATH
  PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

# See if it is a V6 or V7 database
  VERSION=undef
  if [ -f $ORACLE_HOME/bin/sqldba ] ; then
    SQLDBA=sqldba
    VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
      /SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
      print V[1]}'`
    case $VERSION in
      "6") ;;
      *) VERSION="internal" ;;
    esac
  else
    if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
      SQLDBA=svrmgrl
      VERSION="internal"
    else
      SQLDBA="sqlplus /nolog"
    fi
  fi

  case $VERSION in
    "6")  sqldba command=shutdown ;;
    "internal")  $SQLDBA <<EOF
connect internal
shutdown immediate
EOF
     ;;
     *)  $SQLDBA <<EOF
connect / as sysdba
shutdown immediate
quit
EOF
     ;;
  esac

  if test $? -eq 0 ; then
    echo "${INST} \"${ORACLE_SID}\" shut down."
  else
    echo "${INST} \"${ORACLE_SID}\" not shut down."
  fi
}

#
# Loop for every entry in oratab file and and try to shut down
# that ORACLE
#
# Following loop shuts down 'Database Instance[s]' with 'Y' entry

cat $ORATAB | while read LINE
do
  case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
      # NULL SID - ignore
      ORACLE_SID=""
      continue
  fi
  # Proceed only if last field is 'Y' or 'W'
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
    if [ `echo $ORACLE_SID | cut -b 1` != '+' ]; then
      INST="Database instance"
      ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
      LOG=$ORACLE_HOME/shutdown.log
      echo "Processing $INST \"$ORACLE_SID\": log file $LOG"
      stopinst >> $LOG 2>&1
    fi
  fi
  ;;
  esac
done

#
# Following loop shuts down 'Database Instance[s]' with 'W' entry
#
cat $ORATAB | while read LINE
do
  case $LINE in
  \#*)                ;;        #comment-line in oratab
  *)
  ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
  if [ "$ORACLE_SID" = '*' ] ; then
      # NULL SID - ignore
      ORACLE_SID=""
      continue
  fi
  # Proceed only if last field is 'Y' or 'W'
  if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "W" ] ; then
    if [ `echo $ORACLE_SID | cut -b 1` != '+' ]; then
      INST="Database instance"
      ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
      LOG=$ORACLE_HOME/shutdown.log
      echo "Processing $INST \"$ORACLE_SID\": log file $LOG"
      stopinst >> $LOG 2>&1
    fi
  fi
  ;;
  esac
done

#
# Following loop shuts down 'ASM Instance[s]'
#

cat $ORATAB | while read LINE
do
  case $LINE in
    \#*)                ;;        #comment-line in oratab
    *)
    ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
    if [ "$ORACLE_SID" = '*' ] ; then
      # NULL SID - ignore
      ORACLE_SID=""
      continue
    fi
    # Proceed only if last field is 'Y'.
    # Entries whose last field is not Y or N are not DB entry, ignore them.
    if [ "`echo $LINE | awk -F: '{print $NF}' -`" = "Y" ] ; then
      if [ `echo $ORACLE_SID | cut -b 1` = '+' ]; then
        INST="ASM instance"
        ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`
        LOG=$ORACLE_HOME/shutdown.log
        echo "Processing $INST \"$ORACLE_SID\": log file $LOG"
        stopinst >> $LOG 2>&1
      fi
    fi
  ;;
  esac
done

4 апр 14, 14:20    [15833114]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa
dba123, что думаешь про это:
ничего нового не думаю:
-удалить dbora
-создать новый сервис, как принято в СуСе, а не в красной шапочке
-см. выше ссылку на man
4 апр 14, 14:34    [15833225]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa,

IPv6 есть ?
4 апр 14, 14:35    [15833243]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
123йй
Member

Откуда:
Сообщений: 1635
SoRa,

так и не увидел установку
# First argument is used to bring up Oracle Net Listener
#ORACLE_HOME_LISTNER=/app/oracle/product/11.2.0/dbhome_1
4 апр 14, 14:38    [15833267]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
SoRa
Member

Откуда:
Сообщений: 83
123йй
SoRa,
IPv6 есть ?

Нет!
123йй
так и не увидел установку

По рекомендации dba123 было закомментировано:
dba123
SoRa,
...
а переменную оракле_хоум_листнер в dbstart/dbshut обнулить
...


123йй, вся надежда на тебя. dba123 рекомендует удалить dbora.
4 апр 14, 14:55    [15833381]     Ответить | Цитировать Сообщить модератору
 Re: Автоматический shutdown и startup базе  [new]
dba123
Member

Откуда:
Сообщений: 1054
SoRa,

оффтоп:
- советую снести и ОС, чтобы закрепить навыки
- есть способ выйти из положения: добавь строку запуска
su - oracle -c "export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_1; export ...
в конец скрипта /etc/init.d/networks :)
4 апр 14, 15:12    [15833508]     Ответить | Цитировать Сообщить модератору
Топик располагается на нескольких страницах: Ctrl  назад   1 [2] 3   вперед  Ctrl      все
Все форумы / Oracle Ответить