dbca 建库、配置监听、导入数据（CentOS5.6+Oracle10G）

dbca 建库、配置监听、导入数据（CentOS5.6+Oracle10G）

********************************************************************************

*目标：建库、配置监听、创建相关表空间、导入数据

*步骤：

* 1、dbca建库

* 2、图形化netca配置监听

* 3、配置开机启动实例

* 4、创建相关表空间

* 5、导入相关数据

*******************************************************************************

1、dbca 建库

--使用X-manager软件完成dbca建库

--输入数据库实例名

2 、图形化 netca 配置监听

[oracle@hyl ~]$ lsnrctlstatus    --查看监听状态

LSNRCTLfor Linux: Version 10.2.0.1.0 - Production on 19-JUL-2014 23:39:38

 

Copyright(c) 1991, 2005, Oracle.  All rightsreserved.

 

Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hyl)(PORT=1521)))

STATUSof the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version10.2.0.1.0 - Production

StartDate                19-JUL-2014 23:38:32

Uptime                    0 days 0 hr. 1 min. 5 sec

TraceLevel               off

Security                  ON: Local OS Authentication

SNMP                      OFF

ListenerParameter File  /home/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

ListenerLog File        /home/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

ListeningEndpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hyl)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

ServicesSummary...

Service"PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", statusUNKNOWN, has 1 handler(s) for this service...

Service"test" has 1 instance(s).

  Instance "test", status READY, has1 handler(s) for this service...

Service"testXDB" has 1 instance(s).

  Instance "test", status READY, has1 handler(s) for this service...

Service"test_XPT" has 1 instance(s).

  Instance "test", status READY, has1 handler(s) for this service...

Thecommand completed successfully

 

[oracle@hyl ~]$ exportORACLE_SID=test

[oracle@hyl ~]$ sqlplus '/assysdba'

SQL*Plus: Release 10.2.0.1.0 - Productionon Sat Jul 19 23:43:04 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise EditionRelease 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Miningoptions

SQL> selectstatus,instance_name from v$instance;

STATUS      INSTANCE_NAME

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

OPEN        test

3 、配置开机启动实例

[root@hyl ~]# vi/etc/rc.d/rc.local

--添加开机启动实例、监听语句

#!/bin/sh

#

#This script will be executed *after* all the other init scripts.

#You can put your own initialization stuff in here if you don't

#want to do the full Sys V style init stuff.

     

touch/var/lock/subsys/local

su- oracle -c "/home/u01/app/oracle/product/10.2.0/db_1/bin/dbstartstart"

su- oracle -c "/home/u01/app/oracle/product/10.2.0/db_1/bin/lsnrctlstart"

~

~

~

[root@hyl ~]# vi /etc/oratab   --修改开机启动，将值由N设为Y

test:/home/u01/app/oracle/product/10.2.0/db_1:Y

 

4 、创建相关表空间

此处生产环境结构，代码不做公开，此文旨在介绍过程。

5 、导入数据

[oracle@hyl downloads]$ impfile=test.dmp  fromuser=test   touser=test   ignore=y;

Import: Release 10.2.0.1.0 - Production onSun Jul 20 00:44:57 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Username: hyl

Password: hyl

--至此，由dbca建库到导入实验数据流程已经介绍完毕。

***********************************************声明************************************************ 

原创作品，出自 “深蓝的blog” 博客，欢迎转载，转载时请务必注明出处（http://blog.csdn.net/huangyanlong）。

表述有错误之处，请您留言，不胜感激。

提醒：点击目录，更有助于您的查看。

*****************************************************************************************************