Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

connect to an idle instance oracle 11g

DJIMSONMay 20 2014 — edited May 22 2014

Bonsoir j'ai une question concernant l'instance de Oracle XE

J'arrive pas à me connecter à ma base.

J'ai essayé des manipulations mais toujours même erreur :

Voici les commandes que j'ai lancé :

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

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup nomount PFILE=C:\oraclexe\app\oracle\product\11.2.0\server\config\s

cripts\init.ora

ORACLE instance started.

Total System Global Area 644468736 bytes

Fixed Size 1385488 bytes

Variable Size 192941040 bytes

Database Buffers 444596224 bytes

Redo Buffers 5545984 bytes

SQL> exit

Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - Produ

ction

C:\Users\superviseur>set ORACLE_SID=XE

C:\Users\superviseur>sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Mar. Mai 20 17:20:08 2014

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

SQL> connect / as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 644468736 bytes

Fixed Size 1385488 bytes

Variable Size 213912560 bytes

Database Buffers 423624704 bytes

Redo Buffers 5545984 bytes

ORA-03113: end-of-file on communication channel

Process ID: 4716

Session ID: 91 Serial number: 1

Je demande de l'aide pour pouvoir résoudre ce problème et pouvoir me connecter à ma base pour travailler.

Bien cordialement

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2014
Added on May 20 2014
7 comments
4,141 views