An issue in which an Oracle process is not able to enter an instance

Source: Internet
Author: User
Tags ssh sqlplus

[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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.