LoveUnix » ORACLE等数据库 » oracle10g启动数据库的时候报错。。。急,在线等。。
让LU留住您的每

一天 让LU博客留住您的每一天
2008-7-18 09:51 yql911
oracle10g启动数据库的时候报错。。。急,在线等。。

我这是LINUXAS4上安装oracle10g
安装过程中很正常。。没有报错。。
报以下错误:



[oracle@oracle ~]$ sqlplus "system/manager as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 16 01:22:15 2008

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/dbs/initfstest.ora'
SQL>

我重新装过了一次数据库软件和数据库。。但是又出现以下的错误。。
我已经设置了SID~~但是还是出现这个错误。。。
[oracle@oracle ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 16 11:00:43 2008

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

SQL> connet system/manager as sysdba
SP2-0734: unknown command beginning "connet sys..." - rest of line ignored.
SQL> connect system/manager as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

我已经设置了SID~~但是还是出现这个错误。。。

2008-7-18 09:53 yql911
谢谢大家了啊!!!

2008-7-24 08:54 smallflower
Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.
Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming.

export ORACLE_SID=

再试试,你也没用listener啊

页: [1]


Powered by Discuz! Archiver 5.5.0  © 2001-2006 Comsenz Inc.