rh as4 + oracle10g完全安裝

zhangyan@tq.cn

rh as4 + oracle10g已經(jīng)完全安裝,
現(xiàn)在在啟動(dòng)的過程中出現(xiàn)問題:用oracle用戶登陸,輸入sys用戶名和密碼,進(jìn)入SQL> startup
提示錯(cuò)誤如下:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/oracle/product/10.2.0/db_1/dbs/initsww.ora'

我的# /u01/.bash_profile是這樣的
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1
ORACLE_SID=sww
PATH=/u01/app/oracle/oracle/product/10.2.0/db_1/binPATH
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH

我看了/u01/app/oracle/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl中的所有的日志,是沒有錯(cuò)誤的.
怎么設(shè)的環(huán)境變量就不生效呢?

blue_stone

ls /u01/app/oracle/oracle/product/10.2.0/db_1/dbs
給出結(jié)果看看, 這樣可以看到你調(diào)用DBCA時(shí)輸入的SID.

zhangyan@tq.cn

[root@www ~]# ls /u01/app/oracle/oracle/product/10.2.0/db_1/dbs
hc_orcl.dat  initdw.ora  init.ora  lkORCL  orapworcl  spfileorcl.ora

記得我的SID是orcl

numenhuang

原帖由 zhangyan@tq.cn 于 2006-12-7 09:50 發(fā)表
[root@www ~]# ls /u01/app/oracle/oracle/product/10.2.0/db_1/dbs
hc_orcl.dat  initdw.ora  init.ora  lkORCL  orapworcl  spfileorcl.ora

記得我的SID是orcl

.bash_profile中修改ORACLE_SID=orcl

zhangyan@tq.cn

我已經(jīng)改過來了,現(xiàn)在是這樣的,
Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> lsnrctl start
SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL>

請(qǐng)問我還需要做什么工作才能開始建數(shù)據(jù)庫

numenhuang

原帖由 zhangyan@tq.cn 于 2006-12-7 10:08 發(fā)表
我已經(jīng)改過來了,現(xiàn)在是這樣的,
Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP  ...

1.從你上面的描述來看，應(yīng)該是使用dbca已經(jīng)創(chuàng)建數(shù)據(jù)庫orcl，并且orcl在創(chuàng)建完畢以后已經(jīng)在運(yùn)行了。
2.lsnrctl 是os命令行運(yùn)行的，不是在sqlplus中運(yùn)行的

建議先熟悉oracle相關(guān)的文檔。

zhangyan@tq.cn

還想問一下,為什么我每次輸入sqlplus后的顯示是不一樣的?
為什么每次都要輸入用戶名和密碼呢?
比如:
sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 7 10:03:51 2006

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

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@www ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 7 10:16:01 2006

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

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

謝謝,我一定去看文檔,只是這個(gè)問題一直捆饒我.

numenhuang

原帖由 zhangyan@tq.cn 于 2006-12-7 10:21 發(fā)表
還想問一下,為什么我每次輸入sqlplus后的顯示是不一樣的?
為什么每次都要輸入用戶名和密碼呢?
比如:
sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 7 10:03:51 2006

Copyright (c) 198 ...

Connected to an idle instance.

有Connected to an idle instance.代表sqlplus連接的db instance沒有啟動(dòng)
如果db已經(jīng)startup，則不會(huì)有這個(gè)提示。

至于用戶和密碼，就和unix一樣的，你登錄unix，也不是要輸入

當(dāng)然在服務(wù)器上你也可以sqlplus / as sysdba

[ 本帖最后由 numenhuang 于 2006-12-7 10:34 編輯 ]

zhangyan@tq.cn

[oracle@www ~]$ sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Dec 7 10:33:55 2006

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

Enter user-name: system as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  281018368 bytes
Fixed Size                  1218944 bytes
Variable Size              88082048 bytes
Database Buffers          184549376 bytes
Redo Buffers                7168000 bytes
Database mounted.
Database opened.
SQL>


我理解了,謝謝您!