Oracle不可用ora-01034 [英] Oracle not available ora-01034

问题描述

我正在尝试创建与oracle sqlplus的连接.当我登录时:

I am trying to create to connect with oracle sqlplus. When I login with:

User: sys as sysdba
Pass:

它说已连接到一个空闲实例.

It says Connected to an idle instance.

当我尝试创建表时，它给出了错误

And when I try to create a table, it gives the error

ORA-01034: Oracle not available
Process ID: 0
Session ID: 0 Serial number: 0

为什么不创建表?

推荐答案

首先-最重要的是:

第二:"已连接到空闲实例"表示未启动Oracle.因此，由于您已经以sysdba身份连接(再次:对于DBA任务，您应该仅 要做)，您需要使用以下命令启动Oracle

Secondly: "connected to an idle instance" means Oracle was not started. So as you are already connected as sysdba (again: which you should only do for DBA tasks) you need to start Oracle using the command

startup

在SQL * Plus中.

in SQL*Plus.

然后注销，以普通用户身份登录并创建您的表.

Then log off, log in with a regular user and create your table.

有关详细信息，请参见手册:

For details see the manual:

• 启动命令
• 管理员指南

• Startup Command
• Administrator's Guide

这篇关于Oracle不可用ora-01034的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！