oracle9i下怎么用startup起数据库？

zenghuangmao

网络配置搞一下啦.
网上大把的资料,要不是现在我没机会给你传上一个，我让你一切都搞定!

strong_sjhi

listener.ora 配置失誤
  仔細看看你的service_name,oracle_sid ,host_name
    看看這個conn system/change_on_install@oa   oa 配置了listener了麼？

wghxwl12

C:\>set  oracle_sid  = 数据库名称;

C:\>SQLPLUS / NOLOG;

SQL>CONN / AS SYSDBA;

SQL> STARTUP

wangxfjsj

你先确定监听程序已经启动了,然后再用SQLPLUS启动数据库,直接连接到数据库上,默认情况下就是启动的,如果你SHUT DOWN 以后再重新启动,可以使用STARTUP OPEN命令.

rwq_

connect / as sysdba

和监听器没有关系，这本身就是用操作系统方式进行认证的。

[php]

bash-2.05$ lsnrctl stop

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 25-OCT-2005 16:42:38

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
bash-2.05$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 25 16:43:02 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>

[/php]