Calling all Very Very Urgent.. need help

[Kakateyudu]

Mamalu, while trying to create a database in oracle, naku ee kinda message vastundi.......

pls help seyyandi mams........

ee command use chesa  create database employee;

ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted


pls help me guys............

[Kakateyudu]

sCo_hmmthink sCo_hmmthink sCo_hmmthink

evaru leraaaaaaa

[Naidu_15]

nuvvu ichina database name already vundhata mama try another name.

[Kakateyudu]

[quote author=Naidu_15 link=topic=111288.msg1181102#msg1181102 date=1287616583]
nuvvu ichina database name already vundhata mama try another name.
[/quote]

ye name try chesina ade msg istundi  mama

[Ranga_The_Donga]

database already vundhani tiduthundhi,........peru marchi choodu...

[Kakateyudu]

[quote author=Ranga_The_Donga link=topic=111288.msg1181107#msg1181107 date=1287616673]
database already vundhani tiduthundhi,........peru marchi choodu...
[/quote]

marchi kuda chusa mama even then same msg istundi

[Ranga_The_Donga]

read/write permissions ichara neeku.....?

[Kakateyudu]

[quote author=Ranga_The_Donga link=topic=111288.msg1181116#msg1181116 date=1287616893]
read/write permissions ichara neeku.....?
[/quote]

office kadu mama........

na own laptop........

read write rendu vunnai, admin kada

[naidu garu]

Try to unmount the database and mount it again ....

[Ranga_The_Donga]

The create database command failed.
Normally this error is followed by an accompanied error message indicating the real problem.

Causes can be:

A directory you want to create files into does not exist
A datafile, controlfile or redolog file already exist at the specified location
You were not connected
The database was not startup in nomount mode
You specified an invalid character set
You are connected to a different database, which is running. You need to set the correct environment before executing the create database command
…
Solution: Check the appropriate logfile or error message and fix the problem.

In the next example we try to create a new database OTHER, but we did not set the environment correctly:

SQL> create database OTHER;
create database OTHER
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted
As we can seem, we are already connected to a different database:

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
ORA112    MOUNTED
It is important to set the environment (ORACLE_SID) correctly.

[Kakateyudu]

[quote author=naidu garu link=topic=111288.msg1181128#msg1181128 date=1287617144]
Try to unmount the database and mount it again ....
[/quote]

adi ela cheyyalo konchem seppu mama

[Kakateyudu]

[quote author=Ranga_The_Donga link=topic=111288.msg1181133#msg1181133 date=1287617170]
The create database command failed.
Normally this error is followed by an accompanied error message indicating the real problem.

Causes can be:

A directory you want to create files into does not exist
A datafile, controlfile or redolog file already exist at the specified location
You were not connected
The database was not startup in nomount mode
You specified an invalid character set
You are connected to a different database, which is running. You need to set the correct environment before executing the create database command
…
Solution: Check the appropriate logfile or error message and fix the problem.

In the next example we try to create a new database OTHER, but we did not set the environment correctly:

SQL> create database OTHER;
create database OTHER
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01100: database already mounted
As we can seem, we are already connected to a different database:

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
ORA112    MOUNTED
[b][size=10pt][color=red]It is important to set the environment (ORACLE_SID) correctly.[/color][/size][/b]
[/quote]

edi already chusa mama.......  matter ardam kaledu........ 

[Kakateyudu]

sCo_hmmthink sCo_hmmthink sCo_hmmthink

[Ranga_The_Donga]

[url=http://www.sap-img.com/oracle-database/finding-oracle-sid-of-a-database.htm]http://www.sap-img.com/oracle-database/finding-oracle-sid-of-a-database.htm[/url]

[sunilsee4u]

mama first  ORACLE_SID lo emundo chudu
using echo %ORACLE_SID% IN WINDOWS
$ORACLE_SID IN LINUX

THEN DOWN THE DATABASE
SHUT IMMEDIATE

USE DBCA TO CREATE DATABASE MAMA THATS VERY EASY COMPARED TO MANUAL CREATION