Home » RDBMS Server » Performance Tuning » Start SQL*PLUS or SQL WorkSheet with problems.
Start SQL*PLUS or SQL WorkSheet with problems. [message #64727] Tue, 13 January 2004 02:22 Go to next message
Rodrigo Almeida
Messages: 3
Registered: January 2004
Junior Member
 

 Hello Friends,

 I'm with two problems to start the program SQL*PLUS or SQL WorkSheet.

 The Oracle show me that erros :

 ORA 01034 - Oracle not Avaliable

 ORA 27101 - Shared memory realm does not exist.

 But, I have instaled inside my computer Oracle 8i with all programs, sample, DBA Studio, Migration utilities and etc. I do know if this can causa perfomance of my system.

 I have one AMD K6 II - 328 Mb of RAM, 20 GB free space.

 All my oracle services were inicialized with computer.

 I liked know, how I can searching solutions to that problem.

 That problem is many fool, but I need solved this.

 Thanks,

 Rodrigo Almeida 

 

 

  
Re: Start SQL*PLUS or SQL WorkSheet with problems. [message #64730 is a reply to message #64727] Wed, 14 January 2004 04:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did u start the database?
got control panel/ services and start the database service
or
use svrmgrl to start manually

c:svrmgrl
svrmgrl>connect internal
svrmgrl> startup
Re: Start SQL*PLUS or SQL WorkSheet with problems. [message #64731 is a reply to message #64730] Wed, 14 January 2004 05:14 Go to previous messageGo to next message
Rodrigo Almeida
Messages: 3
Registered: January 2004
Junior Member
Hello Mahesh,

I maked this, but dont haved access with my accont and accont SYSTEM/MANAGER.

To be same error : ORA27101 - Shared Memory ...

I dont know if is problem with my computer.

Thanks
Re: Start SQL*PLUS or SQL WorkSheet with problems. [message #64732 is a reply to message #64731] Wed, 14 January 2004 05:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
SYTEM user is not usually given the sysdba priv.
connect as internal or
sys as sysbda
Re: Start SQL*PLUS or SQL WorkSheet with problems. [message #64733 is a reply to message #64732] Wed, 14 January 2004 06:40 Go to previous message
Rodrigo Almeida
Messages: 3
Registered: January 2004
Junior Member
OK!

Now, show me error on SQL*PLUS. ORA 27101.

Why this? Little Memory?
Previous Topic: 1z0-024 questions
Next Topic: Difference between Joins
Goto Forum:
  


Current Time: Thu Mar 28 12:49:41 CDT 2024