With an instance of Oracle currently running on the server, we can manually create a database.<\/p>\n
<\/p>\n
In this scenario we are connected to the system as an Oracle user with the first instance active. The first step is to decide on a name for the instance to be created.
\n[crayon]$set ORACLE_SID=cargo<\/p>\n
$export ORACLE_SID=cargo<\/p>\n
[\/crayon]
\nCreate a pfile called initcargo.orcl in the “\/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs” path.<\/p>\n
Configure the paths according to your requirements.
\n[crayon]*.db_name=’cargo’<\/p>\n
*.db_block_size=8192<\/p>\n
*.sga_target=231735296<\/p>\n
*.undo_management=’AUTO’<\/p>\n
*.control_files=’\/u01\/app\/oracle\/oradata\/cargo\/control01.ctl’<\/p>\n
*.user_dump_dest=’\/u01\/app\/oracle\/admin\/cargo\/udump’<\/p>\n
*.background_dump_dest=’\/u01\/app\/oracle\/admin\/cargo\/bdump’<\/p>\n
*.core_dump_dest=’\/u01\/app\/oracle\/admin\/cargo\/cdump'[\/crayon]
\nIt’s necessary to create all of these folders and grant them the needed rights. If you haven’t already created an Oracle user:
\n[crayon]chown oracle:oinstall initcargo.ora this command changes the ownership<\/p>\n
chmod g+w initcargo.ora giving write rights to the oinstall group<\/p>\n
CREATE SPFILE FROM PFILE=’\/u01\/app\/oracle\/product\/10.2.0\/db_1\/dbs\/initcargo.ora’;<\/p>\n
[\/crayon]
\nOpening the database in nomount mode and creating an spfile.
\n[crayon]startup nomount;<\/p>\n
[\/crayon]<\/p>\n
[crayon]ORA-09925: Unable to create audit trail file Linux Error: 2: No such file or directory Additional information: 9925<\/p>\n
[\/crayon]
\nIf you get an error such as this one, there may be a problem with rights and\/or paths.<\/p>\n
<\/p>\n
By using the create database command we create the listed files:<\/p>\n
– Redo Log files<\/p>\n
– system.dbf and sysaux.dbf (files for SYSTEM tablespace)<\/p>\n
– undo01.dbf file (for UNDO tablespace)<\/p>\n
– temp_tbs.dbf file (for TEMPORARY tablespace)<\/p>\n
– users.dbf (for DEFAULT PERMANENT tablespace)
\n[crayon]CREATE DATABASE cargo<\/p>\n
USER SYS IDENTIFIED BY cargo<\/p>\n
USER SYSTEM IDENTIFIED BY cargo<\/p>\n
LOGFILE GROUP 1 (‘\/u01\/app\/oracle\/oradata\/cargo\/redo01.log’) SIZE 50 m,<\/p>\n
GROUP 2 (‘\/u01\/app\/oracle\/oradata\/kargo\/redo02.log’) SIZE 50 m,<\/p>\n
GROUP 3 (‘\/u01\/app\/oracle\/oradata\/kargo\/redo03.log’) SIZE 50 m<\/p>\n
MAXLOGFILES 5<\/p>\n
MAXLOGMEMBERS 5<\/p>\n
MAXLOGHISTORY 1<\/p>\n
MAXDATAFILES 100<\/p>\n
MAXINSTANCES 1<\/p>\n
CHARACTER SET us7ascii<\/p>\n
NATIONAL CHARACTER SET al16utf16<\/p>\n
DATAFILE ‘\/u01\/app\/oracle\/oradata\/cargo\/system01.dbf’ SIZE 325 m REUSE EXTENT MANAGEMENT LOCAL<\/p>\n
SYSAUX DATAFILE ‘\/u01\/app\/oracle\/oradata\/cargo\/sysaux.dbf’SIZE 400 m REUSE<\/p>\n
DEFAULT TABLESPACE tbs_1 DATAFILE ‘\/u01\/app\/oracle\/oradata\/cargo\/users.dbf’ SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED<\/p>\n
DEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE ‘\/u01\/app\/oracle\/oradata\/cargo\/temp_tbs.dbf’ SIZE 20m REUSE<\/p>\n
undo TABLESPACE undotbs DATAFILE ‘\/u01\/app\/oracle\/oradata\/cargo\/undo01.dbf’ SIZE 200m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;[\/crayon]<\/p>\n
The following scripts create views, synonyms and pl\/sql packages.
\n[crayon]CONNECT \/ AS SYSDBA<\/p>\n
@$ORACLE_HOME\/rdbms\/admin\/catalog.sql<\/p>\n
@$ORACLE_HOME\/rdbms\/admin\/catproc.sql<\/p>\n
[\/crayon]<\/p>\n
After getting a “PL\/SQL procedure successfully completed” message.
\n[crayon] shutdown immediate<\/p>\n
startup[\/crayon]
\nUse the following commands to restart the database.
\n[crayon] show parameters<\/p>\n
NAME TYPE VALUE<\/p>\n
O7_DICTIONARY_ACCESSIBILITY boolean FALSE<\/p>\n
active_instance_count integer<\/p>\n
aq_tm_processes integer 0<\/p>\n
archive_lag_target integer 0<\/p>\n
asm_diskgroups string<\/p>\n
asm_diskstring string<\/p>\n
asm_power_limit integer 1<\/p>\n
audit_file_dest string \/u01\/app\/oracle\/product\/10.2.0<\/p>\n
\/db_1\/rdbms\/audit<\/p>\n
audit_sys_operations boolean FALSE<\/p>\n
audit_syslog_level string<\/p>\n
NAME TYPE VALUE<\/p>\n
audit_trail string NONE<\/p>\n
background_core_dump string partial<\/p>\n
background_dump_dest string \/u01\/app\/oracle\/admin\/cargo\/bdump<\/p>\n
backup_tape_io_slaves boolean FALSE<\/p>\n
bitmap_merge_area_size integer 1048576<\/p>\n
blank_trimming boolean FALSE<\/p>\n
buffer_pool_keep string<\/p>\n
buffer_pool_recycle string<\/p>\n
circuits integer<\/p>\n
cluster_database boolean FALSE<\/p>\n
NAME TYPE VALUE<\/p>\n
cluster_database_instances integer 1<\/p>\n
cluster_interconnects string<\/p>\n
commit_point_strength integer 1<\/p>\n
commit_write string<\/p>\n
compatible string 10.2.0<\/p>\n
control_file_record_keep_time integer 7<\/p>\n
control_files string \/u01\/app\/oracle\/oradata\/cargo\/control01.ctl<\/p>\n
[\/crayon]<\/p>\n","protected":false},"excerpt":{"rendered":"
With an instance of Oracle currently running on the server, we can manually create a database.<\/p>\n","protected":false},"author":1,"featured_media":3434,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[383,338],"tags":[345],"class_list":["post-2608","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dba_i","category-oracle-tr","tag-oracle"],"_links":{"self":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/comments?post=2608"}],"version-history":[{"count":1,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2608\/revisions"}],"predecessor-version":[{"id":4822,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/posts\/2608\/revisions\/4822"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/media?parent=2608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/categories?post=2608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sysdba.org\/en\/wp-json\/wp\/v2\/tags?post=2608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}