Oracle не стартует автоматически.
Форум — Admin
Здравствуйте! Обратились ко мне за помощью . Перестал автоматически грузиться Oracle . Но вручную инстанс базы запускается из sqlplus от sysdba успешно, но когда я запускаю от от пользователя 'oracle' , то в startup.log получаю
SQL*Plus: Release 10.2.0.1.0 - Production on --. ?- 21 06:11:06 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connect / as sysdba>ORA-01031: insufficient privileges connect / as sysdba> /opt/oracle/product/10.2.0/bin/dbstart: Database instance «FBD» warm started.
На клиенте ошибки :
ORA-01034 ORA-27101 Linux error 2: No such file or directory
Переменные окружения все присутствуют. Пути правильные Подскажите, плз, где что контрольнуть?
.bash_profile:
#!/bin/bash
# User specific environment and startup programs
TZ=MET; export TZ
PATH=$PATH:$HOME/bin
ENV=$HOME/.bashrc
BASH_ENV=$HOME/.bashrc
USERNAME=`whoami`
POSTFIX=/usr/local/postfix
# LANG=en_US.UTF-8
LANG=ru_RU.UTF8
COLUMNS=130
LINES=45
export USERNAME ENV COLUMNS LINES TERM PS1 PS2 PATH POSTFIX BASH_ENV LANG
# Setup the correct Terminal-Type
if [ `tty` != "/dev/tty1" ]
then
TERM=linux
#TERM=vt100
else
# The only wellknown Terminal-Type is "vt100"
TERM=linux
#TERM=vt100
fi
# Setup Terminal
stty erase "^H" kill "^U" intr "^C" eof "^D"
stty cs8 -parenb -istrip hupcl ixon ixoff tabs
# Set up shell environment
# set -u # error if undefined variable.
trap "echo -e 'logout $LOGNAME'" 0 # what to do on exit.
# Set up shell variables:
# MAIL=/var/spool/mail/$LOGNAME
# don't export, so only login shell checks.
# Setup ORACLE environment
ORACLE_HOME=/opt/oracle/product/10.2.0; export ORACLE_HOME
ORACLE_SID=FBD; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
ORACLE_OWNER=oracle; export ORACLE_OWNER
# TNS_ADMIN=/home/oracle/config/10.2.0 export TNS_ADMIN
NLS_LANG=UKRAINIAN_UKRAINE.CL8MSWIN1251; export NLS_LANG
ORA_NLS10=${ORACLE_HOME}/nls/data; export ORA_NLS10
CLASSPATH=${CLASSPATH}:${ORACLE_HOME}/jdbc/lib/classes12.zip
LD_LIBRARY_PATH=${ORACLE_HOME}/lib; export LD_LIBRARY_PATH
DISABLE_HUGETLBFS=1; export DISABLE_HUGETLBFS
# Set up the search paths:
PATH=${PATH}:${ORACLE_HOME}/bin:${POSTFIX}/bin:${POSTFIX}/sbin:${POSTFIX}/sendmail
PATH=${PATH}:/usr/local/sbin:/usr/bin/X11:/usr/X11R6/bin
export PATH
# Set date in European-Form
echo -e " "
date '+Date: %d.%m.%y Time: %H:%M:%S'
echo -e " "
uname -a
# clean shell-history file .sh_history
: > $HOME/.bash_history
# Show last login
cat .lastlogin
term=`tty`
echo -e "Last login at `date '+%H:%M, %h %d'` on $term" >.lastlogin
echo -e " "
if [ $LOGNAME = "root" ]
then
echo -e "WARNING: YOU ARE SUPERUSER !!!"
echo -e " "
fi
# Set Shell Limits for user oracle
if [ ${USER} = "oracle" ]; then
if [ ${SHELL} = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
umask 022
SERVAK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.30.231)(PORT = 1521))
(CONNECT_DATA =
(SID = FBD)
(SRVR = DEDICATED)
)
)
SERVAK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVAK)(PORT = 1521))
)
(CONNECT_DATA =
(SID = FBD)
)
)