This content has been marked as final. Show 8 replies
>1 person found this helpful
I am using a customized tool to create Oracle Database. I have created a few using this tool.instead of this, have you ever try to use database configuration assistant?
or you can create database manually, you can check the link below,
is there any obligation to use this tool?
I have to use only that tool because it maintains a database of the databases.
So, when I create a database using that tool, it gets registered in the main database. Its like a star method.
Whats the cause of the error? Any idea?
The most common cause of the ORA-01034 ORA-27101 Problem is when the ORACLE_SID or ORACLE_HOME not properly set.1 person found this helpful
Hi,1 person found this helpful
DatabaseError: ORA-01034: ORACLE not availableusually tihs error is returned if your database is not up and running, therefore which also will lead to:
ORA-27101: shared memory realm does not existWith regard to your information provided I believe you are working with multiple databases, so therefore ensure you set your Oracle_sid before you get connected, and also ensure you are connected to the database as the sysdba previlege and startup the database. If you login to the database with a normal previleged user like scott other than the sysdba previlege you will get this error
And could you also post the exact error you receive when creating the database
Edited by: A.R.M Asif on May 26, 2010 1:31 AM
Hi,1 person found this helpful
Can you please check the environment variable and the processes running in your machine.
If have multiple databases in your same server then you have to specify which database do you want to connect i.e. you have specify the enviornment variables for example the oracle home? By the way which OS you are using ? Are you doing this in Unix box? Please confirm.1 person found this helpful
Hi,there are may several reasons for Oracle 10.2.0.4.0 and Windows Server 2003 platform.
Of course you can create database manually.But when creating database which template did you select?
Select "Custom Database" template do not select "General Purpose" because in this oracle version(10.2.0.4.0) and this platform(OS) you can get error.Otherwise how did you configure memory(sga/pga)? In memory tab select Shared Memory management with automatic option(error occurred because may you selected manual and shared_pool was significant small.).
FACT #1: I am using a customized tool to create Oracle Database.HOW does the tool work?
FACT #2: Today, I am not able to create any database.
FACT #3: I managed to login and access the databases but the tool need to perform some configuration and thats what is being a problem now.How did you manage to login to the database if you were unable to create the database?
FACT #4: Whenever the configuration runs, after a certain point, I receive this error.Configuration? Creation? How if you are unable to create a database at all??
Regarding your error i suspect youre operating over network and logging to the database via SQLNet from your client (please confirm!). You try to create a database and receive this error.
If your database is on Windows you most probably did not create the required windows service.
My Blog: http://blog.ronnyegner-consulting.de
Edited by: Ronny Egner on May 26, 2010 12:32 PM