현재 위치

홈 ›› Forums ›› 공부 ›› 설치 및 활용 QnA

startup 이 안되는 경우..shutdown도 안되네요.

shean0의 이미지
글쓴이: shean0 / 작성시간: 월, 2003/10/20 - 10:13오전

지금 redhat 7.3에 오라클을 설치 했는데요..
문제가 생겨서요.

설치는 웹에서 문서를 보고 했구요...
설치시 create DB를 하지 말라고 해서. dbassist로 설치 했습니다.
과정은 아래와 같습니다. 

[oracle@mylinux Disk1]$ dbassist
??????? ???????.

?????? ??:

  ?? ???????:  mylinux
  ?????? ??? ???(SID):  mylinux
  SYS ?? ??:  change_on_install
  SYSTEM ?? ??:  manager


여기서  dbassist중간에..root.sh를 실행하였습니다.
 [위의 로그는 이후 결과  로그입니다]
그런데 ..아래와 같은 로그가 나와서.. ctrl+c로 죽이고 
ORACLE_HOME=/data/oracle/products/8.1.7
ORACLE_OWNER=oracle
ORACLE_SID= [없음 ]

===>vi root.sh 수정하였습니다.
#
# Default values set by Installer
#

[code]ORACLE_SID_INST=mylinux   <==삽입[/code]
ORACLE_HOME=/data/oracle/products/8.1.7
ORACLE_OWNER=oracle

#
# If this value is set by the installer are empty
# then use the corresponding environment variable
#

if [ x${ORACLE_SID_INST} = x ]
then
  ORACLE_SID=${ORACLE_SID}
else
  ORACLE_SID=${ORACLE_SID_INST}
fi

[oracle@mylinux Disk1]$ ls
doc  index.htm  install  patch  response  runInstaller  stage
[oracle@mylinux Disk1]$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
LRM-00109: could not open parameter file '?/dbs/init@.ora'
ORA-01078: failure in processing system parameters

initmylinux.ora가 존재하는데요..음... [이전에 root.sh]수정없이 설치시에는
존재하지 않았습니다 (벌써 6번째 까는 거네요)

이상없어 보이는데

[oracle@mylinux admin]$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> exit
Server Manager complete.

이미 존재한다고..그러나 ps로 보는데 없거든요.. 

[oracle@mylinux bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 20-OCT-2003 09:38:04

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started
[oracle@mylinux bin]$ ps -ef | grep lsnrctl
결과 없음

현재 oracle프로세스가 떠있으니..[물론 제가 띄운것은 아니구, 설치된후 자동으로 된듯합니다] startup이 안된것은 당연하다해두. shutdown까지??

cle@mylinux 8.1.7]$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production

SVRMGR> connect internal
Connected.
SVRMGR> create tablespace game datafile '/data/oracle/oradata/mylinux/test.dbf' size 300M default
storage ( initial 100K next 50k) ONLINE;
create tablespace game datafile '/data/oracle/oradata/mylinux/test.dbf' size 300M default storage
( initial 100K next 50k) ONLINE
*
ORA-01034: ORACLE not available
SVRMGR> show error
MGR-00111: illegal SHOW option
SVRMGR> shutdown
ORA-01012: not logged on
SVRMGR> shutdown abort
ORA-07217: sltln: environment variable cannot be evaluated.

아래는 참조 입니다. ===>아직 아무것두수정하지 않았습니다.

vi tnsnames.ora

MYLINUX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mylinux)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mylinux)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = mylinux)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = mylinux)
      (PRESENTATION = http://admin)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

vi listener.ora
# LISTENER.ORA Network Configuration File: /data/oracle/products/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = mylinux)(PORT = 1521))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /data/oracle/products/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = mylinux)
      (ORACLE_HOME = /data/oracle/products/8.1.7)
      (SID_NAME = mylinux)
    )
  )

vi /etc/hosts
xxx.xxx.xxx.xxx   mylinux loghost
127.0.0.1       localhost

<= IP : xxx

vi initmylinux.ora
.....
db_name = "mylinux"
instance_name = mylinux

service_names = mylinux

# db_files = 80                                                       # SMALL
# db_files = 400                                                      # MEDIUM
# db_files = 1500                                                     # LARGE

control_files = ("/data/oracle//oradata/mylinux/control01.ctl", "/data/oracle//oradata/mylinux/con
trol02.ctl
", "/data/oracle//oradata/mylinux/control03.ctl")

....

[oracle@mylinux dbs]$ pwd
/data/oracle/products/8.1.7/dbs
[orcle@mylinux dbs]$ ls
init.ora  initdw.ora  initmylinux.ora  lkMYLINUX  orapwmylinux
Forums: 
설치 및 활용 QnA
shean0의 이미지

글쓴이: shean0 / 작성시간: 월, 2003/10/20 - 11:03오전

왜.. startup, shutdown ,create space가 안된는것인지??

아래는 정상이라고 나온것 같은데요..

[oracle@mylinux dbs]$ lsnrctl status

LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 20-OCT-2003 10:54:53

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mylinux)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 8.1.7.0.0 - Production
Start Date                19-OCT-2003 20:07:10
Uptime                    0 days 14 hr. 47 min. 43 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /data/oracle/products/8.1.7/network/admin/listener.ora
Listener Log File         /data/oracle/products/8.1.7/network/log/listener.log
Services Summary...
  mylinux               has 3 service handler(s)
  PLSExtProc            has 1 service handler(s)
  mylinux               has 3 service handler(s)  <==이게 왜 3개씩 중복이지?/
The command completed successfully

언제나 즐프를 꿈꾸며~

shean0의 이미지

글쓴이: shean0 / 작성시간: 월, 2003/10/20 - 11:39오전

oracle 에서 echo $ORACLE_SID를 하니.. 값이 없네요..
왜 그런지.. 더 봐야 겠지만서두...먼저 올립니다.
profile정보들입니다. 

"profile_log.txt" 144 행, 3235 문자 
root : .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"

export USERNAME BASH_ENV PATH

# for oracle ==>
export ORACLE_BASE=/data/oracle/
export ORACLE_HOME=/data/oracle/products/8.1.7
export ORALCE_SID=mylinux

export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
# <== for oracle

2. /etc/profile
# /etc/profile

# System wide environment and startup programs, for login setup
# Functions and aliases go in /etc/bashrc

pathmunge () {
        if ! echo $PATH | /bin/egrep -q "(^|:)$1($|:)" ; then
           if [ "$2" = "after" ] ; then
              PATH=$PATH:$1
           else
              PATH=$1:$PATH
           fi
        fi
}

# Path manipulation
if [ `id -u` = 0 ]; then
        pathmunge /sbin
        pathmunge /usr/sbin
        pathmunge /usr/local/sbin
fi

pathmunge /usr/X11R6/bin after

unset pathmunge

# No core files by default
ulimit -S -c 0 > /dev/null 2>&1

USER="`id -un`"
LOGNAME=$USER
MAIL="/var/spool/mail/$USER"

HOSTNAME=`/bin/hostname`
HISTSIZE=1000

if [ -z "$INPUTRC" -a ! -f "$HOME/.inputrc" ]; then
    INPUTRC=/etc/inputrc
fi

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE INPUTRC

for i in /etc/profile.d/*.sh ; do
    if [ -r "$i" ]; then
        . $i
    fi
done

unset i

# For Oracle
 export LD_ASSUME_KERNEL=2.2.5

export display=mylinux:0.0
export USERNAME BASH_ENV PATH
export ORACLE_OWNER=oracle;export ORACLE_OWNER

export ORACLE_BASE=/data/oracle/
export ORACLE_HOME=/data/oracle/products/8.1.7
export TMPDIR=$ORACEL_BASE/tmp

export ORALCE_SID=mylinux
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export PATH=$PATH:$ORACLE_HOME/bin:usr/local/jre/bin:$ORACLE_HOME:/usr/local/:usr/local/jdk/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
export CLASSPATH=/usr/local/jre/bin:$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib:/usr/local/jre:/us
r/local/jre/bin:/usr/local/jdk/lib
umask 022
echo "/etc/profile working "

3. oracle .bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
unset USERNAME
#PATH=$PATH:$HOME/bin



# For oracle #
export LD_ASSUME_KERNEL=2.2.5

export display=mylinux:0.0
export USERNAME BASH_ENV PATH
export ORACLE_OWNER=oracle

export ORACLE_BASE=/data/oracle/
export ORACLE_HOME=/data/oracle/products/8.1.7
export TMPDIR=$ORACEL_BASE/tmp

export ORALCE_SID=mylinux
export ORACLE_TERM=vt100
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export PATH=$PATH:$ORACLE_HOME/bin:usr/local/jre/bin:$ORACLE_HOME:/usr/local/:usr/local/jdk/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/jdbc/lib
export CLASSPATH=/usr/local/jre/bin:$ORACLE_HOME/jlib:$ORACLE_HOME/product/jlib:/usr/local/jre:/us
r/local/jre/bin:/usr/local/jdk/lib
umask 022
mesg
echo "oracle .bash_profile working <== "

 
/root/.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"

export USERNAME BASH_ENV PATH

# for oracle ==>
export ORACLE_BASE=/data/oracle/
export ORACLE_HOME=/data/oracle/products/8.1.7
export ORALCE_SID=mylinux

export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
# <== for oracle

env로는 나오는데..
echo로는 안 보이네요 .. 이거 참...
[oracle@mylinux oracle]$ echo $ORACLE_SID

[oracle@mylinux oracle]$ env
PWD=/data/oracle
LD_ASSUME_KERNEL=2.2.5
TMPDIR=/tmp
KONSOLE_DCOP=DCOPRef(konsole-1220,konsole)
GS_LIB=/data/oracle/.kde/share/fonts
HOSTNAME=mylinux                  <=======================
LD_LIBRARY_PATH=/data/oracle/products/8.1.7/lib:/data/oracle/products/8.1.7/jdbc/lib
SESSION_MANAGER=local/mylinux:/tmp/.ICE-unix/1204
QTDIR=/usr/lib/qt3-gcc2.96
CLASSPATH=/usr/local/jre/bin:/data/oracle/products/8.1.7/jlib:/data/oracle/products/8.1.7/product/
jlib:/usr/                local/jre:/usr/local/jre/bin:/usr/local/jdk/lib
KONSOLE_DCOP_SESSION=DCOPRef(konsole-1220,session-1)
LESSOPEN=|/usr/bin/lesspipe.sh %s
USER=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:m
i=01;05;37                ;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32
:*.sh=01;32:*.csh=01;32:*.tar=01;31:                *.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;3
1:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=                01;31:*.tz=01;31:*.r
pm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=
      01;35:*.tif=01;35:
KDE_MULTIHEAD=false
MAIL=/var/spool/mail/oracle
INPUTRC=/etc/inputrc
OLDPWD=/data/oracle
GTK_RC_FILES=/etc/gtk/gtkrc:/data/oracle/.gtkrc:/data/oracle/.gtkrc-kde
XDM_MANAGED=/var/run/xdmctl/xdmctl-:0,maysd,mayfn,sched
XMODIFIERS=@im=Ami
LANG=ko_KR.eucKR
ORACLE_BASE=/data/oracle/
ORACLE_HOME=/data/oracle/products/8.1.7
ORACLE_TERM=vt100
COLORTERM=
DISPLAY=:0
ORALCE_SID=mylinux              <======
LOGNAME=oracle
SHLVL=3
ORA_NLS33=/data/oracle/products/8.1.7/ocommon/nls/admin/data
SHELL=/bin/bash
HISTSIZE=1000
HOME=/data/oracle
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
display=mylinux:0.0
TERM=xterm
PATH=/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/data/oracle/products/8.1.7/bin:usr/local/jre/bin
:/data/ora                cle/products/8.1.7:/usr/local/:usr/local/jdk/bin:/data/oracle/bin:/data/
oracle/bin:/data/oracle/products/8.1                .7/bin:usr/local/jre/bin:/data/oracle/products
/8.1.7:/usr/local/:usr/local/jdk/bin:/data/oracle/bin:/data/or                acle/products/8.1.7/
bin:usr/local/jre/bin:/data/oracle/products/8.1.7:/usr/local/:usr/local/jdk/bin:/data/or
      acle/bin:/data/oracle/products/8.1.7/bin:usr/local/jre/bin:/data/oracle/products/8.1.7:/usr/
local/:usr/local                /jdk/bin
NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
TNS_ADMIN=/data/oracle/products/8.1.7/network/admin
JLESSCHARSET=ko
ORACLE_OWNER=oracle
_=/usr/bin/env
[oracle@mylinux oracle]$

언제나 즐프를 꿈꾸며~

댓글 달기

텍스트 포맷에 대한 자세한 정보

Filtered HTML

  • 텍스트에 BBCode 태그를 사용할 수 있습니다. URL은 자동으로 링크 됩니다.
  • 사용할 수 있는 HTML 태그: <p><div><span><br><a><em><strong><del><ins><b><i><u><s><pre><code><cite><blockquote><ul><ol><li><dl><dt><dd><table><tr><td><th><thead><tbody><h1><h2><h3><h4><h5><h6><img><embed><object><param><hr>
  • 다음 태그를 이용하여 소스 코드 구문 강조를 할 수 있습니다: <code>, <blockcode>, <apache>, <applescript>, <autoconf>, <awk>, <bash>, <c>, <cpp>, <css>, <diff>, <drupal5>, <drupal6>, <gdb>, <html>, <html5>, <java>, <javascript>, <ldif>, <lua>, <make>, <mysql>, <perl>, <perl6>, <php>, <pgsql>, <proftpd>, <python>, <reg>, <spec>, <ruby>. 지원하는 태그 형식: <foo>, [foo].
  • web 주소와/이메일 주소를 클릭할 수 있는 링크로 자동으로 바꿉니다.

BBCode

  • 텍스트에 BBCode 태그를 사용할 수 있습니다. URL은 자동으로 링크 됩니다.
  • 다음 태그를 이용하여 소스 코드 구문 강조를 할 수 있습니다: <code>, <blockcode>, <apache>, <applescript>, <autoconf>, <awk>, <bash>, <c>, <cpp>, <css>, <diff>, <drupal5>, <drupal6>, <gdb>, <html>, <html5>, <java>, <javascript>, <ldif>, <lua>, <make>, <mysql>, <perl>, <perl6>, <php>, <pgsql>, <proftpd>, <python>, <reg>, <spec>, <ruby>. 지원하는 태그 형식: <foo>, [foo].
  • 사용할 수 있는 HTML 태그: <p><div><span><br><a><em><strong><del><ins><b><i><u><s><pre><code><cite><blockquote><ul><ol><li><dl><dt><dd><table><tr><td><th><thead><tbody><h1><h2><h3><h4><h5><h6><img><embed><object><param>
  • web 주소와/이메일 주소를 클릭할 수 있는 링크로 자동으로 바꿉니다.

Textile

  • 다음 태그를 이용하여 소스 코드 구문 강조를 할 수 있습니다: <code>, <blockcode>, <apache>, <applescript>, <autoconf>, <awk>, <bash>, <c>, <cpp>, <css>, <diff>, <drupal5>, <drupal6>, <gdb>, <html>, <html5>, <java>, <javascript>, <ldif>, <lua>, <make>, <mysql>, <perl>, <perl6>, <php>, <pgsql>, <proftpd>, <python>, <reg>, <spec>, <ruby>. 지원하는 태그 형식: <foo>, [foo].
  • You can use Textile markup to format text.
  • 사용할 수 있는 HTML 태그: <p><div><span><br><a><em><strong><del><ins><b><i><u><s><pre><code><cite><blockquote><ul><ol><li><dl><dt><dd><table><tr><td><th><thead><tbody><h1><h2><h3><h4><h5><h6><img><embed><object><param><hr>

Markdown

  • 다음 태그를 이용하여 소스 코드 구문 강조를 할 수 있습니다: <code>, <blockcode>, <apache>, <applescript>, <autoconf>, <awk>, <bash>, <c>, <cpp>, <css>, <diff>, <drupal5>, <drupal6>, <gdb>, <html>, <html5>, <java>, <javascript>, <ldif>, <lua>, <make>, <mysql>, <perl>, <perl6>, <php>, <pgsql>, <proftpd>, <python>, <reg>, <spec>, <ruby>. 지원하는 태그 형식: <foo>, [foo].
  • Quick Tips:
    • Two or more spaces at a line's end = Line break
    • Double returns = Paragraph
    • *Single asterisks* or _single underscores_ = Emphasis
    • **Double** or __double__ = Strong
    • This is [a link](http://the.link.example.com "The optional title text")
    For complete details on the Markdown syntax, see the Markdown documentation and Markdown Extra documentation for tables, footnotes, and more.
  • web 주소와/이메일 주소를 클릭할 수 있는 링크로 자동으로 바꿉니다.
  • 사용할 수 있는 HTML 태그: <p><div><span><br><a><em><strong><del><ins><b><i><u><s><pre><code><cite><blockquote><ul><ol><li><dl><dt><dd><table><tr><td><th><thead><tbody><h1><h2><h3><h4><h5><h6><img><embed><object><param><hr>

Plain text

  • HTML 태그를 사용할 수 없습니다.
  • web 주소와/이메일 주소를 클릭할 수 있는 링크로 자동으로 바꿉니다.
  • 줄과 단락은 자동으로 분리됩니다.
댓글 첨부 파일
이 댓글에 이미지나 파일을 업로드 합니다.
파일 크기는 8 MB보다 작아야 합니다.
허용할 파일 형식: txt pdf doc xls gif jpg jpeg mp3 png rar zip.
CAPTCHA
이것은 자동으로 스팸을 올리는 것을 막기 위해서 제공됩니다.