svrmgr>connect internal as sysdba
svrmgr>shutdown immediate
svrmgr>startup
svrmgr>shutdown immediate
svrmgr>startup
解决方案 »
- oracle除了安装数据以外是不是还要安装相应的开发工具啊!
- 想控制更新记录的数量
- 求一个sql语句
- 初学数据库,应该学社么,是用ORACLE还是用SQL SERVER
- 怎样将Oracle中的数据,导出为MS ACCESS的MDB格式?
- 将这句sqlserver语句转成oracle语句,谢谢
- oracle listener无法启动?
- 如何在命令行调用oracle编译工具编译PL/SQL过程? 有谁开发过PL/SQL编辑器,或者提供点思路。
- 在oracle9i如何新建数据库?
- 生产环境上Oracle 11G alert log里面总是报 TNS-12535: TNS:operation timed out的信息
- 导数据问题.(ORACLE8.17中文版--->ORACLE9I英文版)
- 启动SVRMGRL后 提示 TNS:超出内部限制,请问如何解决!
按您所说,执行到第二行(shutdown immediate),又出以下提示:
Not connected to ORACLE还有高招吗?谢谢!
connect / as sysdbashutdown abort
startup
ORACLE instance terminated. Disconnected forced.
执行Shutdown abort提示如下:
insufficient privileges
执行startup提示如下:
insufficient privileges 请大家再次指教! 谢谢!!
要么自己手工启动startup unmount
alter database mount
alter database open
看看什么信息
Dump file C:\oracle\admin\oracle1\udump\ORA01276.TRC
Tue Sep 10 23:11:52 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: oracle1Redo thread mounted by this instance: 1Oracle process number: 10Windows thread id: 1276, image: ORACLE.EXE
*** SESSION ID:(7.1) 2002-09-10 23:11:52.062
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\ORACLE1\REDO03.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\ORACLE1\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORACLE1\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
*** 2002-09-10 23:12:21.406
Registered presentation http://admin on database startup
connect internal
提示连接成功
然后再
shutdown abort
startup
应该可以的,我试过,如果连本机的oracle,密码没改过,那就不用敲密码直接connect internal就可以了
connect internal时提示输入密码(oracle)
shutdown abort时提示没有connect
密码用oracle试试
用connect internal连接,密码:oracle,提示成功,
但执行shutdown abort时提示没有connect我实在是搞不懂
我查看日志文件了,存在!,我用sys,或internal,权限应该足够吧!
我不知为何大不开日志文件.请再次指教!
ORA-00312: online log 3 thread 1: 'C:\ORACLE\ORADATA\ORACLE1\REDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.说明操作系统无法无法找到日志文件,你先检查相关的日志文件能否访问和打开。