Note The most uptodate version of this installation guide is available from the Oracle Database Express Edition Oracle Database XE download page on Oracle. Oracle 10g Free Download Latest version setup. Design and build databases with Oracle reliable technology. Oracle 10g is easy to use with high performance. Www. puschitz. com The following procedure is a stepbystep guide Cookbook with tips and information for installing Oracle Database 10g on Red Hat Linux. Creating an Oracle Database manually through SQL Commands. Creating the Oracle Database through SQL Commands. This section presents the steps involved when you create a database. These steps should be followed in the order presented. Before. you create the database make sure you have done the planning about the. Tutorial with Step by Step Commands on Creating an Oracle Database with Examples. Regarding the size of the database you have to first find out how many. The best thing is to start. Plan the layout of the underlying operating system files your database. Proper distribution of files can improve database. IO during file access. You. can distribute IO in several ways when you install Oracle software and. For example, you can place redo log files on. You can situate datafiles to reduce. And you can control data density number of rows to a data. Select the standard database block size. This is specified at database. DBBLOCKSIZE initialization parameter and cannot be. For databases, block size of 4. K. or 8. K is widely used. Before you start creating the Database it is best to write down the. The examples shown in these steps create an example database myicadb. Let us create a database myicadb with the following specification. Database name and System Identifier. SIDmyicadb. DBNAMEmyicadb. TABLESPACES we will have 6 tablespaces in this database. With 1. datafile in each tablespaceTablespace Name. Datafile Location. Size. SYSTEMu. 01oracleoradatamyicasys. MUSERSu. 01oracleoradatamyicausr. MUNDOTBSu. 01oracleoradatamyicaundo. MTEMPu. 01oracleoradatamyicatemp. MINDEXDATAu. 01oracleoradatamyicaindx. MSYSAUXu. 01oracleoradatamyicasysaux. MLOGFILES we will have 2 log groups in the database Logfile Group Member Location. Size. GROUP 1u. 01oracleoradatamyicalog. MGROUP 2u. 01oracleoradatamyicalog. MCONTROL FILEWe will have 1 Control File in the following. PARAMETER FILE we will use normal parameter file for now, later. SPFileu. 01oracledbsinitmyicadb. ORACLEHOMEdbs directory in Unix os and. ORACLEHOMEdatabase directory in windows os Now let us start creating the database. Step 1 Login to oracle account and make directories for. Step 2 Create the parameter file by copying the default. Now open the. parameter file and set the following parameters vi initmyicadb. DBNAMEmyicadb. DBBLOCKSIZE8. CONTROLFILESu. UNDOTABLESPACEundotbs. UNDOMANAGEMENTAUTOSGATARGET5. MPGAAGGREGATETARGET1. MLOGBUFFER5. 24. DBRECOVERYFILEDESTu. DBRECOVERYFILEDESTSIZE2. G The following. BACKGROUNDDUMPDESTu. USERDUMPDESTu. After entering. the above parameters save the file by pressing Esc. Step 3 Now set ORACLESID environment variable and start the. ORACLESIDmyicadb sqlplus. Enter User as sysdba. SQL startup nomount. Step 4 Give the create database command. Here I am not specifying optional setting such as language, characterset. For these settings oracle will use the default values. I am giving the bare minimum command to create the. The command to create the database is SQL create database myicadb datafile u. M sysaux datafile u. After the command finishes you will get the following message Database created. If you are getting any errors then see accompanying messages. If no. accompanying messages are shown then you have to see the alertmyicadb. BACKGROUNDDUMPDEST directory, which will show the exact reason why the command has failed. After you have rectified the. Step 5 After the above command finishes, the database will get. Now create additional tablespaces To create. USERS tablespace. SQL create tablespace users datafile. M To create INDEXDATA. SQL create tablespace indexdatadatafile. MStep 6 To populate the database with data dictionaries and to. First execute the. CATALOG. SQL script to install data dictionaries SQL u. The above script. After the above script is finished run the. CATPROC. SQL script to install. SQL u. 01oraclerdbmsadmincatproc. This script. will also take several minutes to complete. Step 7 Now change the passwords for SYS and SYSTEM account. SQL alter user sys identified by myica SQL alter user system identified by myica Step 8 Create Additional user accounts. You can create as many. Let us create the popular account SCOTT. SQL create user scott default tablespace users. M on users SQL grant connect to scott Step 9 Add this database SID in listener. This. file will already contain sample entries. Copy and paste one sample. SID setting LISTENER DESCRIPTIONLIST DESCRIPTION ADDRESS PROTOCOL TCPHOST2. PORT 1. 52. 1. SIDLISTLISTENER SIDLIST SIDDESC SIDNAME PLSExt. ProcORACLEHOME u. PROGRAM extproc. SIDDESC SIDNAMEorclORACLEHOMEu. Add these lines in SIDLISTLISTENER at the bottom of file. SIDDESC SIDNAMEmyicadbORACLEHOMEu. Save the file by pressing Esc wq. Now restart the listener process. lsnrctl stop lsnrctl start. Step 1. 0 It is recommended to take a full database backup after. How to take backup is deal in the Backup and Recovery Section. Congratulations you have just created an oracle database.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2018
Categories |