DBCA Building, configuring listening, importing data (centos5.6+oracle10g)

DBCA Building, configuring listening, importing data (centos5.6+oracle10g)

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

* Target: Build a library, configure monitoring, create related tablespaces, import data

* steps:

* 1,dbca Building Library

* 2, graphical netca Configuration Monitoring

* 3 , configure boot boot instance

* 4 , create a related table space

* 5 , import related data

*******************************************************************************
1, DBCA Building Library

-- Use X-manager Software Completion DBCA Build Library

-- Enter the database instance name

2, graphical NETCA configuration monitoring

[[email protected] ~]$ lsnrctlstatus -- view listening status

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, have 1 handler (s) for the This service ...

The Service "test" has 1 instance (s).

Instance "Test", status Ready, HAS1 handler (s) for the This service ...

Service "Testxdb" has 1 instance (s).

Instance "Test", status Ready, HAS1 handler (s) for the This service ...

Service "TEST_XPT" has 1 instance (s).

Instance "Test", status Ready, HAS1 handler (s) for the This service ...

Thecommand completed successfully

[Email protected] ~]$ exportoracle_sid=test

[Email protected] ~]$ sqlplus '/ASSYSDBA '

Sql*plus:release 10.2.0.1.0-productionon Sat 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. Configure Boot instance

[Email protected] ~]# vi/etc/rc.d/rc.local

-- Add boot instance, listen statement

#!/bin/sh

#

#This script'll is executed *after* all and the other init scripts.

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

#want to does 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"

~

~

~

[[email protected] ~]# Vi/etc/oratab--Modify boot start, set the value from N to Y

Test:/home/u01/app/oracle/product/10.2.0/db_1:y

4. Create related table spaces

The production environment structure here, the code is not made public, this article is intended to introduce the process.

5. Import data

[Email protected] 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

-At this point, the process has been introduced from DBCA to importing experimental data.

*********************************************** declaration ***************************************** *******

original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source ( Http://blog.csdn.net/huangyanlong ).

There is an error in the statement, please leave a message, greatly appreciated.

Reminder: Click on the table of contents, more helpful to your view.

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