`

manually create a new oracle database

 
阅读更多
using dbca to create a database is preferred approach:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create002.htm

The following describes MANUALLY creating a new oracle database:

Oracle online doc reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/create003.htm

Reference 2:
Search youtube "Oracle DBA Justin - How to create an 11g Oracle database"
http://www.youtube.com/watch?v=QCYIo2Pkke4

1. Create the database ini file under location "$ORACLE_HOME/database".
    The file name must be "initMydbname.ora". for instance, for database 
    SID(less than 8 characters?) "AWCC", the file would be
    "$ORACLE_HOME/database/initAWCC.ora".

    two mandatory params are "db_name" and "control_files". for example: 
    db_name=AWCC and control_files="/u02/oracle/databae/oradata
    /AWCC/control_01.ctl"

2. create the directories to store database files, this can be anywhere, like:
    mkdir /u02/database/oradata/AWCC

3. set env variables:
    export ORACLE_HOME=Oracel_installation_dir/product/11.x.x/db_1
    export ORACEL_SID=AWCC

4. sqlplus to the database to create, ie, AWCC
    sqlplus / as sysdba

5. startup the database, though it's not created yet!
    SQL>startup;

6. run your create database script (create database AWCC ...) from sqlplus
    SQL>@full_path_to_your_create_db_script;

    After complete successfully, database files would be created, including
    control files(.CTL), log files(.LOG) and data files (.DBF) etc.

7. run two Oracle scripts "catalog.sql" and "catproc.sql" from sqlplus, these
    files are located at $ORACLE_HOME/rdbms/admin

    SQL>@?/rdbms/admin/catalog.sql;
    SQL>@?/rdbms/admin/cataproc.sql;

    ? means $ORACLE_HOME

8. restart your database
    SQL>shutdown;
    SQL>startup;

Warning: these only the steps to create a new Oracle database on the video, not yet tested on a linux machine.


分享到:
评论

相关推荐

    presto-oracle

    Create a dir inside plugin dir called oracle. To make it easier you could copy mysql dir to oracle and remove the mysql-connector and prestodb-mysql jars. Finally put the prestodb-oracle in plugin/...

    Creating__the_DATABASE_Manually.rar_Creating

    这通常包括Oracle Database Server和Oracle Client组件。在Windows环境下,可以通过Oracle Universal Installer (OUI)进行安装。确保选择合适的版本(如11g、12c或19c)和安装类型(如"Server"或"Client"),根据...

    linux oracle9i 安装图解

    - 按照安装向导的指示进行,选择“Create a new database”创建新数据库。 - 设置数据库字符集、存储大小等参数。 - 完成安装后,进行初始化和配置。 5. **后继步骤**: - 创建数据库监听器(listener.ora)并...

    Oracle sqldeveloper without jdk (win+linux)

    - Bug 5080543: When an Oracle object definition is opened for editing and the database character set is multibyte, CREATE OR REPLACE keywords may appear twice. Workaround: Remove the superfluous ...

    Oracle事例

    create a user: database authentication sql> create user juncky identified by oracle default tablespace users sql> temporary tablespace temp quota 10m on data password expire sql> [account lock|...

    最完整的Toad For Oracle使用手册

    - **Create New Connection**:指导用户创建新的连接。 - **Selecting Connection Color**:允许用户为不同的连接选择颜色以便区分。 - **SET ROLE**:讲述了如何使用SET ROLE命令切换角色。 - **Auto Connect**:...

    利用 Oracle 和 PHP 管理分布式跟踪文件

    eg utl_file_dir=myDB/oratrace/back utl_file_dir=myDB/oratrace/user Run all of the below mentioned scripts in any database whose trace files you want to view As SYS create a user account (TFMADMIN) ...

    Foundations for Analytics with Python O-Reilly-2016-Clinton W. Brownley

    When you use the sqlite3 module, the database connection details are slightly different from the ones you would use to connect to other database systems like MySQL, Post‐ greSQL, and Oracle....

    Linux下手动创建数据库

    1. **安装Oracle数据库软件**:在Linux上,这通常涉及到下载并安装Oracle Database Server软件,如Oracle 11g或12c。安装过程会涉及设置环境变量,如ORACLE_HOME,PATH等。 2. **创建数据库目录结构**:这包括数据...

    Delphi7.1 Update

    TClientDataset may create an incorrect delta when inserting new master and detail records and then editing the same master record a second time (Quality Central 6849). * The assignment of a LargeInt ...

    端口查看工具

    o A tooltip is displayed when a string in a column is longer than the column length. * Version 1.09: o /close command-line parameter - Close a connection from command-line * Version 1.08: o ...

Global site tag (gtag.js) - Google Analytics