
Copyright © 2001, 2015, Oracle and/or its affiliates. All rights reserved.
insert into data_source
(data_source_gid,data_source_xid,data_database_gid,manager,jdbc_driv
er,jdbc_url,schema,oracle_user,oracle_password,vpd_user,is_profiling
_leaks,is_multi_user,domain_name) values
('CUSTOM_DS','CUSTOM_DS','GC3','EXTERNAL
JTS','oracle.jdbc.OracleDriver','jndi:CUSTOM','glogowner','glogdba',
'<encoded password>','DBA.ADMIN','N','Y','PUBLIC');
update data_source_profile_d set data_source_gid = 'PRIMARY_THIN'
where data_function_gid = 'STARTUP';
update data_source_profile_d set data_source_gid = 'CUSTOM_DS' where
data_source_gid = 'PRIMARY_JTS';
commit;
Modify startup scripts on server
Note: If you restart Oracle Transportation Management instance at this point, it will
overwrite your changes made in WebLogic console. Then you have to repeat the steps for
creating Data Source in WebLogic.
Single Oracle Transportation Management Application Server Instance
Log into the server machine as the Oracle Transportation Management install user.
Shut down the Oracle Transportation Management Application server.
Go to the directory <OTM_INSTALL>/weblogic and modify config.xml.fresh as described
below.
Copy jdbc-system-resource element from config.xml to config.xml.fresh (Create a backup
copy of config.xml prior to performing this step.)
1. Copy config.xml.fresh config.xml.fresh.old.
2. Open config.xml and search for the jdbc-system-resource element.
3. Copy the entire jdbc-system-resource element and paste into config.xml.fresh.
Restart the Oracle Transportation Management Application server.
jdbc-system-resource element:
<jdbc-system-resource><name>%Data Source
Name%</name><target>%host_appname%</target>
<descriptor-file-name>jdbc/%jdbc config%.xml</descriptor-file-name>
</jdbc-system-resource>
Example:
<jdbc-system-resource><name>CUSTOM</name><target>gc3-
slc01qra</target>
<descriptor-file-name>jdbc/CUSTOM-8305-jdbc.xml</descriptor-file-
name>
</jdbc-system-resource>
Note: If the descriptor-file-name has a prefix of PRIMARY, then the jdbc configuration will
be deleted by the weblogic.sh file during the next startup.
Kommentare zu diesen Handbüchern