Creating oracle 10g database manually in linux

 · In order to create a database you have to start an instance without mounting a database and then issue the create databse command. $ SQLPLUS /nolog CONNECT SYS/password AS SYSDBA STARTUP NOMOUNT CREATE DATABASE Share. install_dir/aluidirectory//sql/oracle; For Oracle 10g or 11g, the Oracle WebCenter Interaction installer creates the SQL scripts in the following directories: install_dir/ptportal//sql/oracle_unix10; install_dir/aluidirectory//sql/oracle; Configure the portal database, tablespace, and user. Creating Oracle 11g Database manually in 11 steps in Unix-based Operating system Hi, This is one of the most basic tasks for Oracle DBA,it also helps us to understand how Oracle Database www.doorway.ru Database in 11g is very www.doorway.ru 10g you need to create additional directories bdump,cdump,udump instead of diagnostic dump www.doorway.ruy.

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. Recommandation: store your initialization parameter file in the Oracle Database default location, using the default file name. In $ORACLE_HOME/dbs (on linux) put the www.doorway.ru (www.doorway.ru): db_name='db11g' control_files=('/u01/oracle/oradata/controlctl', '/u02/oracle/oradata/controlctl','/u03/oracle/oradata/controlctl'). Create the Oracle Groups and User Account. Next, create the Linux groups and user account that will be used to install and maintain the Oracle Database 10g Release 2 software. The user account will be called oracle, and the groups will be oinstall and dba. Execute the following commands as root.

13 de jan. de Step 1: First create all the necessary directories. Followings are my directories: testdb1]$ ls admin backup archive admin]$ ls adump bdump. Disk space for database files GB. Required Software. You need SUSE LINUX and Oracle 10g. Also, Novell/SUSE orarun package will help you to make. Using the CREATE DATABASE SQL statement is a more manual approach to creating a database than using Oracle Database Configuration Assistant (DBCA). One.