oracle9i 安裝后的密碼問題

nutuge

linux8.0 + oracle 9.2.0

oracle9i 安裝過程中沒有提示修改密碼的界面

安裝完成后，運(yùn)行sqlplus 卻提示密碼
嘗試了以下所有用戶名和密碼都不行
internal/oracle
sys/change_on_install
system/manager
scott/tiger

我該怎么辦？

pydwh

9i中已取消internal/oracle 。
先試一下下面的方法：
sqlplus /nolog
conn / as sysdba;
alter user sys identified by sys;
alter user system identified by manager;
alter user scott identified by tiger;
如果成功，再用改了密碼后的任一用戶登陸檢驗(yàn)一下。

nutuge

出錯了，請看！·
#sqlplus /nolog
sql >;conn / as sysdba;
connected an idle instance.
sql>;alter user sys identified by password;
alter user sys identified by password;
*
error at line 1:
ora-01034racle not available
sql>;

kingbird

服務(wù)沒有處于正常啟動狀態(tài)

>;sqlplus /nolog
>;connect /as sysdba
>;startup open
>;select status from v$instance
status
--------
open
>;alter user sys identified sys;

nutuge

對不起，各位，我是第一次安裝oracle
又出錯！
#sqlplus /nolog
sql >;conn / as sysdba;
connected an idle instance.
sql>;startup
ora-01078:failure in processing system parameters
lrm-00109:codld not open parameter file '/opt/oracle/product/9.2.0/dbs/inittest.ora'
sql>;

nutuge

頂下呀

幫幫我�。�！

nutuge

up

nutuge

服務(wù)已經(jīng)正常啟動了！
但是修改密碼時還是提示出錯
SQL>; connect / as sysdba
SQL>; startup nomount
ORACLE instance started.

Total System Global Area 70062220 bytes
Fixed Size 450700 bytes
Variable Size 62914560 bytes
Database Buffers 6553600 bytes
Redo Buffers 143360 bytes
SQL>;  
SQL>; alter user sys identified by sys
alter user sys identified by sys
                                           *
error at line 1:
ora-01109:database not open

pydwh

原帖由 "nutuge" 發(fā)表：
服務(wù)已經(jīng)正常啟動了！
但是修改密碼時還是提示出錯
SQL>; connect / as sysdba
SQL>; startup nomount
ORACLE instance started.

Total System Global Area 70062220 bytes
Fixed Size 450700 bytes..........

startup nomount 只啟動實(shí)例，沒打開數(shù)據(jù)庫。
你應(yīng)該執(zhí)行:
SQL>;startup
就行了
建議看一下這篇文章：
Oracle數(shù)據(jù)庫有哪幾種啟動方式