原始数据库是epras
unix操作系统oracle用户的环境变量是
DISPLAY=192.168.12.132:0.0
HOME=/export/home/oracle
HZ=
LANG=C
LD_LIBRARY_PATH=/oracle/product/10.2.0/Db_1/bin:/oracle/product/10.2.0/Db_1/lib32:/oracle/product/10.2.0/Db_1/network/lib:/usr/local/lib:/usr/lib
LOGNAME=oracle
MAIL=/var/mail/oracle
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/product/10.2.0/Db_1
ORACLE_SID=epras
PATH=.:/oracle/product/10.2.0/Db_1/bin:/bin:/sbin:/usr/ccs/bin:/usr/local/bin
SHELL=/bin/sh
TEMP=/tmp
TERM=dtterm
TMPDIR=/vartmp
TZ=PRC
1.关闭数据库
sqlplus /nolog
conn / as sysdba
shutdown
2.修改init.ora
shared_pool_size = 148397977
并增加1行
undo_management =AUTO
3.启动实例但不启动数据库
startup nomount pfile=/oracle/product/10.2.0/LTDB/dbs/init.ora
然后输入命令行
CREATE DATABASE LTDB
CONTROLFILE REUSE
LOGFILE
GROUP 1 '/tmp/LTDB/REDO01.LOG' SIZE 10M,
GROUP 2 '/tmp/LTDB/REDO02.LOG' SIZE 10M,
GROUP 3 '/tmp/LTDB/REDO03.LOG' SIZE 10M
DATAFILE '/tmp/LTDB/SYSTEM01.DBF' SIZE 500M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
SYSAUX DATAFILE '/tmp/LTDB/SYSAUX01.DBF' SIZE 250M
AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/tmp/LTDB/TEMP01.DBF' SIZE 100M
AUTOEXTEND ON NEXT 100M MAXSIZE 8000M
UNDO TABLESPACE undo
DATAFILE '/tmp/LTDB/undo01.DBF' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
USER SYS IDENTIFIED BY SYS
USER SYSTEM IDENTIFIED BY SYS
;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
4.关闭数据库
5.启动原始数据库
SQL> startup
ORACLE instance started.
Total System Global Area 2550136832 bytes
Fixed Size 1980808 bytes
Variable Size 486540920 bytes
Database Buffers 2046820352 bytes
Redo Buffers 14794752 bytes
Database mounted.
Database opened.
6.启动LTDB数据库
ORACLE_SID=LTDB
export ORACLE_SID
startup pfile=/oracle/product/10.2.0/LTDB/dbs/init.ora
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1977304 bytes
Variable Size 176165928 bytes
Database Buffers 134217728 bytes
Redo Buffers 2211840 bytes
Database mounted.
Database opened.
7.修改tnsnames.ora
增加
LTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.154)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = LTDB)
)
)
8.重新装载监听
$ lsnrctl reload
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 14-JUN-2006 16:50:38
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
$ lsnrctl status
LSNRCTL for Solaris: Version 10.2.0.1.0 - Production on 14-JUN-2006 16:50:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.1.0 - Production
Start Date 14-JUN-2006 11:39:32
Uptime 0 days 5 hr. 11 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/Db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/Db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=t2000)(PORT=1521)))
Services Summary...
Service "LTDB" has 1 instance(s).
Instance "LTDB", status READY, has 1 handler(s) for this service...
Service "LTDB_XPT" has 1 instance(s).
Instance "LTDB", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "epras" has 1 instance(s).
Instance "epras", status READY, has 1 handler(s) for this service...
Service "eprasXDB" has 1 instance(s).
Instance "epras", status READY, has 1 handler(s) for this service...
Service "epras_XPT" has 1 instance(s).
Instance "epras", status READY, has 1 handler(s) for this service...
The command completed successfully
9.访问LTDB
SQL> create user lt identified by "123456";
User created.
SQL> grant connect to lt;
Grant succeeded.
SQL> grant resource to lt;
Grant succeeded.
SQL> conn lt/123456
Connected.
SQL> create table test (col1 char);
Table created.
SQL> conn lt/123456@ltdb
Connected.