IUCLID 5 Guidance and Support
Contents
1. Diagnostics Denial 8 Domain 8 Within the domain structure tree on the left navigate to Deployments then click the install button IUCLIDS hea WEBLOGIC SERVER fF ADMINISTRATION COMSOLE Misamis a Donroe iek seniii Home Loy Gut Preferences Help ASEEA View changes and restarts Home gt Sunienary of Deployments Mo perdi changes mist Clack Summary of Deployments the Release Configuration button to allow others to edit the domain Control Monitoring This page displays 2 list of EEE Applications and standalone application modules that have been instadied to this daman installed applicators amd modules can be started stopped updated redepionyed of deleted from the domain by first selecting the application name and using the control on this page D in Struct To install a new application or module for deplayrmnent to argots in this domain click e Iretall button mohSooman Eneronment Deployments Services Security Realms r r E interoperability F Name Deployment Order J Diagnostics A Showing 1 lofi Previous Meat Showing 1 lofi Previous Meat How do L af E peill an Eniterpr et application T Mase dlae ee e Poe iee e me oe me oe oe oe hi om 9 Locate the web application s directory and mark the check box in front of your directory and click next amp bea bela a SAn pOH CO2. 2 2 1 Important technical information about existing IUCLID 5 0 5 1 installations with Oracle 4 2 MINS WAIN SG e E oe ota due deonwiee ce useeuneisesaesaeceataedeitet eeenseeetees 5 223 Preparine ihe 1ADICS PACE sacscenaeacs noncueonesnaeasnnensnasocsusavonnandancuusuenaesenueunencatasboseaueiemnatientmnarcauecneatands 5 2 24 MECN GING melds database USCI sessnneaccumnasenensadeaseac ne I EE E 6 R E E E E A 7 De DELA WeDo e aE a E E T 2A ET COMISINCS e O E T 2 7 Update the ANTLR COM On CM ssassn ee EE a 7 2 Deploy miemG Or TO CUM D erra ciao retsmsneaiensaeenecanasnscomaed EEE 8 gt Im alsanon Ol am installanon Or IUCLID S oscesoscdecuscitsceseeuse euch a a a aN 17 A U E a E E E 17 e Ea A I EE EE EE E E ETE EEE TEETE OE E E E NEE EE A ETT IEA TTE 18 PEU Mana Ce Mic Wl a E E a tonsaneaduessamieusinedeooens 24 ill IUCLIDS Chapter 1 Introduction IUCLID 5 can be installed as a standalone application or in a multi user environment This document describes how to configure commercial products Oracle BEA Weblogic for use with the IUCLID 5 distributed version For a UCLID installation using commercial software the following components can be used e JDK 1 6 or newer Installation packages can be downloaded from http java sun com javase downloads index jsp e BEA WebLogic Server 9 0 http www oracle com bea e Oracle 10g Installation packages can be downloaded from http www oracle com IUCLIDS
3. Chapter 2 Installation 2 1 Important technical information about existing IUCLID 5 0 5 1 installations that use client server architecture Important J There is no automatic upgrade of the database from IUCLID 5 0 5 1 to UCLID 5 2 The data must be transferred manually from the old to the new database as described in the sub section below Each installation of UCLID 5 must have its own database and its own web application server There can be more than one database running on a single instance of the database software but each web application server cannot be used to run more than one UCLID 5 application at once 2 1 1 Migration of data to IUCLID 5 2 from a previous version Before starting to install I UCLID 5 2 all the data must be exported from IUCLID 5 1 x using the Back up plugin that is available on the IUCLID web site The export process is essential because the exported data will later be imported into UCLID 5 2 When it is run the Back up plugin asks the user to create and enter a single password This will become the password for all the user accounts in the new installation with the exception of the account SuperUser which has a default password of root To import the exported data into UCLID 5 2 use the built in Restore feature of IUCLID 5 2 that can be found from the menu File Administrative tools This feature allows the upload of data that was exported using the Back up plugin on 5 1 x Note that it is not po
4. copy the directory noted in step 1 2 example iuclid51 to the directory just created example uninstalled_webapps 6 In the Web Application Manager un deploy the application example iuclid51 Install IUCLID 5 2 as described in the installation manual Note that a new database must be created It can be running on the same instance of the database software but in that case the database must have a different name When IUCLID 5 2 is running use its built in Restore feature to upload data from the back up that was created during the initialisation process step 1 1 To switch between versions of IUCLID 5 example iuclid52 gt iuclid5 1 1 In the Web Application Manager make a note of the name of the path to the UCLID 5 application from which you are switching example iuclid52 2 In the Web Application Manager stop that IUCLID 5 application example iuclid52 3 In the computer s file system copy the application directory of the IUCLID 5 from which you are switching example tuclid52 to the directory uninstalled_webapps 4 In the Web Application Manager un deploy the IUCLID 5 application from which you are switching example iuclid52 5 In the computer s file system move the directory of the UCLID 5 to which you are switching example tuclid51 from the directory uninstalled_webapps to the directory webapps 6 Start the IUCLID 5 application to which you are switching example iuclid51 Before switc
5. Showing 1 1of 1 Previous Mext applicator r Start and stop a deployed M Name amp state Deployment Enterprise applicati a Type Order B Monitor the mnocdules of an 4 in dui bute Web Enipo Apc atin E Initializing Applicator Deploy E38 modules i ingtall a Web application 100 Showing 1 1of 1 Previous Next 14 Now you are able to start the newly deployed application by clicking on Service all requests Welcome mecidS Connected tn iucliesDomain T Meir Log Cant Prates erges Hehi ASEM Home gt Summary of Deployments Summary of Deployments Control Monitoring Thi page displays a list of KEE Applicators and standalone applicahon modules that have been installed to tis domain installed applications and modules can be started stopped updated redeployed or deleted from fie domain by first selecting the application name and using the controls on thiis page To natal a new application or module for deployment to targets in thie domain click the Install button Showing 1 Lofl Prevaowe Next Showing l lof Previous ext zi F mig i zuk Seriking ont aminer aan ragquest 15 Make a last confirmation Yes 14 IUCLIDS Connected t huctidSDemain Home Log Out Preferences Heip AskbEA Pore gt Summary of Teploprents Start Deployments You have selected the filiow
6. SuperUser because SuperUser should be used only for the special tasks that only it can carry out See the IUCLID 5 User Manual for more detail As part of the First steps wizard a legal entity must be uploaded into the IUCLID 5 installation in the form of a LEOX file Therefore before running this wizard make sure that a LEOX file for the legal entity of your company or organisation is accessible to your computer For more information see the IUCLID 5 User Manual The First steps wizard provides the option of uploading the following information to your IUCLID 5 installation For details see the IUCLID 5 User Manual e EC Inventory e Inventory of Reference substances Although these uploads are optional it is strongly recommended to do them during the first run of the First steps wizard To do so you will need to have the data accessible to your computer whilst running this wizard The First steps wizard can be run at any time but only by the SuperUser This is done from the file menu within IUCLID 5 Administrative tools Initialise When starting the IUCLID 5 for the first time the only user available is an administrator named SuperUser Log in as SuperUser by entering the following case sensitive values into the login screen as shown below Username SuperUser Password root A IUCLID 5 2 0 Se Please enter username and password to login ilocal workstation passnora leew Login Cancel The First step
7. the installation of the application server please contact the technical support of the vendor Important O due to the fact that WLS9 2 uses an older version of the library Antlr the configured server instance has to be patched 2 3 2 Update the ANTLR component BEA WebLogic brings along its own incompatible version of ANTLR a parser generator used by various open source projects to parse their own script languages Also Hibernate uses this library however in a more recent version So we need to update the version provided by BEA Unfortunately BEA s ANTLR is not packaged separately but contained in the central weblogc jar So we need to perform a patch of the scripts which start the WebLogic server Work around 1 Extract the needed JAR from the i5server war by unzipping this file to a new directory It is located in the path WEB INF lib and named depending on the current version e g antlr 2 7 6rc1 jar or higher 2 Copy antlr 2 7 6rc1 jar to directory 7INSTALLDIR weblogic90 server lib IUCLIDS Note Be sure that the file permissions are set correctly 3 Edit file ZINSTALLDIR weblogic90 common bin commEnv bat be sure to keep a copy 4 Alter the boot classpath of all WebLogic servers by adding the new ANTLR jar at the beginning of the classpath find the line WEBLOGIC CLASSPATH C1 PATCH CLASSPATH S CLASSPATHSEP JAVA_HOME lib tools jarS CLASSPATHSEP S WL_HOME server lib weblogic_sp jars CLASSPATHSEP WL
8. you can now run the imports Click the button Execute imports Note again that these imports can take up to several hours depending on your machine speed and the amount of data you are importing Then click the button Finish If you have launched any imports you will now have to wait until the imports are completed Afterwards you should log out and then log in again as a user for the newly defined account Remember general working as Super User is not supported WE First steps Start import procedure Confirm the start of the import procedure The import of the EC inventory and the Reference substance inventory is atime consuming process They run as background jobs Please do not log out from IUCLID 5 before the import confirmation pop up window appears Note the duration of this import process depends onthe size of the import files It may take a considerable amount of time f _B b B B f_f 8 Finish Cancel Activate imports 3 3 User management The installation of IUCLID 5 is now ready for hand over to whoever will be maintaining the system and whoever will be managing the user accounts The management of user accounts and their roles is described in the UCLID 5 User Manual Individual users can connect to the IUCLID 5 server using Java Web Start technology as described in section 3 1 of this document A convenient way to achieve that is for users to save onto their desktop one of the files downloaded from the defau
9. HSOLE Wik bic del 5 Conmected fo hci Sead it Home logui Preferences Help Ask BEA Vigra A J rere kaiaa ai od Derr auras l Sep oe ee gt T F m Darphin ho perdng charges mit Click instal Applikation Assistant the Rokkia Configuration button to allow others tp edit the mal i ETE eiert ial M ll Locate deployment bo instal and prepare for depioyimernit Select the fie path that represerits he application root directory arches file expiooed archive dimactory or application module descriptor that pou wart to retall Note Only vad file paths are deployed below Ff you cannot find your deployment iis upload your File s andor confirm that your Domain Structure applinahon conkaing the required deploy nent deso pioa dal hoa Errina Location localhost opt bea Servers z i Cites haz Vite Hosty l Mignatable Targets E G Eara Mich races SS p vii n Wirk Manager 5 j i Sirip A Shutdoen Classen carver mar Coker Y Sorvices PER Security Feal Ne 10 Choose Install this deployment as an application and click next 10 IUCLIDS WEBLOGIC SERVER k hea AOMIMIS TRATION COMSOLE i Welcome eliS Corrected fo eko iy Hore Log Gut Preferences Hien Ace 4 Home gt Gummary H Deployments No pending changes exist Click Install Application Assistant the Rekkie Configuration buttar bo allow thors to edit ha al T domat Bas sendid Choose ta
10. IUCLID 5 Guidance and Support Installation Guide for IUCLID 5 Version 5 2 Client Server Architecture Oracle and BEA Weblogic IUCLIDS INTERNATIONAL UNIFORM CHEMICAL INFORMATION DATABASE March 2010 Legal Notice Neither the European Chemicals Agency nor any person acting on behalf of the Agency is responsible for the use which might be made of the following information A wealth of additional information on the European Union is available on the Internet It can be accessed at the addresses http tuclid echa europa eu http echa europa eu http europa eu European Chemicals Agency Reproduction is authorised provided the source is acknowledged IUCLIDS Table of Contents Ws IMME OCG OM setae ev ecceesceea nioreu E snus eetueas ashes E ntact saccade siete sey eee aes esos l o O era E A A E toons sana scess nanos oi ioestcueaeconeeeasonicene 2 2 1 Important technical information about existing IUCLID 5 0 5 1 installations that use client server UCC CNS eae cree conten vat acess acedncenecouetaieancecoetenta tae nanan ccanaunncauvete se acudenenc outers icenneagancsceuseensnancomeuseesosaeat aes 2 2 1 1 Migration of data to IUCLID 5 2 from a previous version cece cece cence eee e eee e ene ee ees eeeeeeneeeensenees 2 2 1 2 Database configuration for running UCLID 5 2 and a previous version at the same time 64 2 ee D E IL I E TOE E E TT A TEE TNE EEE PEDE EE E AEE E ET T E T E 3
11. _HOME server lib weblogic jar and change it to WEBLOGIC_CLASSPATH WL_HOME server lib antlr 2 7 6rcl1 jar CLASSPATHSEP S PATCH _CLASSPATH CLASSPATHSEP S JAVA_HOME lib tools jarS CLASSPATHSEP S WL_HOME server lib weblogic_sp jar SCI NS SAVES IS PS NEERA A Ss r a en hale wirelo ILoOcaue arn 5 Start the newly configured server 2 3 3 Deployment of IUCLID 5 Important IUCLID 5 can only be deployed as a directory The deployment as a war file results an error 1 Rename i5server war to i5server zip 2 Create a new folder called i5server 3 Extract the content of i5server zip into the new folder 4 Configure the database connection settings in the file i5server WEB INF classes server properties 5 Open the page http localhost 7001 console in your web browser 6 Log in as the Weblogic Domain administrator IUCLIDS i WEBLOGIC SERVER a 2 hea ADMINISTRATION CONSOLE Log in to work with the WebLogic Server domain Username fluctid Password t o i Welcome iuclid5 Conr Home View changes and restarts Click the Lock amp Edit button to Domain modify add or delete items in this domain Information and Resources doce amp Edit Helpful Tools Release Configuration gt Configure applications gt Recent Task Status Domain Structure iuclidSsDomain Environment Deployments Services Security Realms Domain Configurations Interoperability
12. a Web Start technology which depends on an installed Java Runtime Environment JRE lf you do not have a JRE installed please contact your system administrator For more information ta Java Web Start please refer to http java sun com products javawebstart Current server status OK Available connections Connect without compression Install IUCLID 5 Client normal with 512MB RAM with 768MB RAM with 1GB RAM Connect with compression Install IUCLID 5 Client normal with 512MB RAM with 768MB RAM with 1GB RAM Administration of installed Web Start applications Start Application Manager 16 IUCLIDS Chapter 3 Initialisation of an installation of IUCLID 5 This section describes the configuration that is required to create a working IUCLID 5 system from the software that has been installed Data must be uploaded into the database user accounts must be created and users must be instructed how to access the system 3 1 Starting IUCLID 5 Connect to the application with a browser by entering the address http lt address of your server gt 8080 i5server The following page is displayed Figure 3 1 The default page for Java Web Start of IUCLID 5 IUCLIDS Welcome to the IUCLID 5 Server IUCLID 5 Version IUCLID5 release 5 2 0 IWC LIDS IUCLIOS release 5 2 0 build of 2010 02 11715 05 3352 Install IUCLID Client Component The server does not feature an interactive web frontend In order to co
13. a central instance of the database software that contains a separate database for each of the instances of IUCLID 5 In all of these cases each instance of IUCLID 5 is independent of all others such that a change to one is not reflected in any other Data from an installation of IUCLID 5 1 can be transferred to an installation of UCLID 5 2 using the Backup plugin in IUCLID 5 1 followed by use of the Restore feature in IUCLID 5 2 Note that it is not possible to transfer data from IUCLID 5 2 to IUCLID 5 1 IUCLIDS 2 1 2 2 If only one computer is available for installation of IUCLID 5 If only one computer is available only one web application server can be run at a once and so only one instance of UCLID 5 can be run at once However in this case it is possible to have two different versions of IUCLID 5 installed on one computer and to switch back and forth between them running only one at a time There are various different ways of doing that What follows is a description of one of the possible methods Before deploying an installation of UCLID 5 2 1 In IUCLID 5 1 install and run the Backup plugin 2 In the Web Application Manager make a note of the name of the path to the application example iuclid51 3 In the Web Application Manager stop the IUCLIDS5 Server 4 In the computer s file system create a directory in which to store un installed web applications example uninstalled_webapps 5 In the computer s file system
14. arger amount of RAM 17 IUCLIDS The client can be run directly from a browser or by first downloading a file from one of the links and running that Depending on your browser settings when you click on one of the links above you will see either a dialogue box or UCLID 5 will run and you will see the login page The browser dialogue asks whether you would like to save a file or run it straight away The choice is yours A convenient way to access UCLID 5 is to download one of the files from the default page save it to the desktop of your local machine used to access IUCLID 5 and give it the IUCLID 5 icon that comes with the installation Double clicking on the icon then launches the UCLID 5 GUI Once you see the login page you are ready to go walk through the First steps wizard as described in the next section 3 2 First steps wizard When you start UCLID 5 for the first time the First steps wizard is run automatically It guides you through the steps required to make a working user account and to upload the data required to use IUCLID 5 in a practical setting The settings that relate to user accounts can also be changed after having run the wizard using the features described in the UCLID 5 User Manual Important This wizard allows a single user account to be created per run This user is in addition to the SuperUser account that comes with the installation It is essential to have at least one user account in addition to
15. btained from the IUCLID Download Website Download Website otherwise this wizard will not complete successfully and you will be forced to log out Please note If your Legal entity information has not already been stored on your computer you should create it on the IUCLID Select your Legal entity file by navigating to the desired file on your computer Select the import file DAIUCLID Leox_Manual i5z 2 5 B 6 8 a 8 l lt Back Next gt Cancel Import legal entity IUCLID 5 Import of the legal entity file completed ox Important You must import at least one Legal entity in order to succeed with this wizard If you have no Legal entity in the IUCLID 5 system the traffic light in the wizard screen will be red The First steps wizard will be automatically launched when you log in to UCLID 5 until a Legal entity has been successfully imported 21 IUCLIDS Figure 3 8 Step 5 of the First steps wizard Import EC Inventory EC inventory import To import the EC inventory select the file for the EC inventory see the IUCLID 5 User Manual The EC Inventory will not be imported immediately The import will start at the end of the First steps wizard Depending on your machine speed and the size of the inventory this import can take some time e g up to half an hour WE First steps Import EC inventory Select the EC inventory file which you previously downloaded The EC inventory is the catalogue of chem
16. by policies provided in the deployment descriptors later Use custom roles and policies other than those in the descriptors Use security ream configuration advanced option Source accessibility How should the source files be made accessible Use the defaults defined by the deployment s targets Recommended selection e Copy this application onto every target for me During deployment the files will be copied automatically to the managed servers to which the application is C 1 will make the deployment accessible from the following location Location Provide the location from where all targets will access this application s files This is often a shared directory You must ensure the apolcation files exist in this location and that each target can reach the location pee Lich Pamba 12 Ensure the settings are as shown below and click Finish 12 IUCLIDS Welcome iuclid5 fa Home Log Out Preferences Help Home gt Summary of Deployments Install Application Assistant Ea tl Review your choices and click Finish Click Finish to complete the deployment This may take a few moments to complete Additional configuration In order to work successfully this application may require additional configuration Do you want to review this application s configuration after completing this assistant C Yes take me to the deplo ment s configuration screen iNo I will review the configuration
17. e tablespace In order to create a new tablespace and user you have to log in as SYS user If you do not know the SYS password ask your Oracle database administrator to create the iuclid5 user and tablespace Start sqlplus and connect to Oracle as a system administrator sqlplus NOLOG SOP Pus Release OURO oa 0s 2 eOocuermenm son Moma si wikis a6 0 5 20 07 Copyright c 1982 2006 Oracle All Rights Reserved SQL gt connect SYS syspassword servername databasename AS SYSDBA Connected Sole IUCLID 5 requires the UTF 8 default character set of the database Execute the following select command in order to check the character set of the current database IUCLIDS checks the characterset of the current database SQL gt select property_value from database_properties where property_name NLS_CHARACTERSET PROPERIY VALUE AL ZUTE The default character set must be AL32UTF8 If your setting is different ask the database administrator to create a new database specifying AL32UTF8 as the default character set Create the iuclid5 user and tablespace in the database It requires the password to be changed These SQL commands create a user and an empty tablespace for IUCLID5 SQL gt create tablespace iuclid5_ts oer eor l o me liveS cs clo gt sjxeeiiy elosolmce Oeil a size 500M autoextend on next 500M maxsize 2000M Tablespace created SQL gt grant create session to iuclid5 identified by CHANGEIT Gra
18. ecause general working within I UCLID 5 with the SuperUser is not supported Only one user can be created per run of the First steps wizard WE First steps Create user account and assign role It is recommended to create a user account before running IUCLIDS The SuperUser account is for user administration only and therefore to run IUCLID 5 we strongly recommend that you create your own user account by selecting the following tick box Assign your role and legal entity and specify the attachments and Import export directories Create user Login name Local Administrator Full name Exam ple Set password Unassigned roles Assigned roles Full access Read only W Set password Set the password of Local Administrator Example last login Never from Nowhere g H LEO for Manual 7 Helsinki f Fin Attachments directory Importjexport directory a _B B 5B 6 G_ B lt Back Next gt Cancel Create Weer e Select the checkbox Create user Fill in all the fields The user needs a Login name for identification during login The Full name is used for proper user identification The Assigned role is needed to administrate the access permissions In a newly installed IUCLID 5 the roles Administrator Full access and Read only are provided by default e Enter a Login name as it should be used for identification during login and the Full name used for proper user identification e Optionally click Set pas
19. hing from IUCLID 5 1 to IUCLID 5 2 consider whether you would like to transfer data from 5 1 to 5 2 If you do want to transfer data whilst you still have IUCLID 5 1 up and running use the Back up plugin to make a copy of your data The copy can then be imported into IUCLID 5 2 using IUCLID 5 2 s built in Restore feature 2 2 Oracle The installation details of the Oracle DBMS is out of scope of this document due to its complexity Please refer to the Oracle documentation or contact the vendor of the software However the installation of sqlplus is described sqlplus 1s the sql client application of Oracle see below It is needed to prepare a database for UCLID 5 if Oracle is not installed on the computer where you are installing IUCLID IUCLIDS 2 2 1 Important technical information about existing IUCLID 5 0 5 1 installations with Oracle Ensure that the UCLID 5 1 1 database user iuclid5 has not been granted with the SELECT ANY TABLE privilege a DBA role or direct SELECT grants to the secondary iuclid5 database user tables but only the privileges shown below in the SQL script If you have granted extra privileges to the user tuclid5 you need to revoke these additional privileges by for example logging in as SYSTEM and entering one or both of the following commands REVOKE CREATE SESSION FROM iuclid5 REVOKE SELECT ANY TABLE FROM iuclid5 The first denies access to database whereas the second denies access to the tables I
20. ical substances listed on the European Inventory of Existing Commercial chemical Substances EINECS the European List of Notified Chemical Substances ELINCS and the No Longer Polymers list NLP published in the Official Journal of the European Communities Each substance listed in the inventory has an EC number and an EC name allocated by the European Commission lf you want to use the EC inventory in your IUCLID 5 installation please download it from the IUCLID Download Website and save the file on your hard disk To import the EC inventory in IUCLID 5 using this wizard please tick the import box Select the import file by navigating to the desired file on your computer Mote It is possible to import the EC inventory at a later stage using the import function from the IUCLID 5 Task panel Import EC inventory Select the import file DAIUCLIDYECinventory_1 1_en i52z B B B MHH lt Back Next gt Cancel EC inventory import Figure 3 9 Step 6 of the First steps wizard Import reference substances Reference substance inventory import Select the file for the Reference substance inventory see the UCLID 5 User Manual The Reference substance inventory will not be imported immediately The import will start at the end of the first steps wizard together with the EC Inventory import Depending on your machine speed and the size of the inventory this bulk operation may take a very long time The Reference substance inventory it
21. ing deployments to be started Click Yes to continue or No fo cancel a Doeve EJ TE 16 Your application is now starting ee eet salinan hetarat Home Logout Preferences Help AMBEA Hore gt Gamar of Deplrpmemis E Start requests have been sent to the selected Deployments Ths page depla a lat of BEE Applicators and standalone application modules that hare been inetalled to tes domain Installed applicatione and modules car b started stopped updated redeployed or deleted from the domain by first selecting the application name and using the controls on this page To install anew application or module for deployment to targets im this damain click fhe install button Dephonnmenits nea a i cse amealiz Showing 1 lofi Previous Neat F Showing 1 10F 1 Previous Heat To start the client application point your browser to http lt host gt 7001 i5server and click Install IUCLID 5 Client in order to download install and start the client via Java Web Start 15 IUCLIDS Figure 2 1 IUCLIDS Welcome to the IUCLID 5 Server IUCLID 5 Version IUCLID5 release 5 2 0 IWC LIDS IU CLIDS release 5 2 0 build of 2010 02 11715 05 3352 Install IUCLID Client Component The server does not feature an interactive web frontend In order to connect to the IUCLIDS database please install the client application locally via the link below This installation will use the Jav
22. later Deployment opt bes Sserver war Name server Staging mode ise the defaults defined by the chosen targets Security Model renga security roles and policies exactly as they are provided in the deployment Target Summary ASkBEA 13 In order to activate your made changes click now on the green button Activate Changes 13 IUCLIDS hea ouinisrearion consoue ir Welcome walis Connected to ucid Soman te Home Log Gut Pominraricars Help AGEA Wiew changes and restarts Heme gt Summary of Beployments Pending changes exist They ae must be activated fo tabe eiert E The deployment has been installed and added to the list of pending changes successfully B ou must also activate the pending changes to commit this and other updates to the active system ee eel m J Summary of Deployments Control Monitoring This page displays a lit of VEE Applications and standalone application modules that have been installed to this domain Security Realms installed applications and modules can be started stopped updated redeployed or deleted from the domain by firat ithaca selecting the application name and using the controls on this page 2 Disqrosties To Petal anew application or module for deployment to targets in fis domain click the Install button How do L E inetall an Enterprise application is ssi Configure an Enterprise application Upda Gece ane opine ott su se
23. lt Java Web Start page The user would launch IUCLID 5 by simply double clicking on the icon on his or her desktop Alternatively the users could be supplied with the URL http lt address of your server gt 8080 15server and instructions on which link to use 24
24. mplete the following screen is shown Background job ended Fa Restore completed successfully OK 20 IUCLIDS Figure 3 6 Step 3 of the First steps wizard Change password If you have not yet changed the default password of the SuperUser to a more secure value than root the traffic light in the wizard screen will be yellow To change the password check the box Change SuperUser password enter the old password root and then enter the new password After confirming the password click the button Next WE First steps Change the SuperUser password For security reasons it is recommended to change the SuperUser s password g it is not secure as it is now a Change SuperUser password Old password New password Confirm new password We strongly recommend that you change the SuperUser password since each IUCLID 5 installation uses an identical default password To change your password please tick the checkbox g C n a i a a E a a E Cancel Change password Figure 3 7 Step 4 of the First steps wizard Import Legal Entity To import a Legal entity see the IUCLID 5 User Manual select its LEOX file by browsing to the file The browsing is accessed by clicking on the folder icon to the right of the field Select the import file Click the Next button The Legal entity is imported immediately ME First steps Import legal entity In order to run IUCLID 5 you have to import your Legal entity o
25. n order to successfully install I UCLID 5 2 follow the procedure below 1 Logon to the Oracle database as SYSTEM or SYSDBA 2 Create the new tablespaces and user iuclid52 as shown in the script below 3 Test the user connection with the command connect tuclid52 iuclid52 10 1 14 27 IUCLIDS5 4 Go to the Tomcat Web Application Manager Select iSserver and select undeploy then OK 5 Stop the Tomcat application server 6 Drop the new war file in to the folder webapps 7 Start the application server This deploys the application 8 Stop the application server 9 Change the connection string in the file Tomcat x x webapps i5server WEB INF classes server properties 10 Start the application server 11 Log in to the application using the account with name SuperUser and password root 12 Import the backup you made with the backup plugin tool The following SQL script creates a user and an empty tablespace for I UCLIDS 2 CREATE tablespace Iuclid o2 ts darad Tie e Er e a E e a a line jociclas size 500M autoextend ON next 500M maxs ize 2000M grant CREATE SeSSIon TO Rel tds 2 Genin LOG Br Truc ids 2 grant CREATE TABLE IG sie ae S 2 7 grant PEATE WILEY IO sve lies 27 grant CREATE sequence TO iuclid52 ALTER USER Tule S24 gueota unlimited ON mielliel S21 ALTER USER auela gS2 DEFAULI tablespace 10Clid o2 to IUCLIDS 2 2 2 Installing sqlplus If Oracle is not installed on the computer where you are in
26. nnect to the IUCLIDS database please install the client application locally via the link below This installation will use the Java Web Start technology which depends on an installed Java Runtime Environment JRE lf you do not have a JRE installed please contact your system administrator For more information to Java Web Start please refer to http java sun com products javawebstart Current server status OK Available connections Connect without compression Install IUCLID 5 Client normal with 512MB RAM with 768MB RAM with 1GB RAM Connect with compression Install IUCLID 5 Client normal with 512MB RAM with 768MB RAM with 1GB RAM Administration of installed Web Start applications Start Application Manager The page shown above page contains links that use Java Web Start technology to start a client that connects to the IUCLID server and displays IUCLID 5 s graphical user interface GUI on the client machine In the example shown above the link under the text UCLID 5 Client with 1GB RAM has already been followed The difference between the links in the above page is that each link passes different parameters to the UCLID 5 server The options included are for varying amounts of memory to be allocated to UCLID 5 and for different types of data compression to be employed in the connection to the server If IUCLID 5 runs slower than you would like and you have the available memory select a link for a l
27. nt succeeded SOL grant Create table to iuclids Grant succeeded S0L grant Croate viow tO ruclido Grant succeeded SQL gt grant create sequence to iuclidd Grant succeeded SOLzalrer user Tue hra Ss quota unlimited on auc le Sts User altered SOL gt zalrer user iuclido default tablespace iuclido ts User altered SON Disconnect from the database SQL gt disconnect Disconnected from Oracle Database 10g Release 10 1 0 3 0 64bit Production SOL 2 2 4 Checking the iuclid5 database user Connect to the database using the username and password of iuclid5 in order to verify that the database server accepts a connection made by iuclid5 user IUCLIDS SQL gt connect iuclid5 i5password servername databasename Connected SQL gt exit Warning STOP Do not start IUCLID 5 until you successfully connect to Oracle using sqlpus from the server hosting IUCLID 5 web application 2 2 5 FAQ If you want to delete the previously created user and tablespace connect to Oracle as sysdba and execute the drop user and drop tablespace commands SQL gt connect SYS syspassword servername databasename AS SYSDBA Connected SQL gt drop user iuclid5 cascade User dropped SQL gt drop tablespace iuclid5 ts including contents and datafiles Tablespace dropped SO 2 3 BEA Weblogic server 2 3 1 Prerequisites This document does not cover the installation of BEA Weblogic server itself In case you need support with
28. rgeting style Tagen ane the carvers clusters and virtual hosts on which thie dagloy ment will rum There are seneral wars you car target an application Homai Se install this deployment as an application ckSDomain EEren The application and amp components will be targeted to the same locations This is he most common usage Dinky miit 7 Serviogs Install this depoyment as a library Security Reali Interoperability Applicaton libraries are deployments that are available for other deployments to share Libraries should be E Diago available oni all of the targets running their referencing apple atori How do I ies l E a aval cant a Start and stop a deplored 11 Ensure the settings are as shown below and note the name you specified in the first field name Via this name the web application will be accessible later http lt host gt 7001 lt web app name gt then click Next 1 IUCLIDS Welcome iuclds Connected to iuclid5SDomain ie Home Log Out Preferences Helo AskBEA Home gt Summary of Deployments Install Application Assistant Optional Settings You can modify these settings or accept the defaults General What do you want to name this deployment Name Security What security model do you want to use with this application Use the security roles and policies exactly as they are provided in the deployment descriptors Customize the security roles used
29. s wizard then proceeds Each page of the wizard is described in a figure below 18 IUCLIDS Figure 3 2 Step 1 of the First steps wizard Introduction The wizard presents some useful information There are no actions other than to read the information Click the Next button WE First steps Welcome to IUCLID 5 Welcome to IUCLID 5 IUCLID 5 International Uniform ChemicaL Information Database is a software application to capture store maintain and exchange data on intrinsic and hazard properties of chemical substances This wizard will guide you through the different steps involved to setting up your application so that you can use it immediately We recommend that you follow the given instructions Change the SuperUser password not mandatory but recommended to increase security Import your Legal Entity information mandatory for running the application Import the EC inventory not mandatory but strongly recommended Import the Reference substance inventory not mandatory but recommended for users with gt 100 substances Create a user account and define roles strongly recommended IMPORTANT Before running this wizard please make sure your Legal Entity information has been stored on your PC information available at the IUCLID Download Website gt Bee eee8 in Introduction Figure 3 3 Step 2 of the First steps wizard Init mode New installation To initialise a new database select the button New Ins
30. self can take up to several hours to import ME First steps Import reference substance inventory Select areference substance inventory to import into IUCLIDS The reference substance inventory is a catalogue of approximately 70 000 reference substances A reference substance is used for the identification of substances and contains information such as CAS Numbers IUPAC names SMILES and InChl notations structural formula and the EC inventory information The reference substance inventory is publicly available and can be downloaded entirely or partially lf you want to use the reference substance inventory in your IUCLID 5 installation please download it from the IUCLID Download Website and save the file on your hard disk To import the reference substance inventory in IUCLID 5 using this wizard please tick the import box Select the import file by navigating to the desired file on your computer Note It is possible to import the reference substance inventory at a later stage using the import function from the IUCLID 5 Task panel Import reference substance inventory Select the import file DAIUCLID Referencesubstance i5z a _B B 5B 6 G_ B lt Back Next gt Cancel Reference substance inventory import 22 IUCLIDS Figure 3 10 Step 6 of the First steps wizard Import reference substances Create a new user account and define its user access rights by assigning it a role It is essential to create a new user b
31. ssible to transfer data from IUCLID 5 2 to IUCLID 5 1 2 1 2 Database configuration for running IUCLID 5 2 anda previous version at the same time If you already have a previous version of IUCLID 5 it is recommended to keep it for the time being It can be deleted in the future when you are absolutely sure that it is no longer needed What follows is some information and advice as to how you can manage more than one version of IUCLID 5 As stated above each installation of UCLID 5 must have its own database and its own web application server A new database must be created for IUCLID 5 2 because the structure of the database differs from that of previous versions This requirement can be met in a variety of different ways The following sub sections describe some common sets of circumstances The database for IUCLID 5 2 can be run on the same instance of the database software as a previous version of IUCLID 5 however it must have a unique name within that instance of the database software When IUCLID 5 2 is run for the first time on an empty database it will automatically create all the correct tables 2 1 2 1 If more than one computer is available for installation of IUCLID 5 Each instance of UCLID 5 that is running in an application server is installed on a separate computer and has its own database In this case the instances of IUCLID 5 can point to databases that are either running on the same computers as the respective IUCLID 5s or on
32. stalling IUCLID then you need to install sqlplus the sql client application of Oracle Download instantclient basic and instantclient sglplus packages from http www oracle com technology software tech oci instantclient index html Install the packages using rpm or unzip the packages if you have a 64 bit platform replace the version according to the downloaded files rpm iv oracle instantclient basic 10 2 0 3 1 i386 rpm oracle instantclient sqlplus 10 2 0 3 1 1386 rpm Preparing packages for installation Craehe tact amice some bas he 022 Ooi Oracle wWisteancelucn u seqlpliuis 0 22 20s H Set the environment variable LD_LIBRARY_PATH to the lib directory of Oracle export LD_LIBRARY_PATH usr lib oracle 10 2 0 3 client lib H Test the installation of sqlplus without connecting it to a database If the SQL prompt is displayed you have successfully installed the application Close the program with the exit command Note i If an error message is displayed when you start sqlplus check that the environment variable LD_LIBRARY_PATH points to the correct directory sqlplus NOLOG SOLVE lus Release T0 2 0 5 US Prou tion on Mon May IZ ik 56 2035 2007 Copyright c 19822 2006 Oracle All Raghts Reserved SQL gt exit For more information on Instant Client see the official Instant Client site at http www oracle com technology tech oci instantclient instantclient html 2 2 3 Preparing th
33. sword and define a password e Click and highlight a role in the list of unassigned roles and assign it to the user by clicking the Right arrow Assigning a Role is needed to administrate the access permissions in a newly installed UCLID 5 the roles Administrator Full access and Read only are available by default Tip It is recommended to create a user with the Administrator Role regardless of whether a stand alone or a distributed version of IUCLID 5 is set up Once a user has been created the UCLID 5 administrator in case of a distributed version can define different other user s and assign different role s to them see the IUCLID 5 User Manual 23 IUCLIDS e Assign a Legal entity normally the Legal entity imported in the third step of this wizard by clicking the green plus button and performing a search for the desired Legal entity In the Query field Legal entity name enter the name of the desired Legal entity or an asterisk as wildcard and click the Search button In the Query results list click the desired entry and then click the Assign button e Optionally select default attachment and import export directories These settings can be changed at a later stage as described in the UCLID 5 User Manual e Click the Next button Figure 3 11 Step 8 of the First steps wizard Start import procedure If you have selected an EC Inventory and or Reference substances inventory file s during the wizard steps
34. tallationas shown below and continue to the next step WE First steps Define the initialisation mode Initialisation mode New installation ie Restore from backup C n a t a a a E a a E Finisk Cancel Init mode 19 IUCLIDS Figure 3 4 Step 2 of the First steps wizard Init mode Restore from backup To restore from a backup of a previous version of IUCLID 5 select the button Restore from backup then enter the directory containing the backup files as shown in the example below WE First steps Define the initialisation mode initialisation mode O Newinstallation Restore from backup Location to restore from DAIUCLID backup a a 8 0 8 8 0 0 i Init mode Click Next The wizard jumps to its last step where the importation of data is started as shown below Figure 3 5 Restoration from a back up Step 8 Activate imports ME First steps Start import procedure Confirm the start of the import procedure The import of the EC inventory and the Reference substance inventory is atime consuming process They run as background jobs Please do not log out from IUCLID 5 before the import confirmation pop up window appears Mote the duration of this import process depends onthe size of the import files It may take a considerable amount of time 2 B H 8 6 G B Next gt f Einish Cancel Activate imports The import may take some Click Finish When the restoration is co
Download Pdf Manuals
Related Search