Automic Workload Automation

  • 1.  AE upgrade form 11.2 to 12

    Posted Dec 17, 2018 03:41 AM

    hello, we are planning to upgrade our ae 11.2 to 12. unfortunately due to the lack of resources, we only have 1 host for our AE. the documentation suggest that in order for the ZDU to work properly, we need to have a separate instance either on another host or on the same host. i keen on having a separate instance on the same host. however, i don't want to

    install it again from the scratch (it was installed by an employee from automic 3 yrs ago) since i don't wanna mess with it.

     

    would it be possible to just copy the whole AE directory, paste it somewhere and just change the config files to make another instance? by the way, our ae runs on top of a solaris 11 O.S. or do you have any suggestions? hope you can help me out on this. thanks



  • 2.  Re: AE upgrade form 11.2 to 12

    Posted Dec 18, 2018 03:40 AM

    Hi
    I am currently planning and testing our ZDU from V11.2.3 to V11.2.9

     

    Basically: ZDU needs a lot of preparation and planning time (especially the service manager issue)
    If you are limited in time and have a maintenance window I would recommend performing a common upgrade.

     

    Regarding your Question- Yes its possible to copy-paste your AE directory elsewhere and change the INI files.

     

    Advice: If you are not well-experienced I would recommend asking an Automic consultant for assistance during ZDU, its sometimes a bit tricky :-)


    cheers, Wolfgang

     

    PS: we will do the update V11.2 => V12.X the common way without ZDU



  • 3.  Re: AE upgrade form 11.2 to 12

    Posted Dec 29, 2018 11:18 PM

    thanks. but we have deferred the upgrade as our priority is to transfer our ae server and ae db server to cloud. actually we have already copied the 

    whole AE directory to the cloud and export/import the db as well to the cloud but i've encountered problem when starting the agents. i have also changed all the INI files to point to the imported cloud db. pls do help me.

     

    20181230/033144.500 - U00003400 Server 'AUTOMIC#CP' version '11.2.1+build.412' (changelist '7272039') started.
    20181230/033144.500 - U00003327 Build Date: '2016-02-25', '13:56:07'
    20181230/033144.500 - U00003433 Server was started with INI file '/u01/app/uc4/Automation.Platform/ServiceManager/bin/../../AutomationEngine/bin/ucsrv.ini'.
    20181230/033144.500 - ----------------------------------------------------------------------------------------------------
    20181230/033144.500 - ;#################################################################
    20181230/033144.500 - ; please make path definitions with trailing backslash #
    20181230/033144.500 - ;#################################################################
    20181230/033144.500 -
    20181230/033144.500 - [GLOBAL]
    20181230/033144.500 - SYSTEM=AUTOMIC
    20181230/033144.500 -
    20181230/033144.500 - LANGUAGE=(E,D)
    20181230/033144.500 - LOGGING=../temp/$$srv_log_*_##.txt
    20181230/033144.500 - LOGCOUNT=10
    20181230/033144.500 - HELPLIB=uc.msl
    20181230/033144.500 - HELPCACHE=ALL
    20181230/033144.500 - STARTMODE=NORMAL
    20181230/033144.500 - SNMP=0
    20181230/033144.500 - NODENAME=UC4_1
    20181230/033144.500 - PRIMARYMODE=1
    20181230/033144.500 - EXCEPTION=1
    20181230/033144.500 -
    20181230/033144.500 - [CPMsgTypes]
    20181230/033144.500 - SRVQUERY=0
    20181230/033144.500 -
    20181230/033144.500 - [CACHE]
    20181230/033144.500 - SCRIPT=3000000
    20181230/033144.500 - VARA=3000000
    20181230/033144.500 - MQMEM=3000000
    20181230/033144.500 -
    20181230/033144.500 - [TRACE]
    20181230/033144.500 - FILE=../temp/$$srv_trc_*_##.txt
    20181230/033144.500 - TRCCOUNT=10
    20181230/033144.500 - TCP/IP=0
    20181230/033144.500 - DATABASE=0
    20181230/033144.500 - TRC03=0
    20181230/033144.500 - SRCALL=0
    20181230/033144.500 - MEMIO=0
    20181230/033144.500 - JCL=0
    20181230/033144.500 - MEMSV=0
    20181230/033144.500 - SNMP=0
    20181230/033144.500 - ZUXML=0
    20181230/033144.500 - CACHE=0
    20181230/033144.500 - TRC11=0
    20181230/033144.501 - UCDS=0
    20181230/033144.501 - XSCRIPT=0
    20181230/033144.501 - UC4GLOBAL=0
    20181230/033144.501 - TRC15=0
    20181230/033144.501 - TRC16=0
    20181230/033144.501 -
    20181230/033144.501 - [TCP/IP]
    20181230/033144.501 - ; Primary Port for WP
    20181230/033144.501 - PWPPORT=2270
    20181230/033144.501 -
    20181230/033144.501 - ; the logging will be written in the database in this interval
    20181230/033144.501 - REPORT=20
    20181230/033144.501 - ; Reconnectintervall from WP's to CP's, or WP's to P-WP
    20181230/033144.501 - CONNECT=120
    20181230/033144.501 - CHIFFRE=1
    20181230/033144.501 - ; Try count and wait time for Primary
    20181230/033144.501 - RETRYWAIT=(3,10)
    20181230/033144.501 - RETRYWAITPWP=(3,30)
    20181230/033144.501 - MAXMSGSIZE=31457280
    20181230/033144.501 - ; TCP_NODELAY=0
    20181230/033144.501 - ; TCP_KEEPALIVE_TIME=0
    20181230/033144.501 - ; SENDBUFFERSIZE=0
    20181230/033144.501 - ; RECVBUFFERSIZE=0
    20181230/033144.501 -
    20181230/033144.501 - [PORTS]
    20181230/033144.501 - CP1=2217
    20181230/033144.501 - CP2=2218
    20181230/033144.501 - CP3=2219
    20181230/033144.501 - CP4=2220
    20181230/033144.501 - CP5=2221
    20181230/033144.501 - WP1=2271
    20181230/033144.501 - WP2=2272
    20181230/033144.501 - WP3=2273
    20181230/033144.501 - WP4=2274
    20181230/033144.501 - WP5=2275
    20181230/033144.501 - WP6=2276
    20181230/033144.501 - WP7=2277
    20181230/033144.501 - WP8=2278
    20181230/033144.501 - WP9=2279
    20181230/033144.501 -
    20181230/033144.501 - [DB_SERVICE]
    20181230/033144.501 - NAME=DbService
    20181230/033144.501 - CP=
    20181230/033144.501 - KEYSTORE=KStore.ini
    20181230/033144.501 - INITIALPACKAGE=
    20181230/033144.501 - RETENTION_TIME=1800
    20181230/033144.501 - CONNECT=60
    20181230/033144.501 - OPTIMIZE=1
    20181230/033144.501 - RETRY=10
    20181230/033144.501 - TCP/IP=0
    20181230/033144.501 -
    20181230/033144.501 - [ODBC]
    20181230/033144.501 - ; ODBCVAR xxxxxxxx
    20181230/033144.501 - ; |||||||+ TYPE OF SQL-SYNTAX N=SQL-SERVER O=ORACLE D=DB2
    20181230/033144.501 - ; ||||||+- R=compress messages and local memory
    20181230/033144.501 - ; |||||+-- O = with userid, N = without userid
    20181230/033144.501 - ; ||||+--- I=OCI/CLI N=ODBC
    20181230/033144.501 - ; |||+---- not used
    20181230/033144.501 - ; ||+----- J = compare fieldnames case-insensitiv (in case of ORACLE !!)
    20181230/033144.501 - ; |+------ D = DB-Disconnect after 1000 commits (perhaps in case of Oracle memory leaks)
    20181230/033144.501 - ; +------- S = use Server-Cursor (SQL-SERVER)
    20181230/033144.501 - ;
    20181230/033144.501 - ; NNJNIORO for Oracle 10.x with OCI (Oracle Call Interface)
    20181230/033144.501 - ; NNJNIORD for DB2/NT/UNIX with CLI (Call Level Interface)
    20181230/033144.501 - ;
    20181230/033144.501 - ; Oracle with OCI
    20181230/033144.501 - SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=//mkccbprddb.cprddba1.mkdcnet.oraclevcn.com:1521/MKPRODDB.cprddba1.mkdcnet.oraclevcn.com;UID=automic;PWD=???;SP=NLS_LANGUAGE=AMERICAN,NLS_TERRITORY=AMERICA,CODESET=WE8MSWIN1252,NLS_LENGTH_SEMANTICS=CHAR
    20181230/033144.501 - ; DB2 with CLI
    20181230/033144.501 - ;SQLDRIVERCONNECT=ODBCVAR=NNJNIORD,DSN=UC4;UID=uc4;PWD=???
    20181230/033144.501 - ----------------------------------------------------------------------------------------------------
    20181230/033144.502 - U00003492 Server has been started on Host 'mkdcuc4prdl02' ('10.200.100.6') with process ID '6279'.
    20181230/033144.502 - U00003395 Operating system 'Linux' version '4.1.12-124.22.2.el6uek.x86_64' (build information '2016-02-25 13:56:07 - l64a1').
    20181230/033144.502 - U00003328 The computer has '2' CPUs and '14778M' memory.
    20181230/033144.505 - core file size (blocks, -c) 0
    20181230/033144.505 - data seg size (kbytes, -d) unlimited
    20181230/033144.505 - scheduling priority (-e) 0
    20181230/033144.505 - file size (blocks, -f) unlimited
    20181230/033144.505 - pending signals (-i) 58861
    20181230/033144.505 - max locked memory (kbytes, -l) 64
    20181230/033144.505 - max memory size (kbytes, -m) unlimited
    20181230/033144.505 - open files (-n) 1024
    20181230/033144.505 - pipe size (512 bytes, -p) 8
    20181230/033144.505 - POSIX message queues (bytes, -q) 819200
    20181230/033144.505 - real-time priority (-r) 0
    20181230/033144.505 - stack size (kbytes, -s) 8192
    20181230/033144.505 - cpu time (seconds, -t) unlimited
    20181230/033144.505 - max user processes (-u) 58861
    20181230/033144.505 - virtual memory (kbytes, -v) unlimited
    20181230/033144.505 - file locks (-x) unlimited
    20181230/033144.505 - U00003409 'UC_PCX' memory successfully allocated (address = '0x16f2290', length = '8192/8k').
    20181230/033144.505 - U00003409 'UC_IO' memory successfully allocated (address = '0x1afb740', length = '65536/64k').
    20181230/033144.505 - U00003409 'UC_MQ' memory successfully allocated (address = '0x1b0b750', length = '65536/64k').
    20181230/033144.509 - U00003486 ListenSocket with port number '2217' successfully created.
    20181230/033144.509 - U00003488 Server 'CP' was started as instance '1'.
    20181230/033144.551 - U00003545 UCUDB: Opening database ...
    20181230/033144.551 - U00029112 UCUDB - Length of the DB-History area: 100
    20181230/033144.602 - U00029114 UCUDB - ALTER SESSION: NLS_LANGUAGE=AMERICAN
    20181230/033144.602 - U00029114 UCUDB - ALTER SESSION: NLS_TERRITORY=AMERICA
    20181230/033144.603 - U00029114 UCUDB - ALTER SESSION: NLS_LENGTH_SEMANTICS=CHA
    20181230/033144.603 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 1b8c770 DB-HDBC: 0
    20181230/033144.603 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
    20181230/033144.603 - U00003592 UCUDB - Status: '' Native error: '12705' Msg: 'ORA-12705: Cannot access NLS data files or invalid environment specified'
    20181230/033144.603 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-12705: Cannot access NLS data files or invalid environment specified'
    20181230/033144.603 - U00003594 UCUDB Ret: '3590' opcode: 'OPEN' SQL Stmnt: 'ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHA'
    20181230/033144.603 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-12705: Cannot access NLS data files or invalid environment specified'
    20181230/033144.603 - U00003410 Server 'AUTOMIC#CP001' version '11.2.1+build.412' ended abnormally.

     

     

    thanks