新手求助，關(guān)于sys和system的密碼

zgliu

系統(tǒng)為rhel es 3 和 oracle9i

oracle9i安裝過程中并未提示輸入管理員名稱和密碼，系統(tǒng)默認(rèn)的管理員名稱和密碼是不是
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]$

監(jiān)聽器已經(jīng)啟動，使用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>;
進(jìn)入后，
SQL>; connect sys/change_on_install as sysdba
Connected to an idle instance.
SQL>;
請問，這是什么意思？是密碼不對嗎？先謝謝了，我是新手，高手多多指教�。。�

dsd999

數(shù)據(jù)庫沒有open

yongjunzheng

你已經(jīng)正確了，接著輸入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

確認(rèn)你是否有opt/oracle/product/9.2/dbs/initora9.ora這個文件

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

西藏喇嘛

原帖由 "geniiking" 發(fā)表：
確認(rèn)你是否有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文件啟動數(shù)據(jù)庫，如果使用pfile文件(initora9.ora)，可以由spfile產(chǎn)生一個。[/url]