[Email protected] ~]$ Ps-ef|grep Smon
Oracle 14809 1 0 Sep25? 00:13:02 ORA_SMON_MAILP3
[Email protected] ~]$ export ORACLE_SID=MAILP3
[Email protected] ~]$ echo $ORACLE _sid
Mailp3
[Email protected] ~]$ Sqlplus/as sysdba;
Sql*plus:release 11.2.0.3.0 Production on Thu Oct 19 10:07:36 2017
Copyright (c) 1982, Oracle. All rights reserved.
Connected to an idle instance.
Sql>
sql>!env |grep ORACLE
Oracle_sid=mailp3
Oracle_base=/home/oracle
oracle_home=/home/oracle/product/11g
Sql>!cat/etc/oratab
#
# This file was used by ORACLE utilities. It's created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A Colon, ': ', is used as the field terminator. A New Line terminates
# The entry. Lines beginning with a pound sign, ' # ', is comments.
#
# Entries is of the form:
# $ORACLE _sid: $ORACLE _home:<n| Y>:
#
# The first and second fields is the system identifier and home
# Directory of the database respectively. The third filed indicates
# to the Dbstart utility and the database should, "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE _sid is not allowed.
#
#
Ps EWW 14809 See environment variables for startup process
[[Email protected] bin]# PS eww 14809
PID TTY STAT Time COMMAND
14809? Ss 13:02 ora_smon_mailp3 hostname=localhost.localdomain shell=/bin/bash term=vt100 HISTSIZE=1000 QTDIR=/usr/lib64/ qt-3.3 qtinc=/usr/lib64/qt-3.3/include user=oracle ls_colors=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01 ; 35:BD=40;33;01:CD=40;33;01:OR=40;31;01:MI=01;05;37;41:SU=37;41:SG=30;43:CA=30;41:TW=30;42:OW=34;42:ST=37;44: ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*. zip=01;31:*.z=01;31:*. Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31 :*. deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*. jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*. xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*. Mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi= 01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01; 35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01; 36:*.MKA=01;36:*.MP3=01;36:*.MPC=01;36:*.OGG=01;36:*.RA=01;36:*.WAV=01;36:*.AXA=01;36:*.OGA=01;36:*.SPX=01;36: *.XSPF=01;36:ORACLE_SID=MAILP3 oracle_base=/home/oracle/mail=/var/spool/mail/oracle PATH= PWD=/home/oracle LANG=en _us. UTF-8 ssh_askpass=/usr/libexec/openssh/gnome-ssh-askpass histcontrol=ignoredups shlvl=1 HOME=/home/oracle LOGNAME= Oracle Qtlib=/usr/lib64/qt-3.3/lib cvs_rsh=ssh lessopen=|/usr/bin/lesspipe.sh%s oracle_home=/home/oracle//product/ 11g G_broken_filenames=1 _=/home/oracle//product/11g/bin/sqlplus ora_net2_desc=9,12 ORACLE_SPAWNED_PROCESS=1 SKGP_ spawn_diag_pre_fork_ts=1506332218 skgp_spawn_diag_post_fork_t
Found
oracle_home=/home/oracle//product/11g
---->> Two/
Change the. Bash_profile environment variable ORACLE_HOME=/HOME/ORACLE//PRODUCT/11G to this problem resolution
An issue in which an Oracle process is not able to enter an instance