dbaseek
asked on
db
I am using oracle 10g....
What is the first step in creating a database?
Please help me sir Mr.Expert
What is the first step in creating a database?
Please help me sir Mr.Expert
Hi,
start -> programs -> Oracle - OracleHome10gR2 -> Configuration and Migration Tools -> Database Configuration Assistant.
This is the easiest way to create a database for someone who is not really familiar with Oracle.
Note: the Folder "Oracle - OracleHome10gR2" will depend on the name you gave the oracle home.
good luck.
:)
start -> programs -> Oracle - OracleHome10gR2 -> Configuration and Migration Tools -> Database Configuration Assistant.
This is the easiest way to create a database for someone who is not really familiar with Oracle.
Note: the Folder "Oracle - OracleHome10gR2" will depend on the name you gave the oracle home.
good luck.
:)
ASKER
not with the dbca
in command line please......
in command line please......
ASKER
from sqlprompt..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
there are steps for creating database from sqlprompt....
please help me
please help me
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Version 10g ,
please go thro the link ,
step by step db creation on Windows,
1.Create a sid(instance):
start >> run >> cmd >>
issues a command
oradim -new -sid dbname(instance)
if you need any more details about oradim,issue oradim -help
then verify your services started or not,make it automatic,
Start >> run >> services.msc >> you will find the or* services in which
make the service name which you create into automatic.
then create a init file using init.ora parameter refer
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533/build_db.htm
http://www.psoug.org/reference/init_dot_ora.html
http://www.psoug.org/reference/startup_parms.html
place the init file in ORACLE_HOME/database
using that init file,
cmd >> sqlplus
CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
STARTUP NOMOUNT pfile=path
CREATE DATABASE "dbname"
DATAFILE 'd:\oradata\system01.dbf' size 200M
sysaux 'd:\oradata\system01.dbf' size 200M
LOGFILE 'd:\oradata\redo01.dbf' size 10M,
'd:\oradata\redo02.dbf' size 10M,
untodbs1 'd:\oradata\undo01.dbf' size 100m,
CHARACTER SET "WE8ISO8859P1"
NATIONAL CHARACTER SET "UTF8"
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'd:\oradata\temp.f' SIZE 1000M
MAXDATAFILES = 50
MAXLOGFILES = 5;
after creating database configure the listener and tnsnames.
once after you creeate the manual database you have to run ,
CATALOG.SQL
( Needed for all normal data dictionary views)
CATPROC.SQL
( Needed to load the initial PL/SQL environment)
both the scripts will be in the ORACLE_HOME folder
you can go into
$ORACLE_HOME/rdbms/admin
i.e the home path where you are installing the database
Also refer,
https://www.experts-exchange.com/questions/22021158/db.html
please go thro the link ,
step by step db creation on Windows,
1.Create a sid(instance):
start >> run >> cmd >>
issues a command
oradim -new -sid dbname(instance)
if you need any more details about oradim,issue oradim -help
then verify your services started or not,make it automatic,
Start >> run >> services.msc >> you will find the or* services in which
make the service name which you create into automatic.
then create a init file using init.ora parameter refer
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96533/build_db.htm
http://www.psoug.org/reference/init_dot_ora.html
http://www.psoug.org/reference/startup_parms.html
place the init file in ORACLE_HOME/database
using that init file,
cmd >> sqlplus
CONNECT SYS/CHANGE_ON_INSTALL AS SYSDBA
STARTUP NOMOUNT pfile=path
CREATE DATABASE "dbname"
DATAFILE 'd:\oradata\system01.dbf' size 200M
sysaux 'd:\oradata\system01.dbf' size 200M
LOGFILE 'd:\oradata\redo01.dbf' size 10M,
'd:\oradata\redo02.dbf' size 10M,
untodbs1 'd:\oradata\undo01.dbf' size 100m,
CHARACTER SET "WE8ISO8859P1"
NATIONAL CHARACTER SET "UTF8"
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE temp TEMPFILE 'd:\oradata\temp.f' SIZE 1000M
MAXDATAFILES = 50
MAXLOGFILES = 5;
after creating database configure the listener and tnsnames.
once after you creeate the manual database you have to run ,
CATALOG.SQL
( Needed for all normal data dictionary views)
CATPROC.SQL
( Needed to load the initial PL/SQL environment)
both the scripts will be in the ORACLE_HOME folder
you can go into
$ORACLE_HOME/rdbms/admin
i.e the home path where you are installing the database
Also refer,
https://www.experts-exchange.com/questions/22021158/db.html
ASKER
thanks man appreciate.that
ASKER