(3日无新问题)新手总会遇到的问题,请老手指导一点.(日日更新)

1017of

sh:
DISPLAY=<ip>:0.0
export DISPLAY
csh:
setenv DISPLAY <ip>:0.0(not sure)

very_99

我设置了  /etc/hosts
127.0.0.1               as3 localhost.localdomain localhost
192.168.0.246           as3

然后我去启动数据库的时候有报错:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 22-MAR-2006 15:29:15

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

Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
  TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
   Linux Error: 2: No such file or directory

[root@as3 bin]# ./sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory


我的/root/.bash_profile:
PATH=$PATHHOME/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_SID=demo1; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0; export ORACLE_HOME
export USERNAME BASH_ENV PATH

我的/home/oracle/.bash_profile:
# .bash_profile

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

# User specific environment and startup programs

PATH=$PATHHOME/bin

export PATH
unset USERNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_SID=demo1; export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0; export ORACLE_HOME
export DISPLAY=192.168.0.246:0.0

[ 本帖最后由 very_99 于 2006-3-22 16:10 编辑 ]

kirbystar

原帖由 1017of 于 2006-3-22 15:04 发表
sh:
DISPLAY=<ip>:0.0
export DISPLAY
csh:
setenv DISPLAY <ip>:0.0(not sure)

我在csh一般就直接
setenv DISPLAY :0.0
没有设ip

kirbystar

原帖由 very_99 于 2006-3-22 15:35 发表
我设置了  /etc/hosts
127.0.0.1               as3 localhost.localdomain localhost
192.168.0.246           as3

然后我去启动数据库的时候有报错:

LSNRCTL for Linux: Version 10.2.0.1.0 - Producti ...

哦，在/etc/hosts加机器名和ip映射一般是客户端连不上服务端才这样做
个人估计是你listener.ora设置的问题
贴一下该文件吧

very_99

装好了以后在WEB页面上的显示中,一些按钮上的中文都是 小白方块, 这个该怎么解决啊?

very_99

第一次安装好后     重起了就无法再启动ORACLE    谁帮我解释一下啊?

very_99

小方块字符  在WEB上的.............

[ 本帖最后由 very_99 于 2006-3-23 11:24 编辑 ]

1017of

原帖由 kirbystar 于 2006-3-22 20:02 发表

我在csh一般就直接
setenv DISPLAY :0.0
没有设ip

default value would be localhost.if you are by control terminal,you won't have to set this.

very_99

.bash_prefile

# .bash_profile

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

# User specific environment and startup programs

PATH=$PATHHOME/bin

export PATH
unset USERNAME

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10i; export ORACLE_HOME
ORACLE_SID=oral; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

#PATH=$ORACLE_HOME/bin/PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE/ORACLE_HOME/jlib/ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
export DISPLAY=192.168.0.246:0.0





vi  /oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora


ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = as3)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oral)
    )
  )

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

very_99

看了很多帖子  我还是解决不了这个问题~
错误



ERROR - ORA-12154: TNS:could not resolve the connect identifier specified