#Create data dictionary and pl/sql package
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql;
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql;
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlrp.sql;
conn system/system;
@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/pupbld.sql;
The execution process of the first two scripts is very long.
After the creation is completed, execute the exit command to exit, and then execute sqlplus / as sysdba to log in to the database;
Then execute shutdown immediate; command to shut down the database;
Then execute startup; to start the oracle database. Log out first and log in because after conn system/system, the current user becomes system, and system does not have permission to close the database.
#Configure monitoring
vim /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
#GLOBAL_DBNAME = DB01 is modified to its own global database name
#ORACLE_HOME=/db/app/oracle/product/11.2.0 modify to own oracle home directory
#SID_NAME=orcl modify to own SID
#HOST=192.168.122.155 Change to your own computer IP
#ADR_BASE_LISTENER = /db/app/oracle modify to own oracle installation directory
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=ORCL)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0)
(SID_NAME=orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.11.13)(PORT =1521))
)
)
#Configure the network
vim /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.11.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
#Create user
create user jonychen identified by 123456;
#Authorization
grant create session, connect, resource to jonychen;
#Create table space
create tablespace jonychen_DATA datafile ‘/home/oracle/data/oracle/oradata/jonychen001.dbf’ size 6G;
#Specify the table space
alter user jonychen default tablespace jonychen_DATA temporary tablespace TEMP;
#Create data dictionary and pl/sql package
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catalog.sql;
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/catproc.sql;
@/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlrp.sql;
conn system/system;
@/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/pupbld.sql;
The execution process of the first two scripts is very long.
After the creation is completed, execute the exit command to exit, and then execute sqlplus / as sysdba to log in to the database;
Then execute shutdown immediate; command to shut down the database;
Then execute startup; to start the oracle database. Log out first and log in because after conn system/system, the current user becomes system, and system does not have permission to close the database.
#Configure monitoring
vim /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
#GLOBAL_DBNAME = DB01 is modified to its own global database name
#ORACLE_HOME=/db/app/oracle/product/11.2.0 modify to own oracle home directory
#SID_NAME=orcl modify to own SID
#HOST=192.168.122.155 Change to your own computer IP
#ADR_BASE_LISTENER = /db/app/oracle modify to own oracle installation directory
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=ORCL)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0)
(SID_NAME=orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.11.13)(PORT =1521))
)
)
#Configure the network
vim /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.11.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
#Create user
create user jonychen identified by 123456;
#Authorization
grant create session, connect, resource to jonychen;
#Create table space
create tablespace jonychen_DATA datafile ‘/home/oracle/data/oracle/oradata/jonychen001.dbf’ size 6G;
#Specify the table space
alter user jonychen default tablespace jonychen_DATA temporary tablespace TEMP;
