新手求助，关于sys和system的密码

zgliu

系统为rhel es 3 和 oracle9i

oracle9i安装过程中并未提示输入管理员名称和密码，系统默认的管理员名称和密码是不是
sys change_on_install
system manager
这两个？

如下，命令：
[oracle@Matrix oracle]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 06-JUL-2004 13:42:23

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /opt/oracle/product/9.2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Log messages written to /opt/oracle/product/9.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Matrix)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date 06-JUL-2004 13:42:23
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /opt/oracle/product/9.2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Matrix)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@Matrix oracle]$

监听器已经启动，使用sqlplus

[oracle@Matrix oracle]$ sqlplus /NOLOG

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 6 13:43:57 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL>;
进入后，
SQL>; connect sys/change_on_install as sysdba
Connected to an idle instance.
SQL>;
请问，这是什么意思？是密码不对吗？先谢谢了，我是新手，高手多多指教！！！

dsd999

数据库没有open

yongjunzheng

你已经正确了，接着输入startup即可启动oracle

zgliu

谢谢两位，不过还是有错误，如下：
SQL>; connect sys/change_on_install as sysdba
Connected to an idle instance.
SQL>; startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/9.2/dbs/initora9.ora'
SQL>;

该如何解决？

geniiking

确认你是否有opt/oracle/product/9.2/dbs/initora9.ora这个文件

没有就自己写啦，要不然就：
startup pfile=$ORACLE_BASE/admin/$ORACLE_SID/pfile/***.ora

西藏喇嘛

原帖由 "geniiking" 发表：
确认你是否有opt/oracle/product/9.2/dbs/initora9.ora这个文件

没有就自己写啦，要不然就：
startup pfile=$ORACLE_BASE/admin/$ORACLE_SID/pfile/***.ora

没有最好的方法是这样的
sqlplus "/ as sysdba"
sql>;shutdown immediate
sql>;create pfile from spfile;
sql>;startup
即可，不过最好用9I 的spfile文件启动数据库，如果使用pfile文件(initora9.ora)，可以由spfile产生一个。[/url]