Show Children Hide Children

Main FTS Pages
FtsRelease22
Install
Configuration
Administration
Procedures
Operations
Development
Previous FTSes
FtsRelease21
FtsRelease21
All FTS Pages
FtsWikiPages
Last Page Update
GavinMcCance
2007-07-19

FTS Administration Pack: loading packages for FTS Release 2.0

This describes how to load PL/SQL packages into the database using the SQL/Plus tool.

You should ask your DBA if you have any problems with this; they may have an alternative mechanism for using user packages. You may need some permissions to be set on your FTS account.

A package generally has two components, the header and the body. The header should be loaded first. Load directly using SQL/Plus:

[pcitgm01] /home/mccance/HEAD/dist/slc30/noarch/RPMS > sqlplus lcg_fts_stresstest/xyzpassword@"(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = randomdb1.cern.ch)(PORT = 10121)) (ADDRESS = (PROTOCOL = TCP)(HOST = randomdb2.cern.ch)(PORT = 10121)) (LOAD_BALANCE = no) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = lcg_fts_stresstest.cern.ch) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5))))"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 4 14:27:41 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> @/opt/glite/share/glite-data-transfer-scripts/plsql/fts_admin_pack.sql

Package created.

SQL> @/opt/glite/share/glite-data-transfer-scripts/plsql/fts_admin_pack_body.sql

Package body created.

The package may be queried:

SQL> describe fts_admin_pack
PROCEDURE CHANGE_CHANNEL_DEST
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 V_CHANNEL_NAME                 VARCHAR2(32)            IN
 V_CHANNEL_DEST                 VARCHAR2(100)           IN
PROCEDURE CHANGE_CHANNEL_SOURCE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 V_CHANNEL_NAME                 VARCHAR2(32)            IN
 V_CHANNEL_SOURCE               VARCHAR2(100)           IN
PROCEDURE RENAME_CHANNEL
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 V_CHANNEL_NAME_OLD             VARCHAR2(32)            IN
 V_CHANNEL_NAME_NEW             VARCHAR2(32)            IN

and procedure methods may be called:

SQL> exec fts_admin_pack.CHANGE_CHANNEL_DEST('RANDOM-RANDOM', 'T1SITE_NEWNAME');

PL/SQL procedure successfully completed.


Maintainer: GavinMcCance


Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2007-07-19 - GavinMcCance
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    LCG All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback