Oracle 11g ASM : FTP and HTTP Access

28 Sep

###########################################
Oracle 11g ASM : FTP and HTTP Access
###########################################
1. run script catxdbdbca
[oracle@node1 ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@node1 admin]$ sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sun Sep 28 14:52:18 2008
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> @catxdbdbca 7787 8080;
SQL> exit;

2. test FTP Access
[oracle@node1 admin]$ ftp node1 7787
Connected to node1.localdomain.
220- node1
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 node1 FTP Server (Oracle XML DB/Oracle Database) ready.
530  Please login with USER and PASS.
530  Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (node1:oracle): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.

ftp> ls
227 Entering Passive Mode (172,20,141,151,13,24)
150 ASCII Data Connection
drw-r–r–   2 SYS      oracle         0 AUG 03 01:49 OLAP_XDS
drw-r–r–   2 SYS      oracle         0 SEP 23 04:13 home
drw-r–r–   2 SYS      oracle         0 AUG 03 02:15 images
drw-r–r–   2 SYS      oracle         0 AUG 03 01:49 olap_data_security
drw-r–r–   2 SYS      oracle         0 AUG 03 01:35 public
drw-r–r–   2 SYS      oracle         0 SEP 23 04:13 sys
-rw-r–r–   1 SYS      oracle         0 SEP 28 07:52 xdbconfig.xml
226 ASCII Transfer Complete

ftp> cd sys/asm/DATA1/NODE/DATAFILE
250 CWD Command successful

ftp> ls
227 Entering Passive Mode (172,20,141,151,232,90)
150 ASCII Data Connection
-rw-r–r–   1 SYS      oracle  734011392 SEP 28 07:59 SYSTEM.256.666184225
-rw-r–r–   1 SYS      oracle  750788608 SEP 28 07:59 SYSAUX.257.666184225
-rw-r–r–   1 SYS      oracle  346038272 SEP 28 07:59 UNDOTBS1.258.666184225
-rw-r–r–   1 SYS      oracle   5251072 SEP 28 07:59 USERS.259.666184225
-rw-r–r–   1 SYS      oracle  104865792 SEP 28 07:59 EXAMPLE.267.666184357
-rw-r–r–   1 SYS      oracle  262152192 SEP 28 07:59 UNDOTBS2.268.666184499
-rw-r–r–   1 SYS      oracle   2105344 SEP 28 07:59 SENIN_TS.338.666201891
-rw-r–r–   1 SYS      oracle   2105344 SEP 28 07:59 senin_ts01.dbf
-rw-r–r–   1 SYS      oracle  356524032 SEP 28 07:59 SOE.326.666460349
-rw-r–r–   1 SYS      oracle  356524032 SEP 28 07:59 soe.dbf
-rw-r–r–   1 SYS      oracle  713039872 SEP 28 07:59 SOEINDEX.321.666460359
-rw-r–r–   1 SYS      oracle  713039872 SEP 28 07:59 soeindex.dbf
226 ASCII Transfer Complete
ftp> bye

3. test HTTP Access

4. jika instance not running, apakah ftp / http bisa ?
[oracle@node1 admin]$ srvctl stOP database -d node
[oracle@node1 admin]$ srvctl status database -d node
Instance node1 is not running on node node1
Instance node2 is not running on node node2

[oracle@node1 admin]$ ftp node1 7787
ftp: connect: Connection refused
ftp> bye
[oracle@node1 admin]$ ORACLE_SID=node1; export ORACLE_SID
[oracle@node1 admin]$ sqlplus / as sysdba
SQL> startup;
SQL> exit

[oracle@node1 admin]$ ftp node1 7787
Connected to node1.localdomain.
220- node1
Unauthorised use of this FTP server is prohibited and may be subject to civil and criminal prosecution.
220 node1 FTP Server (Oracle XML DB/Oracle Database) ready.
530  Please login with USER and PASS.
530  Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (node1:oracle): system
331 pass required for SYSTEM
Password:
230 SYSTEM logged in
Remote system type is Unix.
ftp> bye
221 QUIT Goodbye.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: