need help

gounix

请问Oracle817中dba,sysdba等用户的缺省密码是什么?刚下载了一个预装了Oracle的Solaris Vmware文件,但是没有密码.

谢谢.

CCBZZP

　　[Oracle初始口令]
　　internal/oracle
　　sys/change_on_install
　　system/manager
　　scott/tiger

　　[8i OEM初始口令]
　　sysman/oem_temp

gounix

多谢CCBZZP现在遇到新问题.不能启动SQLPLUS.错误信息如下:
$ ./sqlplus system/manager

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 11 09:34:40 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Intel SVR4 UNIX Error: 2: No such file or directory


Enter user-name:

Listener 已经启动
$ ./lsnrctl status

LSNRCTL for Intel SVR4 UNIX: Version 8.1.7.0.0 - Production on 11-JUL-2003 09:32
:59

(c) Copyright 1998 Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Intel SVR4 UNIX: Version 8.1.7.0.0 - Produ
ction
Start Date                10-JUL-2003 23:44:18
Uptime                    0 days 9 hr. 48 min. 41 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /data/u01/oracle/product/8.1.7/network/admin/listener.
ora
Listener Log File         /data/u01/oracle/product/8.1.7/network/log/listener.lo
g
Services Summary...
  PLSExtProc            has 1 service handler(s)
  orcln         has 1 service handler(s)
The command completed successfully

我对ORACLE不熟悉,请指教.

谢谢.

rollingpig

ORACLE_SID设了吗？

gounix

应该设置了.

$ echo $ORACLE_SID
orcln

CCBZZP

Cause: Oracle was not started. Possible causes include the following:

The SGA requires more space than was allocated for it.

The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem
mentioned in the other messages. If Oracle has been initialized, then on some operating
systems, verify that Oracle was linked correctly. See the platform-specific Oracle
documentation.

CCBZZP

不对吧，应该是增加SGA

ORA-01034 ORACLE not available


Cause: Oracle was not started. Possible causes include the following:

The SGA requires more space than was allocated for it.

The operating-system variable pointing to the instance is improperly defined.

Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform-specific Oracle documentation.

rollingpig

你试着
sqlplus system/manager@orcln

or sqlplus "/ as sysdba"

gounix

多谢rollingpig.用sqlplus "/ as sysdba" 可以启动SQLPLUS,但是
用sqlplus system/manager@orcln 得到如下错误信息:


$ ./sqlplus system/manager@orcln

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jul 11 19:32:32 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve service name

不知道为什么.

CCBZZP

Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.

Action: Make the following checks and correct the error:

Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See
the operating system specific manual for details on the required name and location.

Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if
necessary.

Make sure there are no syntax errors anywhere in the file. Particularly look for
unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it
unusable. See the SQL*Net V2 Administrator's Guide. If possible, regenerate the
configuration files using the Oracle Network Manager.