Creating database in oracle 10g manually

You can create an Oracle Database in three ways: Use the Database Configuration Assistant (DBCA). DBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database. Step 1: Login to oracle account and make directories for your database. $ mkdir /u01/oracle/oradata/myica $ mkdir Step 2: Create the parameter file by copying the default template (www.doorway.ru) and set the required parameters $ cd Step 3: Now .  · access the Oracle 10g Enterprise Server Open Net Manager Start-Programs-Oracle10gHome-Configuration and Migration Tools-Net Manager Create a User in mandb Database and test the connection in Net Manager by changing the login. Lastly: create other table spaces. you should create other important tablespaces like the ‘users’ www.doorway.ruted Reading Time: 4 mins.

See "Manually Creating an Oracle Database". Upgrade an existing database. If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database. or you can omit the clause and let Oracle Database create the tablespace for you using a default name and in a default location. When the database is created manually, there is complete control over the process. Tablespaces can be added or reduced and the flow of the creation process can be managed. Here are the steps to be followed to create a Real Application Clusters database manually: 1. Here are several ways to manually issue the "create database" syntax for Oracle: This is just an abbreviated sample of the Oracle create database command and there are many more options: clone/copy oracle with create database command. Oracle 10g Automated create database DBCA. Oracle9i DBCA Database Creation Assistant Templates. RAC Grid.

Your database instance is already mounted to a database. In order to create a database you have to start an instance without mounting a database and then issue the create databse command. There are basically three ways to create an Oracle database: Using the Database Configuration Assistant (DBCA) With the SQL create database statement Through upgrading an existing database. Step 1: Login to SQL* Plus with SYS user and unlock the user account DBSNMP. C:\sqlplus SYS as Step 2: Go to command prompt of windows and issue the following command and wait for minutes.