Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Steps to create database manually

1.create Pfile from the dummy file.The Pfile(init.ora)is in ORACLE_HOME/dbs.

2.create required number of directories.

3.startup nomount

4.create database script & execute it.

5.execute the following scripts to create default profiles, functions, procedures, views, synonyms

etc.

                i)catalog.sql

                ii)catproc.sql

                iii)connect to system/manager

                iv)pupbld.sql

--------------------------------------

                >su - oracle

                >cd $ORACLE_HOME/dbs

                >pwd

                >ls

                >cp init.ora initssss.ora

                >ls

                >vi initssss.ora

                                db_name = 'ssss'

                                audit_file_dest = 'u01/app/oracle/admin/ssss/adump'

                                db_recovery_file_dest = '/u01/app/oracle/fast_recovery_area'

                                diagnostic_dest = '/u01/app/oracle'

                                control_files = ('/u02/app/oracle/ssss/control01.ctl')

-------------------------------------

                >mkdir -p /u01/app/oracle

                >mkdir -p /u01/app/oracle/admin/ssss/adump

                >mkdir -p /u01/app/oracle/fast_recovery_area

                >mkdir -p /u02/app/oracle/ssss

>chown -R oracle:oinstall /u01/app/oracle/

>chown -R oracle:oinstall /u01/app/oracle/admin/ssss/adump/

>chown -R oracle:oinstall /u01/app/oracle/fast_recovery_area/

>chown -R oracle:oinstall /u02/app/oracle/ssss/

                >chmod -R 775 /u01/app/oracle/

                >chmod -R 775 /u01/app/oracle/admin/ssss/adump/

                >chmod -R 775 /u01/app/oracle/fast_recovery_area/

                >chmod -R 775 /u02/app/oracle/ssss/

>export ORACLE_SID = ssss

>sqlplus / as sqldba

SQL>startup nomount

ORA-00845 : MEMORY_TARGET not supported on this system.

root>mount -t tmpfs shmfs -o size = 2g /dev/shm

SQL>startup nomount

SQL>define_editor = "vi"

SQL>ed dbscript.sql

                create database ssss

                datafile '/u02/app/oracle/ssss/systemo1.dbf'

                size 10m autoextend on

                sysaux datafile '/u02/app/oracle/ssss/sysaux01.dbf'

                size 10m autoextend on

                default tablespace ssss_ts

                datafile '/u02/app/oracle/ssss/ssss_ts01.dbf'

                size 10m autoextend on

                undo tablespace undotbs01

                datafile '/u02/app/oracle//ssss/undo01.dbf'

                size 10m autoextend on

                default temporary tablespace temp_ts

                tempfile '/u02/app/oracle/ssss/temp01.dbf'

                size 10m autoextend on logfile

                group 1('/u02/app/oracle/ssss/redo01.log') size 4m,

                group 2('/u02/app/oracle/ssss/redo02.log') size 4m

                controlfile reuse;

SQL>@dbscript.sql

SQL>ed run.sql

                @$ORACLE_HOME/rdbms/admin/catalog.sql

                @$ORACLE_HOME/rdbms/admin/catproc.sql

                conn system/manager

                @$ORACLE_HOME/sqlplus/admin/pupbld.sql

SQL>@run.sql

-----------------------------------------------

oracle> cd $ORACLE_HOME/sqlplus/admin

oracle> ls

oracle> vi glogin.sql

                set sqlprompt '&_user>'

oracle>sqlplus / as sysdba

SQL>select * from all_users;

SQL>@$ORACLE_HOME/rdbms/admin/utlsampl.sql

oracle>sqlplus / as sysdba

SQL> select * from all_users;

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter