ASM与本地文件系统的交互实验
5墨值下载
一、通过 Oracle 自带包提取
1. 从 ASM 提取到本地
SQL> create directory sou as '+data/RAC';
Directory created.
SQL> create directory des as '/home/oracle';
Directory created.
SQL> exec dbms_file_transfer.copy_file('sou','spfilerac.ora','des','aa.ora');
PL/SQL procedure successfully completed.
2. 从本地提取到 ASMSQL> exec
dbms_file_transfer.copy_file('des','aa.ora','des','test.ora');
PL/SQL procedure successfully completed.
SQL> exec dbms_file_transfer.copy_file('des','aa.ora','sou','test.ora');
PL/SQL procedure successfully completed.
二、利用 Oracle XDB 添加 ftp
oracle@rac12c2:~> sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.1.0 Production on Wed Jul 16 14:21:34 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Advanced Analytics and Real Application Testing options
SQL> @?/rdbms/admin/catxdbdbca.sql 7777 8888
SQL> select dbms_xdb.GETHTTPPORT() from dual;
DBMS_XDB.GETHTTPPORT()
----------------------
8888
1 row selected.
SQL> select dbms_xdb.GETFTPPORT() from dual;
DBMS_XDB.GETFTPPORT()
---------------------
7777
1 row selected.
grid@rac12c1:~> srvctl stop listener -n rac12c1
grid@rac12c1:~> srvctl stop listener -n rac12c2
grid@rac12c1:~> srvctl start listener -n rac12c1
grid@rac12c1:~> srvctl start listener -n rac12c2
grid@rac12c1:~> lsnrctl status
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 16-JUL-2014 14:26:44
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 16-JUL-2014 14:26:28
Uptime 0 days 0 hr. 0 min. 16 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/12.1.0/grid/network/admin/listener.ora
Listener Log File
/u01/app/grid/diag/tnslsnr/rac12c1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.70.136.150)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.70.136.151)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac12c1)(PORT=8888))
(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac12c1)(PORT=7777))
(Presentation=FTP)(Session=RAW))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 2 handler(s) for this service...
Service "pdb_p2" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
Service "pdb_test" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
Service "rac" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
Service "racXDB" has 1 instance(s).
Instance "rac1", status READY, has 1 handler(s) for this service...
The command completed successfully
oracle@rac12c2:~> ftp rac12c2 7777
Connected to rac12c2.
220- rac12c2
Unauthorised use of this FTP server is prohibited and may be subject to civil
and criminal prosecution.
220 rac12c2 FTP Server (Oracle XML DB/Oracle Database) ready.
Name (rac12c2:root): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.
ftp> ls
229 Entering Extended Passive Mode (|||30180|)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 dbfs
drw-r--r-- 2 SYS oracle 0 MAY 24 12:35 home
drw-r--r-- 2 SYS oracle 0 MAY 24 13:08 images
drw-r--r-- 2 SYS oracle 0 MAY 24 12:41 olap_data_security
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 public
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 sys
-rw-r--r-- 1 SYS oracle 0 JUL 16 06:21 xdbconfig.xml
drw-r--r-- 2 SYS oracle 0 MAY 24 12:41 xds
226 ASCII Transfer Complete
ftp> cd sys
250 CWD Command successful
ftp> ls
229 Entering Extended Passive Mode (|||40161|)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 acloids
drw-r--r-- 2 SYS oracle 0 MAY 24 13:09 acls
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 apps
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 asm
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 log
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 oid
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 principals
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 schemas
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 version
drw-r--r-- 2 SYS oracle 0 MAY 24 12:06 workspaces
226 ASCII Transfer Complete
ftp> cd asm
250 CWD Command successful
ftp> ls
229 Entering Extended Passive Mode (|||14316|)
150 ASCII Data Connection
drw-r--r-- 2 SYS oracle 0 JUL 16 06:47 DATA
drw-r--r-- 2 SYS oracle 0 JUL 16 06:47 ASMDATA
226 ASCII Transfer Complete
ftp> cd data
250 CWD Command successful
ftp> ls
of 5
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论