OfficeScan 11 Critical Patches 6496

Install patches/hotfixes in chronological order.  When installing CP 6496, the build number will not be updated however, you can verify that the patch completed successfully by checking the PCCSRV\Backup folder.

Please make sure to take a snapshot of your machine before applying the patch and if you are using SQL make a backup of SQL DB too.

Also on your console go to Agent -> Agent Management and select OfficeScan Server on the left top and
Right Click -> Setting -> Privileges and Other Settings -> Other Setting Tab and check the box for “Agent can update components but not upgrade the program or deploy hotfix”
This will block ALL your agents from upgrading the program while you apply patches. Agents can always jump straight to the latest patch level once you let them upgrade Program by unchecked the setting.
This is very important because you don’t want all your agents to start upgrading their agent program right away as this might cause performance issues.

Advertisements

Citrix User/Device License

Check License In Use (Available)
Total (44)

License Administration Console
http://localhost:8082/systeminfo?vendor=CITRIX&licenseTab=&selected=

User Name: enter username
Password: enter password
Dashboard->Concurrent->Citrix XenDesktop Enterprise|User/Device

————————————————————————-

Manual delete User/Device License.

Command prompt:

List Users (User/Device):
C:\Program Files (x86)\Citrix\Licensing\LS>udadmin -list

Delete user:
C:\Program Files (x86)\Citrix\Licensing\LS>udadmin -f XDT_ENT_UD -user JohnDoe -delete

How to upgrade to EPPM 17.12

How to upgrade to EPPM 17.12
————————————-

Full upgrade, installation and configuration instructions are located here: https://docs.oracle.com/en/industries/construction-engineering/
Tested Configurations for 17.12: http://docs.oracle.com/cd/E59283_01/EPPM/17/eppm_17_12_tested_config.xls

Basic overview: Below you will install a new JDK and new Weblogic prior to upgrading the EPPM installation:

A. Download and install Oracle JDK 1.8.0_151 from the Java archive: (SE 8 link) http://www.oracle.com/technetwork/java/archive-139210.html . JDK is the Java Development Kit.

B. Download and install Weblogic 12.2.1.2.0 :

Download:

To find any Oracle media download, you can go here: https://edelivery.oracle.com/
1. Sign in or register
2. Start Typing “Weblogic” and scroll down to the “Releases”
4. Select the version you would like from the list and select a platform – 12.2.1.2.0 and Windows 64 bit (or your OS)
5. Accept the Terms
6. Click the blue link for “V779119-01.zip” Oracle Fusion Middleware 12c (12.2.1.2.0) WebLogic Server and Coherence to download it directly.
7. Locate your download and UNZIP to get to the installation files

Install:

1. Open up windows explorer, and navigate to the JDK location (example C:\Program Files\Java\JDK1.8.0_131\bin) Copy the address to this location
2. Open up a command prompt, and type

cd C:\Program Files\Java\JDK1.8.0_131\bin

3. You should now be in the bin directory. Type the following but do not hit return:

java -jar

4. Back in windows explorer, navigate to the location you downloaded and unzipped the WLS file (example, C:\downloads\V779119-01\fmw_12.2.1.2.0_wls.jar). Select the fmw_12.2.1.2.0_wls.jar file, CTRL+SHIFT+RIGHT CLICK and select “Copy As Path”
5. Right click and paste this copied location next to the -jar in the command prompt.

It should look similar to this:

C:\Program Files\Java\JDK1.8.0_101\bin>java -jar “C:\downloads\V779119-01\fmw_12.1.3.0.0_wls.jar”

Hit enter to launch the weblogic installation wizard. Go through the wizard with defaults. Make sure to configure and launch the Admin server at the end of the wizard.

C: Download and unzip the EPPM files:

To find any Oracle media download, you can go here: https://edelivery.oracle.com/
1. Sign in or register
2. Start Typing “P6”
4. Select the version you would like from the list and select a platform. Product: Primavera P6 Enterprise Project Portfolio Management
5. Accept the Terms
6. Download the files
7. Locate your download and UNZIP to get to the installation files

D. Locate and Launch the EPPM setup file: Example location: “C:\downloads\V789759-01\P6_R162\Disk1\install\setup.exe” – Install/Upgrade

E. Once you go through the setup wizard the eppmconfig.bat should launch automatically. This is where the database will be upgraded and weblogic will be configured to run with EPPM. At the end of the eppmconfig.bat wizard you should see all the links to your various P6 web pages. eppmconfig.cmd

NOTE: If the eppmconfig.bat wizard fails to upgrade the database, cancel, then run dbsetup.bat from the new installation media to upgrade the database separately. Once it is upgraded, find eppmconfig.bat and run it again to connect to the existing database.

Network Credentials Required DC Demotion

You are demoting Domain Control and you received this Network Credentials message.  “The operation failed because: The attempt at remote directory server xxxx to remove directory server xxxx was unsuccessful. Access denied.”

You login as Domain Admin/Schema Admin/Enterprise Admin account won’t work due to the object is protected from accidental deletion.

Resolution:

Active Directory Sites and Services, expand the domain controller you wanted to demote, right click NTDS Settngs and select Properties, Object tab, then un-check Protect object from accidental deletion.

P6 EPPM Upgrade (from 16.x to 17.12) – PART 1of2

Perform a database-only upgrade on a copy of production database to ensure the upgrade goes smoothly.

  1.  Using SQL Server Management Studio, make a backup of your production database and call it P6.bak and save it on a different location.
  2. Create a blank database container.

 

3.  Call database name: P6-TEST and click OK.

4.  Restore database.

 

5. Source for restore:  From device and check Restore box.

 

6. First, check these options: ‘WITH REPLACE’ and ‘WITH KEEP_REPLICATION’.  Second, on PMDB_dat and PMDB_log change names to these PMDB_dat_TEST.MDF and PMDB_log_TEST.ldf.  See next snapshot before clicking OK.

https://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp

7.  Do the same name change fs_file1 to PMDB_fs_doc_TEST.mdf and then click OK.

 

8.  Restoring database.

 

9.  Restore of database ‘P6-TEST’ completed successfully.  IF YOU DIDN’T GET ANY ERROR AT THIS POINT, THIS MEANS YOUR DATABASE UPGRADE IS SUCCESSFUL!  NOW YOU CAN PERFORM THE SAME PROCEDURE TO YOUR PRODUCTION DATABASE.

 

Location of the Test MDF and LDF files.  These files will go away once you delete the P6-TEST database in SQL Management Studio.