Chinaunix

标题: rhel4的问题，无法连接 [打印本页]

作者: sendqmail 时间: 2007-05-03 14:35
标题: rhel4的问题，无法连接
今天装完oracle数据库，
环境变量为：export PATH
unset USERNAME
# export DISPLAY="192.168.1.142:0.0"
export ORACLE_BASE=/opt/OracleHome
export ORACLE_HOME=$ORACLE_BASE/Oracle9i
export ORACLE_SID=safedb
export THREADS_FLAG=native
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

LD_LIBRARY_PATH
export LD_ASSUME_KERNEL=2.6.9-42.EL
export PATH=$PATH

ORACLE_HOME/bin

[oracle@localhost bin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 3 14:20:16 2007

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

SQL> conn sys/hsmail as sysdba
Connected to an idle instance.
SQL> startup (启动数据库吧？？？)
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/OracleHome/Oracle9i/dbs/initsafedb.ora'
SQL>

在IE里面的错误：

http://localhost.localdomain:5560/isqlplus/dba

An error occurred while loading http://localhost.localdomain:5560/isqlplus/dba:

知道的请帮我搞定这个问题，不盛感激。

作者: nbrr 时间: 2007-05-03 20:01
不是都告诉你了吗
LRM-00109: could not open parameter file '/opt/OracleHome/Oracle9i/dbs/initsafedb.ora'

看你的pfile放在哪儿了，
SQL>startup pfile=/path/to/your_pfile

作者: sendqmail 时间: 2007-05-03 23:36
还是不明白，请master 明柬！

作者: sendqmail 时间: 2007-05-04 10:25
[oracle@localhost bin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-MAY-2007 10:17:42

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                   LISTENER
Version                TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date             04-MAY-2007 09:04:31
Uptime                   0 days 1 hr. 13 min. 11 sec
Trace Level             off
Security                ON: Local OS Authentication
SNMP                   OFF
Listener Parameter File /opt/OracleHome/Oracle9i/network/admin/listener.ora
Listener Log File       /opt/OracleHome/Oracle9i/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost bin]$

我发现我的Trace和SNMP根本就没打开

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)