在oracle 10.2 for solaris上手工建立第2个数据库并访问的办法

本文链接：https://blog.youkuaiyun.com/l1t/article/details/910423

本文详细介绍了在eprasunix操作系统中为Oracle用户设置环境变量的过程，并演示了如何创建新的Oracle数据库实例LTDB，包括参数调整、数据库创建命令、监听器配置及基本的用户管理操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

原始数据库是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

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

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";