PA Checklist OBIEE v6.1

Assessments OBIEE Checklist v6.
1 controlled Summary: Customer Details:

Customer Go-Live Date PA Project ID
Testing Details:
Testing Start Date Testing End Date
Testing Results Summary:

Total Checklist Tasks Completed Total Checklist Tasks
Assessments OBIEE Checklist v6.1 Production Instructions:

Checklist Details:
Assessments OBIEE Checklist v6.1 Production Instructions:
Checklist Details: All Tabs are completed for a PA or PMP. For PMP specific tasks, a label will be attached to the item to indicate that it is only for PMP
Assessments OBIEE Checklist v6.1 controlled Summary:

Start Date: End Date: Completed By (firstname.lastname): Single Node or Multi-Node: Instance Name (SID): Application Tier Server Node Name(s), if applicable:
Database Tier Server Node Name(s), if applicable:
he ck N list ju OT Ta st E: sk if ic If s C a "A tio "N/ om dd n i A" ple iti s r or ted on eq "N ? a l ui r o St C ed ", om u ar tD m nd en er at e ts "
URL - Login and Password check OBIEE : BI Publisher : Informatica: WebLogic/AS: OID:
Select One
En d
at e
OBIEE Answer Checks Answers Link - click on Answers link and verify resulting screen is start page for answers.
Select One
OBIEE Dashboard Checks Dashboard Link - click on Dashboard link, verify that 'My Dashboard' comes up.
Select One
OBIEE Webserver (SAW) checks SAW Service SAW Service Port - login to server where SAW is installed. Enter command netstat -a|grep [port number] where port is specified in Ports Standard for Siebel document, typically port = 30076 where X = 7 for Dev, 5 for Test, and 0 for Prod. Verify that 'Listen' is returned.
Select One
OBIEE Server Checks SAS Service SAS Service Port - login to server where SAS is installed. Enter Command netstat -a|grep [port number] where port is specified in Ports Standard for Siebel document, typically port = 30073 where X = 7 for Dev, 5 for Test, and 0 for Prod. Verify that 'Listen' is returned.
Select One
OBIEE Server Checks Creating an Additional Administration User : Log into to the Analytics Administration and open the rpd in online mode. Add a new user called "custadmin" with a correspoing password. Assign the user to the Administrators Group. And then save the setting. Then Try to Log in the Application using custadmin/password and confirm whether you are able to log into the Application.
Select One
OBIEE Server Checks Creating the Web Group Account : Now Log into the Application as Administrator and then select Administration link from Right corner and in the Catalog Group and user Administration add user custadmin to the Presentation Server Adminsitrator catalog group. Then login as custadmin.. and set the User Preference to HCM-Workforoce Profile dashboard and log off. Again login as custadmin and confirm whether you are able to see the same as like the Administrators Login.
Select One
Informatica Checks Informatica Server is running, port login to server where Informatica Server is installed, enter command netstat -a|grep [port number] where port is specified in Ports Standard for Siebel document, typically 30X96 where X = 7 for Dev, 5 for Test, and 0 for Prod. Verify that 'Listen' is returned
Select One
Informatica is running, port DAC ServerRepository Check DAC Server is running, port Login to server where DAC Server is installed Enter command netstat -a|grep [port number] where port is specified in Ports Standard for Siebel document, typically 30X79, where X = 7 for Dev, 5 for Test, and 0 for Prod. Verify that 'Listen' is returned.
Select One
10 Confirm that monitoring is in place for all components
Select One
11 Check ArchiveLog Mode for the databases Login to the production database server as shown in 'Siebel Operations Guide' and start SQLPlus. At the prompt enter 'archive log list.' Verify that the parameter 'Database log mode' is set to 'Archive Mode' and 'Automatic archival' is set to 'Enabled.' Do the same for the Analytics production database (if applicable) as shown in the Siebel Operations Guide. 12 Check OLAP databases are Unicode login to the database and pbrun as 'or' user per instructions in Ops Guide. Run SQLPLUS. Select * from NLS_DATABASE_PARAMETERS; Note that NLS_CHARACTERSET is ALT32UTF8 only
Select One
Select One
13 OLAP Database Check Login to the server where the OLAP database is installed Verify that the database is running and the Listener status is 'UP' For database, login to a MT server and pbrun ohsdba -u sb(instancename] where [instancename] is the name of the database instance. Enter tnsping [instancename] Verify that OK shows up in the last line returned followed by a connect time, e.g. OK (10 msec) For listener, enter netstat -a|grep [port number] where port number is specified in Ports Standard for Siebel document, typically 30010 for prod. Verify that 'Listen' is returned
Select One
14 Other OLAP DB Checks: Check that Data and Index tablespace files are separate Login to the server where the OLAP database is installed cd <Instance Name> cd oradata cd data01. Also look at data02, data03. Verify that data and index .dbf files are separate.
Select One
15 Other OLAP DB Checks: Check that 'Optimizer_Mode' is set to 'CHOOSE' Login to the server where the OLAP database is installed. Launch SQL Plus and enter: show parameter Optimizer_Mode Verify that the value is 'CHOOSE'
Select One
16 OLAP DB Size check Check the size of data files, temp space and Undo Tablespace. Make sure 20 GB of space is allocated to the data files so that ETL does not fail while loading the data. Also allocate sufficient space to TEMP tablespace.
Select One
17 Other OLAP DB Parameter Checks open_cursors 2000 session_cached_cursors 1000 disk_asynch_io FALSE parallel_max_servers For 8 core - start with 16, For 4 core - start with 12 sga_target 0 pga_aggregate_target For 32 GB, it can be 8 GB. For 16 GB, it can be 4 GB filesystemio_options directio _system_trig_enabled TRUE db_cache_size >= 6GB shared_pool_size >=2GB shared_pool_reserved_size 10%-20% shared_pool_size log_buffer >=14M undo_retention 187200 cursor_space_for_time FALSE query_rewrite_enabled TRUE query_rewrite_integrity TRUSTED _kks_use_mutex_pin TRUE optimizer_secure_view_merging FALSE optimizer_mode ALL_ROWS _b_tree_bitmap_plans FALSE _fast_full_scan_enabled FALSE _like_with_bind_as_equality TRUE db_file_multiblock_read_count 32
Select One
18 PMP only - OBIEE Check the code tree and clean logs and other folders for the huge files, which are not needed. Files in questions are .srf, .rpd, .webcat etc. During each migration, customer/Operations copy these files and over the time, count of these files grows and consume disk space.
Select One
19 PMP only - OBIEE Check the latest fix pack for BI and see if any critical bug fixes being done. Make a recommendation to customer.
Select One
20 PMP only - OBIEE Check if CPU patches need to be applied. CPU patches can be scheduled duing the PMP window if customer does not want to pursue that during normal CPU rollout period.
Select One
21 PMP only - For OLAP mid-tier Clean the email folder, which will hold the bounced emails. OLAP has email functionality and a workflow user wf<sid> is setup on one of the MT for each instance. Clean the email file during the PMP process. Usually the location is /var/mail/wf<sid>.
Select One
22 OID check for OLAP Check if there is password expiration policy associated to the users in the OID. There SHOULD NOT be any password expiration policy associated to the users or in other words, it should be set to NEVER EXPIRE.
Select One
23 OID DB Parameters Sga_target 0 shared_pool_size 650M shared_pool_reserved_size 100M db_cache_size 500M open_cursors 1000 session_cached_cursor 1000 log_buffer >=14M undo_retention 3600
Select One
24 Revoke customer access from Production Servers : Select One To Revoke the Production access to the Customer on the day when the custome is going Live.
25 To Change the Password for the User Administrator :
Select One
26 Check Operations Guide is updated with all requisite information
Change
En d D at e
C (f om ir st ple na te m d e. B y la st na m e)
A dd i tio na lC om
m en
ts
SQL> select parameter, value from v$nls_parameters where parameter like '%CHARACTERSET%';
Check the size of datafiles Validate there is no data file that has unlimited extendable size. SQL> select FILE_NAME,AUTOEXTENSIBLE,MAXBYTES/1024/1024 /1024 from dba_data_files where autoextensible='YES' and maxbytes/1024/1024/1024>50;

PA Checklist OBIEE v6.1

Uploaded by

Copyright:

Available Formats

PA Checklist OBIEE v6.1

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

PA Checklist OBIEE v6.1

Uploaded by

Copyright:

Available Formats

Assessments OBIEE Checklist v6.

1 controlled Summary: Customer Details:

Testing Results Summary:

Assessments OBIEE Checklist v6.1 Production Instructions:

Assessments OBIEE Checklist v6.1 Production Instructions:

Assessments OBIEE Checklist v6.1 controlled Summary:

Database Tier Server Node Name(s), if applicable:

10 Confirm that monitoring is in place for all components

25 To Change the Password for the User Administrator :

26 Check Operations Guide is updated with all requisite information

You might also like