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.
分享到:
相关推荐
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/...
这通常包括Oracle Database Server和Oracle Client组件。在Windows环境下,可以通过Oracle Universal Installer (OUI)进行安装。确保选择合适的版本(如11g、12c或19c)和安装类型(如"Server"或"Client"),根据...
- 按照安装向导的指示进行,选择“Create a new database”创建新数据库。 - 设置数据库字符集、存储大小等参数。 - 完成安装后,进行初始化和配置。 5. **后继步骤**: - 创建数据库监听器(listener.ora)并...
- 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 ...
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|...
- **Create New Connection**:指导用户创建新的连接。 - **Selecting Connection Color**:允许用户为不同的连接选择颜色以便区分。 - **SET ROLE**:讲述了如何使用SET ROLE命令切换角色。 - **Auto Connect**:...
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) ...
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....
1. **安装Oracle数据库软件**:在Linux上,这通常涉及到下载并安装Oracle Database Server软件,如Oracle 11g或12c。安装过程会涉及设置环境变量,如ORACLE_HOME,PATH等。 2. **创建数据库目录结构**:这包括数据...
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 ...