ITS103: APPSLIVE Database Migration

ITS103: APPSLIVE database migration

Implementation Plan

Author: Mark Lang

Contents

Summary of steps required

Database

Database Server

Applications

Finishing Tasks

Database details

Database setup/changes

UOE Standard Database creation

Generate tablespace create script to edit

create apex schema

Reset apex internal p/w

Create unix users & copy code

Create crontab jobs on new db server

Apply grants not included in export, extract from source db

Export APEX applications from source workspaces

Linux users required

Create ssh keys

edit code when copied

Migrate database

Export/import database from Glamis

Database links

Code to be changed to remove domain from databaselink

Database directories

Public synonyms with db links

Application changes

Apex

Tomcat changes

Card app

ERM - prochem

Java changes for mfd

SOA(10G) changes for infinite

Tomcat change for infinite

Evisitor OC4J changes

Coldfusion datasources

CF9

CF9 windows

CF6

CF10

Myed Channels

Run Email acl

Summary of steps required

Database

• Create new database
• Pre create tablespaces in new database
• Pre Install apex
• Export database from current server
• Import db into new Database
• Update database links/code & synonyms
• Create standby database
• Test switchover
• Disable old db

Database Server

• Create new accounts
• Copy and edit code from existing servers
• Setup crons on new db server and disable on old
• Copy apex install code
• Setup ssh keys
• Check if any firewall rule needed

Applications

• Change CF Datasources
• Change JDBC details
• Change connection pools for SOA (10 & 11g)
• Change myed connections
• Import Apex HR workspace and applications

Finishing Tasks

• Check rman backups
• Update Asta
• Decommision old database

Database details

Primary db server / Orakb1
Standby db server / Oraat1
port / 1764
JDBC string / jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orakb1.is.ed.ac.uk)(PORT = 1764))(ADDRESS = (PROTOCOL = TCP)(HOST = oraat1.is.ed.ac.uk)(PORT = 1764))(CONNECT_DATA = (SERVICE_NAME = APPSLIVE_PRMY.is.ed.ac.uk)))
TNS entry / APPSLIVE.WORLD = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orakb1.is.ed.ac.uk.is.ed.ac.uk)(PORT = 1764))
(ADDRESS = (PROTOCOL = TCP)(HOST = oraat1.is.ed.ac.uk.is.ed.ac.uk)(PORT = 1764))
(CONNECT_DATA =
(SERVICE_NAME = APPSLIVE_PRMY.is.ed.ac.uk)))

Database setup/changes

UOE Standard Database creation

See New Database creation procedure for Oracle 11g

Generate tablespace create script to edit

select 'create tablespace '||tablespace_name||' datafile '''||min(file_name)||''' size ‘||trunk(sum(bytes)/1024/1024)||’M autoextend on maxsize 10G next 100M;'
from dba_data_files where tablespace_name not in
('SYSTEM','SYSAUX','USERS','UNDOTBS','TEMP','DRSYS','TOOLS')
group by tablespace_name
/

create apex schema

copy ~/apex directory to database serverDatabase

Cd ~/apex as oracle

Oraappslive

Sqlplus /as sysdba

@?/rdbms/admin/catblock

@apexins SYSAUX SYSAUX TEMP /i/

Reset apex internal p/w

SQL> @apxchpwd.sql

Enter a value below for the password for the Application Express ADMIN user.

Enter a password for the ADMIN user []

Create unix users & copy code

User / Created / p/w infokeep / Code copied from glamis / Code amended (u01,db,homes,scp)
card / y / y / Y
Org / y / y / y
Transpar / y / y / y
Esp / y / y / y
Eusa / y / y / y
Vrs / y / y / y
Uoerae / y / y / y
Ermis / y / y / y
evisitor / y / y / y

Create crontab jobs on new db server

Crons currently on glamis

Username / no of crons / description
card / 4 / processes card details
org / 4 / maintain Organisation Hierarchy
transpar / 1 / upload hr data via sql
smart / 7 / run smart packages
esp / 1 / Automated ESP Data extract from EUGEX - package
eusa / 1 / Runs EUSA Extract Process
vrs / 2 / data load of HR organisation address information into
vrs_org_unit_address table using SQL*Loader
uoerae / 3 / * but all commented out *
ermis / 2 / Run the package which carries out the RAE extract uploads from the HR database and VRS database
evisitor / 1 / idm update

Card

# card.cron 11-Aug-2000 First Written
# extract_check.sh : loads the NESI file
# card_order.sh : sends card order to OCS
# access_daily.sh : creates and transfers file for access control
# returns_test.sh : validates and loads returns file
00 23 * * 0,1,2,3,4,5,6 ksh /homes/mis/card/scripts/extract_check.sh live > /homes/mis/card/scripts/processing/extract.err 2&1
#00 2 * * 3 ksh /homes/mis/card/scripts/card_order.sh > order.err
00 3 * * 1-5 ksh /homes/mis/card/scripts/access_daily.sh > /homes/mis/card/scripts/processing/access.err 2&1
#00 8 * * 5 ksh /homes/mis/card/scripts/returns_test.sh > return.err
# populate smrtcard_organisation from smrtcard_org_view
30 02 * * 0,1,2,3,4,5,6 ksh /homes/mis/card/scripts/staff_pop_org.sh > /homes/mis/card/scripts/processing/staff_org.err 2&1
# populate smrtcard_detail from smrtcard_staff_extract
45 02 * * 0,1,2,3,4,5,6 ksh /homes/mis/card/scripts/staff_pop_dets.sh live > /homes/mis/card/scripts/processing/staff_dets.err 2&1
00 02 * * 1-5 ksh /homes/mis/card/vrs/card_vrs_extract.sh live > /homes/mis/card/vrs/vrs_extract.err 2&1

ORG

#
# Org's Cron - Created by MMC on 13th November 2002
#
# Please Log Any Changes Below:
# ------
# Added Daily Update - MMC 13th November 2002
#
# run daily update on the Organisation Hierarchy Schema
00 07 * * * /homes/mis/org/run_daily_update_live.sh > crontab.err 2&1
#Temp comment out until java installed
30 01 * * 0-6 /homes/mis/org/org_xml_extract/org_xml_extract.sh live > /homes/mis/org/org_xml_extract/crontab.err 2&1
00 01 * * 0-6 /homes/mis/org/orgmi_update/org_download.sh live > /homes/mis/org/orgmi_update/crontab.err 2&1
# IDM monday job
3 9 * * 1 /homes/mis/org/run_org_idm_transfer.sh > /homes/mis/org/org_idm_transfer.log 2&1

Transpar

45 08 * * * /homes/mis/transpar/hr_download/transpar_load.sh | sh /homes/mis/transpar/transpar_emailer.sh

smart

###### 00 03 * * * /homes/mis/smart/smart_dacs_upload_v2.sh live
###### 00 04 * * * /homes/mis/smart/smart_dacs_manipulation.sh live
15 23 * * * /homes/mis/smart/smart_key_reset.sh live
* 7-23 * * * /homes/mis/smart/smart_batches.sh live > /dev/null 2&1
* 7-23 * * * /homes/mis/smart/smart_batches.sh live 15 > /dev/null 2&1
* 7-23 * * * /homes/mis/smart/smart_batches.sh live 30 > /dev/null 2&1
* 7-23 * * * /homes/mis/smart/smart_batches.sh live 45 > /dev/null 2&1
00 09 * * * /homes/mis/smart/smart_datamart.sh live
00 01 * * * /homes/mis/smart/smart_eugex_upload_manipulation.sh live

esp

00 02 * * * /homes/mis/esp/scripts/esp_upload.sh live

Eusa

0 3 * * * /homes/mis/eusa/eusa_run.sh live

Vrs

00 05 * * * /homes/mis/vrs/hr_download/vrs_load_org.sh live > /tmp/vrs_hr.log 2&1
# added by cdh 160505 for midas golive
00 01 * * 0-6 /homes/mis/vrs/midas_download/vrs_copy.sh

Ermis

30 01 * * * /homes/resermis/ermis/scripts/ermis_staff_upload.sh live > /dev/null
#30 02 * * * /homes/resermis/ermis/scripts/ermis_fin_upload.sh live > /dev/null
00 03 * * * /homes/resermis/ermis/scripts/ermis_cache_data.sh live > /dev/null

evisitor

7 * * * * /homes/mis/evisitor/cron/run_idm_update.sh > crontab.err 2&1su

uoerae

#00 00 * * * /homes/mis/uoerae/scripts/uoerae_hr_download.sh live > /dev/null
#30 00 * * * /homes/mis/uoerae/scripts/uoerae_fin_download.sh live > /dev/null
#00 01 * * * /homes/mis/uoerae/scripts/uoerae_stu_download.sh > live /dev/null

Apply grants not included in export, extract from source db

select 'grant ' || PRIVILEGE || ' on ' || GRANTOR || '.' || TABLE_NAME ||

' to ' || GRANTEE || ' ;'

from dba_tab_privs

where grantor in

(select name from sys.ku_noexp_tab where obj_type = 'OBJECT_GRANT')

and grantee not in (select role from dba_roles)

and grantee not in ('STRMADMIN','APEX_04010')

and grantee not in (select user_name from sys.default_pwd$)

and grantee > 'PUBLIC;

Export APEX applications from source workspaces

export HR workspace an all applications in it

Linux users required

create the following users on oradevat.is and oradevkb.is + one group
group
resermis::8366:
org:x:63182:12676:Functional:/home/mis/org:/usr/bin/bash
card:x:36318:12676:Functional:/home/mis/card:/usr/bin/bash
transpar:x:12579:12676:Functional:/home/mis/transpar:/usr/bin/bash
smart:x:63470:12676:Functional:/home/mis/smart:/usr/bin/bash
esp:x:63119:12676:Functional:/home/mis/esp:/usr/bin/bash
eusa:x:8420:12676:Functional:/home/mis/eusa:/usr/bin/bash
vrs:x:63291:12676:Functional:/home/mis/vrs:/usr/bin/bash
ermis:x:8367:8366:Functional:/home/resermis/ermis:/usr/bin/bash
evisitor:x:63548:12676:Functional:/home/mis/evisitor:/usr/bin/bash
uoerae:x:63450:12676:Functional:/home/mis/uoerae:/usr/bin/bash

eves

Create ssh keys

clu.eusa machine needs key added to allow scp from eusa.

see I140305-0535 add public key to clu.eusa.ed.ac.uk

user org to orgmi on oratest|livekb|at2

edit code when copied

replace all reference to /u01 with /db and /homes with /home and /usr/local/bin/scp with /usr/ban/scp

find . -exec grep -l /homes {} +|xargs sed -i s/homes/home/
find . -exec grep -l /u01 {} +|xargs sed -i s/u01/db/
find . -exec grep -l "usr/local"{} +|xargs sed -i 's/\/local\/bin\/scp/\/bin\/scp/g'

Migrate database

Export/import database from Glamis

• Stop listener on glamis
• Shutdown appslive on glamis
• Startup restrict
• expdp / full=y directory=exp_dir dumpfile=appslive_mig%U.dmp parallel=8 log=appstest_mig.log exclude=schema:\"in(\'PERFSTAT\',\'APEX_040100\',\’MISTS\’,\’SMART\’,\’JIRA\’,\’ STRMADMIN\’)\"
• impdp system directory=DB_EXP_ADHOC dumpfile=appstest_mig%U.dmp parallel=8 logfile=appstest_impmig.log statistics=n
• shutdown database on Glamis
• update TNS

Database links

From appslive

owner / link name / connect user / connect DB
UOERAE / UOERAEVRSLINK / UOERAEVRSLINK / APPSLIVE
ERMIS / VRSERMISLINK / ERMISVRSLINK / APPSLIVE
PPMD / PPMD2EUGEX / EUGEXPPMDLINK / HUBLIVE
PPMD / APPS_PPMD_LINK / APPSPPMDLINK / STARLIVE
SCS / SCS2EUGEX / EUGEXLINK / HUBLIVE
PUREINT / PUREFINLINK / PURELINK / FINLIVE
PUREINT / PUREVRSLINK / PUREVRSLINK / APPSLIVE
PUREINT / PUREINT2PURELINK / PUREINTLINK / PURELIVE
PUREINT / PUREORGLINK / PUREORGLINK / APPSLIVE
PUREINT / PUREHRLINK / PURELINK / HRLIVE
EUSA / EUSAEUGEXLINK / EUGEXEUSALINK / HUBLIVE
EVISITOR / EVISITEBROWSELINK / EVBROWSER / NEWSLIVE
EVISITOR / EVISITOR2IDMLINK / IDMLINK / IDMLIVE
MINIFOLIO / MINIFOLIOSTARLINK / SITSMINIFOLIO / STARLIVE
ORG / ORG2IDMLINK / IDMLINK / IDMLIVE
CARD / CARDHR / CARD / HRLIVE
CARD / CARDEUGEXLINK / EUGEXCARDLINK / HUBLIVE
OPS$CARD / CARDHR / CARD / HRLIVE
INFINITE / INFINITE2EFINLINK / INFINITELINK / FINLIVE
INFINITE / ERIINFINITELINK / INFINITEERI / ERILIVE
SMART / SMARTEUGEXLINK / EUGEXSMARTLINK / HUBLIVE
SATSTAGE / SAT2IDMLINK / SAT_SERVICEUSER / IDMLIVE
SATSTAGE / SAT2EUGEXLINK / EUGEXSATLINK / HUBLIVE
APEXTRANSLOAN / APEXTRANSLOANHRLINK / APEXTRANSLOANLINK / HRLIVE
APEXABS / APEXABSHRLINK / APEXABSLINK / HRLIVE
RETAIN / RETAINAFMLINK / AFMRETAINLINK / EBISLIVE
APEXHR / APEXHRHRLINK / APEXHRLINK / HRLIVE
ESP / EUGEXESPLINK / EUGEXESPLINK / HUBLIVE
ESP / EUGEXESPLINK / EUGEXESPLINK / HUBLIVE

Code to be changed to remove domain from databaselink

select owner,name,count from dba_source where text like '%.MIS.ED.AC.UK%' group by owner,name
SQL> /

OWNER NAME COUNT
------
PUREINT PUREINT_FINNONR_REFRESH_PKG 5
SCS SCS_REFRESH_PKG 13
EVISITOR IDM_POST_MIG_POPULATE_SAI 3
EUSA EUSA_GATHER_DATA 1
PPMD PPMD_REFRESH_PKG 14
ERMIS ERMIS_VISITOR_UPLOAD 10
PUREINT PUREINT_PROJNONR_REFRESH_PKG 5
SCS SCS_REFRESH_PKGTEMP 2
PUREINT PUREINT_PROJECT_REFRESH_PKG 6
PPMD REFRESH_SPONSORSHIP 1
PUREINT PUREINT_FIN_REFRESH_PKG 3
11 rows selected.

TO APPSLIVE

forORASID in `ps -ef | grep pmon |grep -v ORA11| awk -F_ '{print $3}'`do. /u01/app/oracle/local/${ORASID}env.sh echo **\**$ORASID****\* sqlplus \-s"/ as sysdba"<EOF set linesize 132set pagesize 999set heading off set echo off set feedback off SELECT owner,db_link FROM dba_db_links WHERE host = 'FINLIVE'; exit EOF done

****HRLIVE***
OPS$APPHR
CARDLOAD_LINK.MIS.ED.AC.UK
UOEPP
TRANSPAR_LINK.MIS.ED.AC.UK
UOEPP
CARD_LINK.MIS.ED.AC.UK
**IDMLIVE***
IDSTOREUSER
IDM2VRSLINK.MIS.ED.AC.UK
**CARSLIVE***
CCTS
CCTSMISLINK.MIS.ED.AC.UK
DSGCCTS
CCTSMISLINK.MIS.ED.AC.UK
**UCDLIVE***
UCD
UCD_ORG_LINK.MIS.ED.AC.UK
**NEWSLIVE***
STRMADMIN
APPSLIVE.MIS.ED.AC.UK

Database directories

take list of directories from the database e.g.

select 'create or replace directory '||directory_name||' as '''||directory_path||''';' from dba_directories

edit the locations for the new server

APPSTEST->vi dir.sql
create or replace directory ORG_XML_EXTRACT as '/home/mis/org/org_xml_extract';
create or replace directory QUEST_SOO_UDUMP_DIR_1_28 as '/db/app/oracle/diag/rdbms/appstest/APPSTEST/trace';
create or replace directory EUSA_DIR as '/home/mis/eusa';
create or replace directory INFINITE_EXTABLES as '/db/data/APPSTEST/DATALOAD/INFINITE';
create or replace directory QUEST_SOO_UDUMP_DIR as '/db/app/oracle/diag/rdbms/appstest/APPSTEST/trace/';
create or replace directory QUEST_SOO_CDUMP_DIR as '/db/app/oracle/admin/APPSTEST/cdump/';
create or replace directory QUEST_SOO_BDUMP_DIR as '/db/app/oracle/diag/rdbms/appstest/APPSTEST/trace/';
create or replace directory QUEST_SOO_ADUMP_DIR as '/db/app/oracle/product/11.2.0.2/rdbms/audit/';
create or replace directory ERMIS_EXTABLES_FIN as '/db/data/APPSTEST/DATALOAD/ERMIS';

create or replace directory ERMIS_EXTABLES_HR as '/db/data/APPSTEST/DATALOAD/ERMIS';
create or replace directory UOERAE_EXTABLES_STU as '/db/data/APPSTEST/DATALOAD/UOERAE';
create or replace directory UOERAE_EXTABLES_FIN as '/db/data/APPSTEST/DATALOAD/UOERAE';
create or replace directory DB_EXP_ADHOC as '/db/exports/adhoc/APPSTEST';
create or replace directory DB_EXP_SCHEDULED as '/db/exports/scheduled/APPSTEST';
create or replace directory XMLDIR as '/db/app/oracle/product/11.2.0.3/rdbms/xml';
create or replace directory UOERAE_EXTABLES_HR as '/db/data/APPSTEST/DATALOAD/UOERAE';
create or replace directory DATA_PUMP_DIR as '/db/app/oracle/admin/APPSTEST/dpdump/';
create or replace directory ORACLE_OCM_CONFIG_DIR as '/db/app/oracle/product/11.2.0.3/ccr/state';
grant read,write on directory ORG_XML_EXTRACT to ops$org;

Public synonyms with db links

run the following sql to remove .mis.ed.ac.uk from synonyms

create or replace public synonym INFINITE_ERI_AWD_BUDGET_SUMMAR for DM_INFOED_ADMINISTRATOR.ERI_RES017_AWD_BUDGET_SUMMARY@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_RPT_SP_PROFILE for DM_INFOED_ADMINISTRATOR.RPT_SP_PROFILE@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROPOSAL_PI for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_PI@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROPOSAL_PI_UUN for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_PI_UUN@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROPOSAL_RELATED for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_RELATED@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_AWD_PERIOD_COSTS for DM_INFOED_ADMINISTRATOR.ERI_RES017_AWD_PERIOD_COSTS@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROP_U for DM_INFOED_ADMINISTRATOR.PROP_U@ERIINFINITELINK;

create or replace public synonym INFINITE_EFIN_CFACSPLUS for EFIN.CFACSPLUS@INFINITE2EFINLINK;

create or replace public synonym INFINITE_EFIN_CLINK_BUDGET_JOU for EFIN.CLINK_BUDGET_JOURNALS@INFINITE2EFINLINK;

create or replace public synonym INFINITE_EFIN_CLINK_BUDGET_LIN for EFIN.CLINK_BUDGET_LINES@INFINITE2EFINLINK;

create or replace public synonym EUGEX_COURSES_MV for EUGEX.EUGEX_COURSES_MV@PPMD2EUGEX;

create or replace public synonym INFINITE_ERI_PROPOSAL_PI_HOURS for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_PI_HOURS@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROPOSAL_CENTRE for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_CENTRE@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_AWD_BUD_UDF for DM_INFOED_ADMINISTRATOR.ERI_RES017_AWD_BUD_UDF@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_PROPOSAL_SUMMARY for DM_INFOED_ADMINISTRATOR.ERI_RES017_PROPOSAL_SUMMARY@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_BUD_U for DM_INFOED_ADMINISTRATOR. BUD_U@ERIINFINITELINK;

create or replace public synonym INFINITE_ERI_AWD_BUDGET_RECVRY for DM_INFOED_ADMINISTRATOR.ERI_RES017_AWD_BUDGET_RECOVERY@ERIINFINITELINK;

Application changes

Apex

• Install Apex in the target database.
• Change Internal P/W
• Import HR workspace
• import Applications

Tomcat changes

bamboo

logon to integration2 as bamboo.

• cd /u01/app/bamboo/home/isapps/connections
• edit air.properties, retain.properties, citestercf.properties
• jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oradevkb.is.ed.ac.uk)(PORT = 1764))(ADDRESS = (PROTOCOL = TCP)(HOST = oradevat.is.ed.ac.uk)(PORT = 1764))(CONNECT_DATA = (SERVICE_NAME = APPSDEV_PRMY.is.ed.ac.uk)))
• edit /u01/app/bamboo/home/bamboo.cfg.xml
• stop/start bamboo
• /u01/app/bamboo/home/scripts/stop_start_bamboo.sh stop/start

Card app

login to minard/fenton as card

• cd /u01/software/card
• edit awaitingRecord/local.properties
• edit cashless/local.properties
• edit csu/war/WEB-INF/classes/jdbc.properties
• restart tomcat

ERM - prochem

login to liappkb1t/ermkb as erm

• cd /u01/app/erm
• edit ./erd6/server/servicelist.xml
• ./erd/deploy/customfiles/config/edinburgh.properties
• ./erd/server/final/WEB-INF/classes/report.properties
• ./erd/server/final/WEB-INF/classes/erm.properties
• restart tomcat

Java changes for mfd

login as mfd on minard/fyvie|morton/niddrie

• cd /homes/prnmfd/mfd/cron/src/mfd
• vi MFDImporter.java
• replace jdbc string
• compile code: /homes/prnmfd/mfd/cron/mfd_do_import.sh test compileR
• run job: /homes/prnmfd/mfd/cron/mfd_do_import.sh test|live

SOA(10G) changes for infinite

update the connection details for “InfiniteConnectionPool” at - both AT and KB

username: oc4jadmin

password: infokeep

to check any failed bpel processes

Tomcat change for infinite

login to minard/fenton as tomcat

edit /u01/app/tomcat/apache-tomcat-5.5.31/webapps/Infinite/WEB-INF/jdbc.properties

restart tomcat

Evisitor OC4J changes

login to fenton/hailes as oc4j

• cd /u01/app/oracle/product/OC4J/HTTPOC4J10.1.3.1.0
• vi ./j2ee/home/application-deployments/eVisitorWebService/data-sources.xml
• restart oc4j

/u01/app/oracle/product/OC4J/adm/oas_shutdown.sh

/u01/app/oracle/product/OC4J/adm/oas_startup.sh

Coldfusion datasources

Change the following datasources to use tnsnames.

CF9

CF instance / datasource / username / new jdbc url / driver class
is / air / airuser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / card / ** no user ** / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / ccds_browser / ccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / ccds_browser_11g / ccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / cf_iskills / iskillsuser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / cf_iskills_admin / iskillsadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / coursesadmin / coursesadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / direct_appslive / mists / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / EventBooking / eventsuser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / EventBookingCCDReader / eventsccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / eves_admin / eves / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / eves_user / eves / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / mcc / mcc / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / mccadmin / mccadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / mccbrowser / mccbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / mccuser / mccuser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / org / org / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / orgbrowser / orgbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / pcounter / pctagent / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / pcounter-11g / pctagent / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / pcounter_era / ERAPcounter / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / pubsadmin_live / fipubsadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / pubsuser_live / fipubspub / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / retain / retain / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / retainbrowser / retainbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
is / wpm_pctepay / pctepaywpm / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
careers / ccds_browser / ccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / mpfdb / minifoliouser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / ppmd_admin / ppmdadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / ppmd_browser / ppmduser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / SCS_ADMIN / scsadmin / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / SCS_BROWSER / scsbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
student / smartuser / smartuser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
finance / ccds_browser / ccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
finance / cf_transpar_admin / transpar / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
finance / eStoresCCDReader / ccdbrowser / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver
finance / wpm_pctepay / pctepaywpm / jdbc:macromedia:oracle:TNSNamesFile=/homes/mis/cfadmin/tnsnames.ora; TNSServerName=APPSLIVE / macromedia.jdbc.MacromediaDriver

CF9 windows