Dbca database creation, configuration listening, data import (CentOS5.6 + Oracle10G), dbcaoracle10g

Dbca database creation, configuration listening, data import (CentOS5.6 + Oracle10G), dbcaoracle10g

Dbca database creation, configuration listening, and data import (CentOS5.6 + Oracle10G)

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

* Goals: Create a database, configure a listener, create a tablespace, and import data

* Steps:

* 1. dbca database creation

* 2. graphical netca configuration listening

* 3. Configure the startup instance

* 4. Create a tablespace

* 5. Import related data

**************************************** ***************************************
1. dbca database creation

-- Use the X-manager software to create a dbca Database

-- Enter the database instance name

2. graphical netca configuration listening

[Oracle @ hyl ~] $ Lsnrctlstatus -- view the listener status

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

 

Copyright (c) 1991,200 5, 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,200 5, Oracle. All rights reserved.

Connected:

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

[Root @ hyl ~] # Vi/etc/rc. d/rc. local

-- Add startup instance and listening statement

#! /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 -- modify the startup value from N to Y

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

 

4. Create related tablespace

Here, the production environment structure and Code are not made public. This article aims to introduce the process.

5. Import Data

[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,200 5, Oracle. All rights reserved.

Username: hyl

Password: hyl

-- Now, the process from creating a database in dbca to importing experiment data has been introduced.

**************************************** *******Statement************************************************ 

Original works, from "Deep Blue blog" blog, welcome to reprint, reprint please be sure to indicate the source (http://blog.csdn.net/huangyanlong ).

Please leave a message if the statement is incorrect. Thank you very much.

Reminder: Click the directory to view the directory.

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

After CentOS64 is installed with oracle10G, an error occurs when dbca is executed. How can this problem be solved?

For example, the paths required by some oralce are not exported.
Check according to the installation instructions.
 
To install oracle10g in oracle linux 56, you need to change the system configurations (such as user, installation directory, and kernel)

Modify/etc/sysctl. conf and add the following content:
Kernel. shmall = 2097152
Kernel. shmmax = 2147483648
Kernel. shmmni = 4096
Kernel. sem = 250 32000 100 128
Fs. file-max = 65536
Net. ipv4.ip _ local_port_range = 1024 65000
*
Net. core. rmem_default = 262144
Net. core. rmem_max = 262144
Net. core. wmem_default = 262144
Net. core. wmem_max = 262144
Modify/etc/security/limits. conf and add the following content:
Oracle soft nproc 2047
Hard nproc 16384
Oracle soft nofile 1024
Oracle hard nofile 65536
Modify ~ Add the following content to oracle/. bash_profile:
Export PATH
Unset USERNAME
Export ORACLE_OWNER = oracle
Export ORACLE_HOME =/home/oracle/product/10.1.0/db_1
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib
Export ORACLE_BASE =/home/oracle/product/10.1.0
Export ORACLE_SID = orcl
Export ORACLE_TERM = xterm
Export ORA_NLS33 = $ ORACLE_HOME/ocommon/nls/admin/data
Export NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
CLASSPATH = $ ORACLE_HOME/jdbc/lib/classes111.zip: $ ORACLE_HOME/jlib: $ ORACLE_HOME/network/jlib: $ ORACLE_HOME/JRE
Export LD_ASSUME_KERNEL = 2.4.1
Export PATH = $ PATH: $ ORACLE_HOME/bin: =/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin: /usr/local/sbin
Umask 022