Configure Oracle Internet Directory 11gR1 with Oracle E-Business Suite Release 12.2.

Configure Oracle Internet Directory 11gR1 with Oracle E-Business Suite Release 12.2. Step 1: Before starting with the configuration start an Online Patching Cycle using ADOP Step 2: Choose Registration Type - Default (Simple) or Advanced Step 3: Compile Parameter Checklist Step 4: Run the Environment Script for the Patch File System Step 5: Check Specific Environment Settings Step 6: Run the Registration script from Patch File System Step 7: Confirm Successful Script Completion Step 8: Set the following profiles options in Oracle E-business Suite Release12.2 from Patch File System Step 9: Run Autoconfig from the Patch file system Step 10: End ADOP Patching Cycle(cutover) Will post the steps in detail .

Oracle EBS 12.2 Online Patching

Refer :http://www.strsoftware.com/blog/oracle-ebs-12-2-online-patching-first-glance Anyone that’s been following the release of 12.2 knows that Online Patching is the BIG feature that everyone is talking about. I’ve had the opportunity to utilize this new functionality and it’s been quite interesting. Online Patching is based on the Oracle Database 11.2 feature called Edition-Based Redefinition. The patch process has completely changed. There is now a patch edition and a run edition in the database. Additionally, the filesystem itself has 2 editions, a patch and run edition (there’s also one other filesystem that is non-editioned). There are 5 major steps in the patching process. Prepare – Creates the patch edition. Apply – Applies the patches to the patch edition Finalize – Ensures the system is ready for cut over (from patch to run edition) Cutover – This is where the patch edition becomes the run edition. Cleanup – Removes unnecessary code from obsolete editions. Steps 1-3 can be run while users are actively using the system. All of the patching is done in the patch edition of both the database and file system. Users essentially have no clue that patching is happening. Step 4 does require users to be booted off the system as the physical cutover is performed making the patch edition the new run edition, but this time should be nominal as all of the time consuming patching has already occurred in Steps 1-3. Additionally, the cutover process can be scheduled anytime after steps 1-3. For example you could take care of Steps 1-3 and then wait a week for an optimal time to run the actual cutover itself. Step 5 also does not require the system to be down and can be run anytime after the cutover and before the next prepare phase. One of the features of EBR is the ability to have certain users using the new functionality while other users use the old, non patched functionality. I was pretty excited about this. What a great way to test patches in the wild right? Give access to some power users to the patch edition and let them have it to really test it out. Unfortunately, this particular feature of EBR does not seem to be available in the online patching functionality of EBS. Users are quarantined to the RUN edition only. This new patching methodology is going to be mean changes for a lot of people. Both 3rd parties like STR Software that have bolt on products and individual companies that are maintaining customizations will require modifications to their code base to support Online Patching. I am currently going through the process of determining what those changes are and what they mean to our product and installation/upgrade scripts. I will likely have more comments on that subject once I’m further along in my investigation! For now, if you’ve been maintaining and patching previous versions of EBS and you are moving to 12.2, I would highly recommend that you thoroughly read the Oracle EBS Concepts Guide and Oracle EBS Maintenance Guide focusing on the patching and filesystem sections as everything has changed. It will give you a good primer as to what you are in for! Please watch the below youtube video whihc will give you more information about 12.2 Patching .. https://www.youtube.com/watch?v=kXLkna6GbQY adop phase=prepare Note:‐ In case, the previous patch cycle did not complete its cleanup phas, The new adop prepare phase will execute the clean‐up phase of previous cycle, if needed, and then proceed with preparing the new patch edition for new Online patching cycle. Create a new database patch edition Synchronize the file system patch edition with the run edition Configure the patch edition for use by the patching tools File system synchronization may be done by applying the delta (changes) from the previous patching cycle, or by re‐creating the entire patch edition file system as a fresh copy of the run edition (called "fs_clone"). When complete, check the exiting status code (success is '0'): adop exiting with status = 0 (Success) Once prepare phase is complete, the database and file system patch edition will contain a copy of the run edition code and seed data. 2) Apply ‐ apply ARU or manual patches to the patch edition. Below steps can be followed for ARU Patches Download the patch bundle from ARU from metalink. SCP the ZIP files in the "fs_ne/EBSapps/patch" directory on the Middle‐tier Use "adop phase=apply" command for patch application. >adop phase=apply patches=12345678 ... adop phase=apply patches=12345678,12312345 ... Below steps can be followed for Manual Patches. Manual patching is similar to our old R12.1 or 11i methods but the only difference being that the update happens in the patch edition only. Copy patch files to their destination directories in the patch edition. Execute any commands necessary to deploy changes to the file system. Execute any commands necessary to deploy changes to the database Update the custom synchronization driver to include any file system actions that must be executed again on the next prepare phase, in order to synchronize the alternate file system. Note:‐ The above steps can be automated using code migration tools like HP PPM Kintana or Dell Stat or Any other tools. My Favourite is HP PPM tool  (Its deployment module). 3) Finalize ‐ perform any actions required to prepare for cutover.  The finalize phase is used by the Online Patching system to perform any final actions needed to make the system ready for the fastest possible cutover. The finalize command is run as follows: [ajithpathiyil1:ajithebs:applmgr]> adop phase=finalize The finalize command should not have any error, In case of error, the system is not ready for cutover  After successful completion of the finalize phase, the system is ready for cutover Note:‐ We do not need to execute the cutover immediately; Cutover can be delayed until a convenient time in the future. In the meantime, We may also apply additional patches if needed, but you will need to run the finalize phase again after doing so. 4) Cutover ‐ Promote Patch Edition to be the new Run Edition.  The cutover phase will configure the patch edition to become the new run edition, and restart the application on this new run edition. Note:‐ Since the run/patch designation of the dual file systems are swapped during cutover, you must re‐source the run edition environment directly after cutover. adop phase=cutover ... ]> . /u02/app/applmgr/120//EBSapps.env run EBusiness Suite Environment Information RUN File System : /u02/app/applmgr/120//fs1/EBSapps/appl PATCH File System : /u02/app/applmgr/120//fs2/EBSapps/appl NonEditioned File System : /u02/app/applmgr/120/ajithebs/fs_ne DB Host: abc.lab.com Service/SID: abcebs Sourcing the RUN File System ... 5) Cleanup ‐ remove obsolete code and data from old editions. The cleanup phase will remove unnecessary code and data from old editions that are no longer needed by the running application. Cleanup should be run after cutover, at any time before the next prepare phase. It is best to run cleanup immediately after cutover so that there is no delay when preparing the next online patching cycle. There are two levels of cleanup available: quick ‐ the minimal cleanup required before starting the next patching cycle. full ‐ removes all obsolete code and data to recover maximum free space. Quick cleanup is the default, and is all that is necessary after normal patching.

what is LDOM and CDOM

https://blogs.oracle.com/cmt/entry/what_s_up_with_ldoms What is Hypervisor??? Hypervisor is a thin firmware layer that provides a stable virtualized machine architecture to which an operating system can be written. It resides in the flash PROM of the motherboard and act as interface between operating system and the hardware. It provides a set of support fuctions to the operating system, so that the OS does not need to know intimate details of how to perform fuctions with the hardware. What is Logical Domain??? Logical domain is a discrete logical grouping with its own operating system, resources and identity within a single computer system. Each logical domain can be created, destroyed, reconfigured, and rebooted independently, without requiring a power cycle of the server. We can run a variety of applications software in different logical domains and keep them independent of performance and security purposes. What is Logical Domains Manager??? The Logical Domains Manager is used to create and manage logical domains. There can be only one Logical Domains Manager per serer. The Logical Domains Manager maps logical domains to physical resources. What is Control Domain??? Domain in which the Logical Domain Manager runs allowing you to create and manage other logical domains and allocate virtual resources to other domains. There can be only one control domain per server. The initial domain created when installing Logical Domains software is a control domain and is named primary. What is Service Domain??? Domain that provides virtual device services to other domains, such as a virtual switch, a virtual console concentrator, and a virtual disk server. What is I/O Domain??? Domain that has direct ownership of and direct access to physical I/O devices, such as a network card in a PCI express controller. Shares the devices with other domains in the form of virtual devices when the I/O domain is also the control domain. What is Guest Domain??? Domain that is managed by the control domain and uses services from the I/O and service domains. Patch Installation Refer the Logical Domains 1.0.2 Release notes for the required patches/softwares for your OS release http://mysolarisworld.blogspot.com/p/how-to-install-and-configure-ldom.html

Difference between RAT and OATS

Difference between RAT and OATS RAT is targeted for DB testing only OATS is a test suite you can test pretty much anything. ATS is supported in both, You will be able to use RAT to record on 10g and 11g but only playback on 11g. Are these 2 ''options'' that come with the DB? or Do we have to purchase them separately and install separately?_ Both need to be licensed separately Both RAT and OATS run from a browser, OATS also hasa component called OpenScript that only runs on windows 32Bit RAT : Real Application Testing OATS : Oracle Application Testing Suite

The Internal Workflow of an E-Business Suite Concurrent Manager Process

Please refer this link for more clarity http://www.pythian.com/blog/the-internal-workflow-of-e-business-suite-concurrent-manager-process/ The Internal Workflow of an E-Business Suite Concurrent Manager Process Tags: 11i, concurrent, e-business suite, EBS, Oracle, Oracle Applications, Oracle E-Business Suite, performance, Pythian Europe, R12, Technical Blog, tuning Concurrent processing is one of the key elements of any E-Business Suite system. It provides scheduling and queuing functionality for background jobs, and it’s used by most of the application modules. As many things depend on concurrent processing, it’s important to make sure that the configuration is tuned for your requirements and hardware specification. This is the first article in a series about the performance of concurrent processing. We’ll take a closer look at the internals of concurrent managers, the settings that affect their performance, and the ways of diagnosing performance and configuration issues. Today we’ll start with an overview of the internal workflow of a concurrent manager process. Enjoy the reading! There are few things that need to be clear before we start: This is only about how the concurrent processing framework (the concurrent managers) works and not about the concurrent requests executed in the framework. There are multiple types of concurrent managers in EBS – internal manager, conflict resolution manager, workflow agent listener service, standard manager, etc. Their roles are different, and in this post, I’ll discuss only managers that pick up scheduled concurrent requests from the “queue” and execute them – or specifically all managers that have a type of “Concurrent Manager” set in Concurrent managers’ definition form. Typical examples of these managers are “Standard Manager”, “Inventory Manager”, and probably your own custom concurrent managers created for processing specific types of concurrent requests. "Concurrent Managers" Form “Concurrent Managers” Form It is important to understand the internal workflow of a concurrent manager because otherwise, it’s hard to realize how a configuration change actually affects the system. Several years ago, I had to implement an online change of a specialization rule, and it triggered a bounce of all Standard Manager processes – that’s when I realized I had to understand how it worked and since then I have spent lots of hours looking into internals of concurrent managers. I’m not saying that everything is 100% clear for me now – there are too many little things that matter in certain situations. This series of posts will be more about concepts. I hope you’ll find it useful. So how does a concurrent manager process work? Here is a diagram I created to explain it: Internal workflow of a concurrent manager process Internal workflow of a concurrent manager process I’ve numbered each step of the diagram to provide more details about them: This is where the story begins. There is no EXIT state in the diagram as the managers normally process requests in an infinite loop. Obviously, there is a way for a concurrent manager process to receive the command to quit when the managers need to be shut down, but that’s not included here for simplicity. Internal Concurrent Manager (ICM) requests the Service Manager (FNDSM) to start up the Concurrent Manager process. For the Standard Manager processes, the binary executable FNDLIBR is started. For the Inventory Manager, it’s INVLIBR. There are others too. The manager process connects to the database and reads the settings (e.g profile options, sleep seconds, cache size). The process saves information about itself in FND_CONCURRENT_PROCESSES table (os process id, database name, instance name, DB session identifiers, logfile path and name, and others). It also updates FND_CONCURRENT_QUEUES by increasing the value of RUNNING_PROCESSES. The concurrent manager process collects information from the database to build the SQL for querying the FND_CONCURRENT_REQUESTS table. The query will be used every time the manager process looks for scheduled concurrent requests. This is the only time the manager process reads the Specialization Rules (which programs it is allowed to execute) from the database. Keep in mind that if the specialization rules are changed while the managers are running, they are bounced without warning as that is the only way to update the specialization rules cached by the manager process. The SQL (from step 4) is executed to collect information about pending concurrent requests from FND_CONCURRENT_REQUESTS table. The results are checked to verify if any requests are pending for execution. If no requests are pending for execution, the manager process sleeps and then goes to step 5. The “Sleep Seconds” parameter of the “Work Shifts” settings of the concurrent manager determines how long the process sleeps before FND_CONCURRENT_REQUESTS table is queried again. This is the only time the “sleep seconds” setting is used. If there is at least one concurrent request pending for execution, the concurrent manager process caches rowids for the FND_CONCURRENT_REQUESTS rows of pending concurrent requests. The “Cache Size” setting of the concurrent manager specifies how many rowids to cache. The cached list of rowids is checked to verify if there are any unprocessed concurrent requests (rows in FND_CONCURRENT_REQUESTS table) left. If none are left – the processing returns to step 5 and the FND_CONCURRENT_REQUESTS table is queried again. The next unprocessed rowid is picked from the process cache, and the processing starts. Concurrent manager process executes a SELECT-for-UPDATE statement to lock the STATUS_CODE in FND_CONCURRENT_PROCESSES for the request it’s about to process. This is the mechanism to ensure that each concurrent request is executed only once and only by one manager process even if many processes are running simultaneously. The SELECT-for-UPDATE statement can complete with “ORA-00054: resource busy and acquire with NOWAIT specified” or “0 rows updated” if another manager process has started processing the request already. If the STATUS_CODE of the request was locked successfully, the concurrent manager executes the concurrent request. The processing moves to step 9 where the cached list of concurrent requests (rowids) is being checked again. The workflow is not very complex, but it’s important to remember that there are normally multiple concurrent manager processes running at the same time, and they are competing for the requests to run. This competition introduces another dimension of tuning for settings, like number of concurrent manager processes, sleep seconds, or cache

Important FND Tables in EBS

Important FND Tables in EBS Posted by Pratik on 22nd July 2013 in Database with 0 comments FND stands for foundation tables which is combination of AOL, SYSTEM, ADMINISTRATOR, MODULES tables and is placed under FND_TOP. Below i have listed few key FND tables that along with the little description of what is it used for : FND_APP_SERVERS : This table will track the servers used by the E-Business Suite system. FND_DATABASES : It tracks the databases employed by the eBusiness suite. This table stores information about the database that is not instance specific. FND_DATABASE_INSTANCES : Stores instance specific information. Every database has one or more instance. FND_ATTACHED_DOCUMENTS : Stores information relating a document to an application entity. FND_DOCUMENTS : Stores language-independent information about a document. FND_CURRENCIES : Stores information about currencies. FND_LANGUAGES : Stores information regarding languages and dialects. FND_TERRITORIES : Stores information for countries, alternatively known as territories. FND_CONCURRENT_PROCESSES : Stores information about concurrent managers. FND_CONCURRENT_PROCESSORS : Stores information about immediate (subroutine) concurrent program libraries. FND_CONCURRENT_PROGRAMS(_TL) : Stores information about concurrent programs. Each row includes a name and description of the concurrent program. FND_CONCURRENT_QUEUES : Stores information about concurrent managers. FND_CONCURRENT_QUEUE_SIZE : Stores information about the number of requests a concurrent manager can process at once, according to its work shift. FND_CONCURRENT_REQUESTS : Stores information about individual concurrent requests. FND_CONCURRENT_REQUEST_CLASS : Stores information about concurrent request types. FND_CONC_REQ_OUTPUTS : This table stores output files created by Concurrent Request. FND_EXECUTABLES : Stores information about concurrent program executables. FND_DESCRIPTIVE_FLEXS(_TL) : Stores setup information about descriptive flexfields. FND_FLEX_VALUES : Stores valid values for key and descriptive flexfield segments. FND_FLEX_VALUE_SETS : Stores information about the value sets used by both key and descriptive flexfields. FND_LOOKUPS : Stores information about lookup types. FND_LOOKUP_VALUES : Stores meaning values and codes for lookup types. FND_MENUS(_TL) : It lists the menus that appear in the Navigate Window, as determined by the System Administrator when defining responsibilities for function security. FND_MENU_ENTRIES : Stores information about individual entries in the menus in FND_MENUS. FND_REQUEST_GROUPS : Stores information about report security groups. FND_REQUEST_SETS : Stores information about report sets. FND_RESPONSIBILITY(_TL) : Stores information about responsibilities. FND_RESP_FUNCTIONS : Stores security exclusion rules for function security menus. Security exclusion rules are lists of functions and menus inaccessible to a particular responsibility. FND_PROFILE_OPTIONS : Stores information about profile options. FND_SECURITY_GROUPS : Stores information about security groups used to partition data in a Service Bureau architecture. FND_USER : Stores information about application users. FND_APPLICATION(_TL) : Stores applications registered with Oracle Application Object Library. FND_SEQUENCES : Stores information about the registered sequences in your applications. FND_VIEWS : Stores information about the registered views in your applications. FND_TABLES : Stores information about the registered tables in your applications. http://oracleappsebs.com/important-fnd-tables-in-ebs/

After changing the Admin Server to run in Node 2 from Node 1 ..getting 500 internal server error in EM console

Issue Changed the Admin server to run in Node2 instead of Node 1 . Though /em application is in Active state .not able to access EM console . Cause: sysman folder is not present in Node2 .(in the location /u01da/MW_Home/user_projects/domains/SOA_Domain/) Solution Copied the sysman folder from Node 1 to Node 2 . Chagned the server name to node2server instead of node1server in targets.xml restart the application em and click on update for the application em .. it started working !!!

StartWebLogic.cmd Shuts Down after Entering Username with the Error: "Server is running in Production Mode and Native Library (terminalio) to read the password securely from commandline is not found." (Doc ID 1354736.1

YMPTOMS After creating the WebLogic Domain for Contract Management, installing Contract Management and modifying the StartWebLogic.cmd and SetDomainENV.cmd file, the StartWebLogic.cmd file shuts down or closes after typing a username and pressing the ENTER key. The following error is listed in the StartWebLogic command prompt window prior to the shutdown completing: Server is running in Production Mode and Native Library (terminalio) to read the password securely from commandline is not found. CAUSE There are two possible causes: The terminalio.dll file is missing from the default location: C:\bea\middleware\wlserver_10.3\server\native\win\32 The terminalio.dll filing is being renamed to terminalio.dll.bak when the StartWeblogic.cmd file is started. This is a known issue that has been reported to Oracle in Bug 8002166. SOLUTION To resolve this issue, open the StartWebLogic.cmd file with Notepad and do the following: Located towards the bottom of the file are the following lines: if "%WLS_REDIRECT_LOG%"=="" ( echo Starting WLS with line: echo %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% ) else ( echo Redirecting output from WLS window to %WLS_REDIRECT_LOG% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% >"%WLS_REDIRECT_LOG%" 2>&1 ) Change them by including the following line directly before %JAVA_OPTIONS%: -Dweblogic.management.allowPasswordEcho=true The changed information should now appear as: if "%WLS_REDIRECT_LOG%"=="" ( echo Starting WLS with line: echo %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% ) else ( echo Redirecting output from WLS window to %WLS_REDIRECT_LOG% %JAVA_HOME%\bin\java %JAVA_VM% %MEM_ARGS% -Dweblogic.Name=%SERVER_NAME% -Djava.security.policy=%WL_HOME%\server\lib\weblogic.policy -Dweblogic.management.allowPasswordEcho=true %JAVA_OPTIONS% %PROXY_SETTINGS% %SERVER_CLASS% >"%WLS_REDIRECT_LOG%" 2>&1 ) Be sure to leave a space before and after the line that was just added. Save the changes and then restart StartWebLogic.cmd.

Refresh GUID’s after moving new RPD & Catalog

Refresh GUID’s after moving new RPD & Catalog Posted on September 6, 2012 by pradeep28186@gmail.com In OBIEE 11g , when we load new RPD and Catalog we need to refresh the user GUID’s else we get error at analytics log in. To resolve this error we have to manually edit the configuration files to instruct Oracle BI Server and Oracle BI Presentation Server to refresh the GUIDs on restart. Follow below steps, 1. Open the NQSconfig.ini file 2.Locate the parameter FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO ; change it toYES. 3.Open the instance config.xml file for editing, find out false then comment the and add like below example false UpdateAndExit save the changes in instance config.xml 4.Then using omnctl command restart the services ex. C:\middleware\instances\instance1\bin>opmnctl stopall C:\middleware\instances\instance1\bin>opmnctl startall 5.After restarting of services, revert the changes. i.e. in NQSconfig.ini resetFMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO ; & in instance config.xml comment & uncomment like false UpdateAndExit 6.Restart the services again using opmnctl command. http://pradeep28186.blog.com/2012/09/06/refresh-guids-after-moving-new-rpd-catalog/

Script to knwo the pid when port number is known in Solaris 11

Finding Process ID (PID) using port number in solaris is not easy as Linux. If you are working on new services setup and would like to allocate some port, you got to check if that port is used by some other service. You can find out which process is using particular port in solaris by below tiny shell scripts. Following scripts will prompt you to enter port number and it will use pfiles command internally to give you the pid. ====================================== #!/bin/ksh line='---------------------------------------------' pids=$(/usr/bin/ps -ef -o pid=) if [ $# -eq 0 ]; then read ans?"Enter Port Number To Know The pid: " else ans=$1 fi for f in $pids do /usr/proc/bin/pfiles $f 2>/dev/null | /usr/xpg4/bin/grep -q "port: $ans" if [ $? -eq 0 ]; then echo $line echo "Port: $ans is used by PID:\c" pargs -l $f fi done

Deinstalling Oracle Business Intelligence 11.1.1.7.0

Deinstalling Oracle Business Intelligence on a Single Computer To deinstall an Oracle Business Intelligence system that was previously installed on a single computer, you deinstall all Oracle Business Intelligence and WebLogic Server components. Deinstalling an Oracle Business Intelligence installation on a single computer involves the following tasks: Run the deinstall script and select the Deinstall instances managed by a WebLogic domain option. Stop all Oracle Business Intelligence processes and servers, including all OPMN-controlled components and JEE components. Drop the Metadata Services (MDS) and Business Intelligence Platform (BIPLATFORM) schemas using RCU. Run the deinstall script and select the Deinstall the Oracle home option. Deinstall the Oracle Common home manually or by running the deinstall script that it contains. Use the Oracle WebLogic Server uninstaller to uninstall WebLogic Server. Remove the Oracle home (if necessary). Remove the Middleware home and any other homes (Domain home, Applications home, and Instance home) that might have been installed outside of the Middleware home. To begin the process of de

Solaris 10 - Increasing Number of Processes Per User

Solaris 10 - Increasing Number of Processes Per User We came across this problem when working with one of the ISV application. We were simulating workload for performance tests and realized that the load simulation tool was generating 30000+ processes/LWP. The load siluation tools was running on UltraSPARC T2 based system with Solaris 10 and 32 GB RAM. Looked up the resources on the web for increasing the number of processes on Solaris 10 system on PER UID. Came across couple of blog entries (Giri Mandalika, Spiralbound.net) which provided good starting point but were not complete solution to our problem. We needed to increase the number of processesper user to more than current setting of 30000 bash-3.00# ulimit -a core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files (-n) 260000 pipe size (512 bytes, -p) 10 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 29995 virtual memory (kbytes, -v) unlimited Trying to increase the "max user processes" would fail with the following error: bash-3.00# ulimit -u 50000 bash: ulimit: max user processes: cannot modify limit: Invalid argument bash-3.00# After going through the Solaris 10 Tunable Guide for Process sizing learned that there are 5 related parameters related to process sizing. maxusers - The maximum number of processes on the system, The number of quota structures held in the system. The size of the directory name look-up cache (DNLC) reserved_procs - Specifies the number of system process slots to be reserved in the process table for processes with a UID of root pidmax - Specifies the value of the largest possible process ID. Specifies the value of the largest possible process ID. Valid for Solaris 8 and later releases. max_nprocs - Specifies the maximum number of processes that can be created on a system. Includes system processes and user processes. Any value specified in /etc/system is used in the computation of maxuprc. maxuprc - Specifies the maximum number of processes that can be created on a system by any one user Looked at the current values for these parameter: bash-3.00# echo reserved_procs/D | mdb -k reserved_procs: reserved_procs: 5 bash-3.00# echo pidmax/D | mdb -k pidmax: pidmax: 30000 bash-3.00# echo maxusers/D | mdb -k maxusers: maxusers: 2048 bash-3.00# bash-3.00# echo max_nprocs/D | mdb -k max_nprocs: max_nprocs: 30000 bash-3.00# bash-3.00# echo maxuprc/D | mdb -k maxuprc: maxuprc: 29995 So, in order to set the max per user processes in this scenario, we were required to make the changes to "pidmax" (upper cap), maxusers, max_nprocs & maxuprc Sample entries in /etc/system & reboot set pidmax=60000 set maxusers = 4096 set maxuprc = 50000 set max_nprocs = 50000 After making the above entries, we were able to increase the max user processes to 50000. bash-3.00# ulimit -a core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited open files (-n) 260000 pipe size (512 bytes, -p) 10 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 49995 virtual memory (kbytes, -v) unlimited bash-3.00# bash-3.00# echo reserved_procs/D | mdb -k reserved_procs: reserved_procs: 5 bash-3.00# echo pidmax/D | mdb -k pidmax: pidmax: 60000 bash-3.00# echo max_nprocs/D | mdb -k max_nprocs: max_nprocs: 50000 bash-3.00# echo maxuprc/D | mdb -k maxuprc: maxuprc: 50000 bash-3.00# Note: If you are operating within the 30000 limit (default pidmax setting) the blog entry referred above seems to work fine. If you are looking at increasing the processes beyond 30000, it we need to make adjustment to other dependent parameters stated in this blog entry.

How to count the number of processes running, in Linux

How to count the number of processes running, in Linux ps aux | wc -l The above command will count the number of processes running on your system by any user. If you want to see only processes by a certain user with a username user1, you can use the following command: ps -U user1 | wc -l Now your other question, you want to count the number of processes run by httpd, that can be achieved using two commands: ps -C httpd | wc -l The above command can count the number of processes spawned by a command like httpd. Replace httpd with sshd or any other command! Another way of doing this is to use the pgrep command. pgrep httpd | wc -l The pgrep command can be used to lookup running processes based on name, process ID and other attributes of a process like the user who created the process.

Error: "Executing Opmnctl Start Coreapplication_obiccs1 Failed" When Installing OBIEE 11g (Doc ID 1211149.1)

APPLIES TO: Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] and later Information in this document applies to any platform. ***Checked for relevance on 05-Jun-2014*** SYMPTOMS When Installing OBI EE 11g (11.1.1.3.0) the Installation fails with the following error displayed : Modifying BI Configuration Files - Sucsess Executing: opmnctl start coreapplication_obiccs1 - Failed Executing: opmnctl start coreapplication_obis1 - Recommended Executing: opmnctl start coreapplication_obips1 - Recommended Executing: opmnctl start coreapplication_obijh1 - Recommended Executing: opmnctl start coreapplication_obisch1 - Recommended Modifying BI Configuration Files - Recommended Step Executing opmnctl start coreapplication_obiccs1 failed Configuration Action 'Executing: opmnctl start coreapplication_obiccs1' has failed. please check logs for details Strep Executing 'opmnctl start coreapplication_obiccs1 failed Executing Task: Executing: opmnctl start *************** Trying to Start OPMN ************** *************** Executing Command ************** cmd /c C:\Temp\Opmn1283940377935.bat *************************************************** C:\Temp>SET ORACLE_HOME=D:\FusionOBIEE\Oracle_BI1 C:\Temp>CALL "D:\FusionOBIEE\instances\instance1\bin\opmnctl.bat" start opmnctl start: opmn is already running. progress in calculate progress2 Executing Task: Creating BI Server System Components oracle.as.config.ProvisionException: Failed to invoke Opmn reload. at oracle.as.config.impl.OracleASComponentBaseImpl.reloadOpmn(OracleASComponentBaseImpl.java:967) at oracle.as.config.impl.OracleASComponentBaseImpl.create(OracleASComponentBaseImpl.java:114) at oracle.as.install.bi.biconfig.standard.SystemComponentTask.doExecute(SystemComponentTask.java:68) at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:79) at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61) at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:110) at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:335) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:87) at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:104) at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15) at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:63) CAUSE Tthe OBIEE Services do not start up again automatically during the installation process. SOLUTION This issue can be resolved by manually running the OPMNCTL Command in another Window: - Start by running the 'opmnctl startall' command manually Then run the 'opmnctl status' command intermittently to check if the Services are now up and running as expected. The Installer should then continue to a successful completion once the OBI EE Services are up and running. Run these commands as necessary: - c:\MiddlewareHome\instances\instance1\bin> opmnctl startall And to check its progress you can run this command: c:\MiddlewareHome\instances\instance1\bin> opmnctl status And if required (to start again) : c:\MiddlewareHome\instances\instance1\bin> opmnctl stopall Some additional useful information : 1) Having Database connectivity is essential when Installing and logging into the OBI EE Presentation Services so having the Database (and Oracle TNS Listener up, if applicable) running is very important. If you are having installation problems with 11g please ensure that your Database is up and running and canbe connected to by the BI Server machine. 2) Some installation issues can be caused by this known issue with your Windows configuration. Please review the OBI EE 11g Release Notes document : - Section 53.2.8 Oracle BI Installer Stops at Administrator User Details Screen "If you attempt to install on a Windows machine that is using DHCP, does not have a primary DNS suffix, and does not have a loopback adapter configured, then the Oracle BI installer will stop at the screen prompting for the Administrator user details. This appears as a red cross in the tree on the left hand side of the installer. This issue is caused by the installer not being able to resolve the IP address to a hostname. The workaround is to configure a loopback adapter or primary DNS suffix" http://download.oracle.com/docs/cd/E14571_01/relnotes.1111/e10132/biee.htm#CACEFIAG

OBIEE 11.1.1.7.131017 Bundle Patch Now Available

OBIEE 11.1.1.7.131017 Bundle Patch Now Available A new bundle patch for Oracle Business Intelligence became available last week. This is OBIEE Bundle Patch 11.1.1.7.131017, and is available on the following platforms: HP-UX Itanium IBM AIX on POWER Systems (64-bit) Linux x86 Linux x86-64 Microsoft Windows (32-bit) Microsoft Windows (64-bit) Oracle Solaris on x86-64 (64-bit) It is applicable to all customers running OBIEE versions 11.1.1.7.0 and 11.1.1.7.1 Patch 17530796 - OBIEE BUNDLE PATCH 11.1.1.7.131017 (Patch) is comprised of the following patches, which are not available separately: Patch 16913445 - Patch 11.1.1.7.131017 (1 of 8) Oracle Business Intelligence Installer (BIINST) Patch 17463314 - Patch 11.1.1.7.131017 (2 of 8) Oracle Business Intelligence Publisher (BIP) Patch 17300417 - Patch 11.1.1.7.131017 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)) Patch 17463395 - Patch 11.1.1.7.131017 (4 of 8) Oracle Business Intelligence Server (BIS) Patch 17463376 - Patch 11.1.1.7.131017 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS) Patch 17300045 - Patch 11.1.1.7.131017 (6 of 8) Oracle Business Intelligence Presentation Services (BIPS) Patch 16997936 - Patch 11.1.1.7.131017 (7 of 8) Oracle Business Intelligence Presentation Services (BIPS) Patch 17463403 - Patch 11.1.1.7.131017 (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer You will also notice that the bundle patch is now named in a "YYMMDD" format; i.e. the fifth place now tells you when the patch was released. This calendar date numbering scheme has been initiated with the 11.1.1.7.131017 bundle patch. As usual, please go through the Readme and other instructions before deciding upon an installation schedule and decision. http://bi.abhinavagarwal.net/2013/10/obiee-11117131017-bundle-patch-now.html

OBIA 11.1.1.7.1 Installation produces error: INST-07515 – oracle.bi.bishiphome is not found in the inventory (Doc ID 1566453.1)

OBIA 11.1.1.7.1 Installation produces error: INST-07515 – oracle.bi.bishiphome is not found in the inventory (Doc ID 1566453.1) APPLIES TO: Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 and later Information in this document applies to any platform. SYMPTOMS When installing OBIA 11.1.1.7.1 on OBIEE 11.1.1.7.0, the installation fails with the following error: INST-07515 – oracle.bi.bishiphome is not found in the inventory Tried the recommendations in forum but did not resolve the error Verified that JAVA was 64bit and in the PATH Verified that OBIEE installation was 64bit OBIA is being installed with same user account used for installing OBIEE. CAUSE Inventory not found in the Oracle Home SOLUTION Changing the Oracle Inventory location resolved the error

Configuring coherence for SOA 11g

Configuring coherence for SOA Step 1 :By default youu have multicast configured in your setDomainEnv.sh. We recommend to remove the tangosol entries from that file, configure Coherence like this: 1.a : removing tangosol from setDomainEnv.sh .. 1.b : take a backup of setDomainEnv.sh 1.c : vi setDomainEnv.sh ..remove the entry tangosol …save the file .. Step 2. Configuring Coherence. 2.a Contact network team and request them two create two virtual host …which point to the ip of the server where soa managed servers are installed . cat /etc/hosts 172.30.15.145 SOATEST1VHN1.mof.local SOATEST1VHN1 172.30.15.146 SOATEST2VHN1.mof.local SOATEST2VHN1 2.b create two virtual host from wls console along with two channel 0 and 1 respectively CLICK ON NEW AND CREATE Channel-0 AND Chaneel-1 RESPECTIVELY Creating Chaneel-1 2.c Login to wls console click on soa server 1 .configuration .server –startup and give the below - Log into the Oracle WebLogic Server Administration Console. - In the Domain Structure window, expand the Environment node. - Click Servers. The Summary of Servers page appears. - Click the name of the server (WLS_SOA1 or WLS_SOA2, which are represented as hyperlinks) in Name column of the table. The settings page for the selected server appears. - Click Lock and Edit. - Click the Configuration tab, and then the Server Start tab. - Enter the following for WLS_SOA1 and WLS_SOA2 into the Arguments field. For WLS_SOA1, enter the following: -Dtangosol.coherence.wka1=SOAHOST1VHN1 -Dtangosol.coherence.wka2=SOAHOST2VHN1 -Dtangosol.coherence.localhost=SOAHOST2VHN1 For WLS_SOA2, enter the following: -Dtangosol.coherence.wka1=SOAHOST1VHN1 -Dtangosol.coherence.wka2=SOAHOST2VHN1 -Dtangosol.coherence.localhost=SOAHOST2VHN1 2.d http://download.oracle.com/docs/cd/E17904_01/core.1111/e12036/extend_bpmn.htm#SOEDG420 After doing this you need a full cluster reboot. NOTE: Coherence is responsible for deploying application in a cluster environment.

ld.so.1: opmn: fatal: libmodapi.so: open failed

APPLIES TO: Oracle Fusion Middleware - Version 11.1.1.2.0 and later Oracle Solaris on SPARC (64-bit) Checked for relevance on 22-Nov-2013 ========================================================================================== SYMPTOMS After installing Oracle Fusion Middleware 11.1.1.2 on Sun Solaris 64-bit on SPARC, starting OPMN managed process using "opmnctl startall" fails with the following error: opmnctl startall: starting opmn and all managed processes... ld.so.1: opmn: fatal: libmodapi.so: open failed: No such file or directory opmnctl startall: failed. CHANGES The environment variable LD_LIBRARY_PATH_64 was set before issuing "opmnctl startall" and it does not include $ORACLE_HOME/opmn/lib and $ORACLE_HOME/lib. You can retrieve the current value of this environment variable using: echo $LD_LIBRARY_PATH_64 =================================================================================== CAUSE The command "opmnctl" invokes 64-bit binary $ORACLE_HOME/opmn/bin/opmn which has dynamic dependencies in following two directories: $ORACLE_HOME/opmn/lib $ORACLE_HOME/lib On Solaris, LD_LIBRARY_PATH_64 and LD_LIBRARY_PATH environment variables affects the runtime linkers search for dynamic dependencies. For 64 bit applications, LD_LIBRARY_PATH_64 overrides LD_LIBRARY_PATH setting. Regardless of LD_LIBRARY_PATH setting, if LD_LIBRARY_PATH_64 is set and does not include $ORACLE_HOME/opmn/lib and $ORACLE_HOME/lib, opmn startup will fail. ================================================================================== SOLUTION There are two possible solutions: Solution 1: 1.Unset the environment variable LD_LIBRARY_PATH_64. 2.Confirm that LD_LIBRARY_PATH_64 is unset, following command should not return any value: echo $LD_LIBRARY_PATH_64 3.Start OPMN managed components using: opmnctl startall Solution 2: 1. Add $ORACLE_HOME/opmn/lib and $ORACLE_HOME/lib to beginning of LD_LIBRARY_PATH_64 export LD_LIBRARY_PATH_64=$ORACLE_HOME/opmn/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH_64 2.Confirm that LD_LIBRARY_PATH_64 is set correctly using following command: echo $LD_LIBRARY_PATH_64 3.Start OPMN managed components using: opmnctl startall

Virtual Hosting a web application in weblogic 11g

Virtual Hosting a web application in weblogic 11g Here are the steps how to create a name based virtual host in weblogic server 10 and how to deploy a web application in the virtual host using weblogic console. Step 1: Create new network channel You must be aware that a network channel is like a network connection in weblogic. A network channel is a unique combination of listen address, listen port, and protocol. In order to create a virtual host you first need to created a network channel. Go to console -> left pane -> wl_server -> Environemnt ->servers -> Click Local & Edit Right pane: -> Go to 'exampleServer' -> protocols -> channels -> Click on Lock & Edit -> Click New -> Enter following details for channel. Name="mychannel", protocol=http Listen address = 127.0.0.1, Listen Port = 7003, Leave External Listen address and Leave External Listen Port blank -> Click on 'Finish' -> Save changes -> Activate changes Note: After this step you have created a network channel. That means your server will listen at given listening address and port. Try accessing http://127.0.0.1:7003 Step 2. Create new virtual host Go to console -> left pane -> wl_server -> environement -> virtual hosts -> Click lock & edit Right pane : -> Click on New -> Enter Name 'myvh' -> save changes -> Activate changes Note: After this step a virtual host is created. It does not mean anything unless you configure the virtual host as shown in the next step. Step 3: Configure virtual host Go to console -> left pane -> wl_server -> environement -> virtual hosts -> Click lock & edit Right pane: -> Click on 'myvh' virtual host link in the 'Virtual Hosts' table. -> Enter 'myvh.oracle.com' in the 'Virtual Host Names' text box. -> Enter 'mychannel' in the 'Network Access Point Name' text box. -> Save changes. -> Click on 'Targets' tab. -> Select 'exampleServer' in the 'servers' section. -> Save changes. -> Activate changes Step 4. Deploy application to virtual host Go to Console -> left pane -> wl_server -> deployments -> Click lock & edit Right pane: -> Click on 'Install' -> Click on "upload your files" link -> Click "browse" (against 'deployment archive' ) -> select "sample.war" -> Click "Next" -> Choose 'sample.war' in the "location" section -> Choose "Install this deployment as an application" radio button -> Click on "deployment targets" tab -> select 'myvh' -> Next -> Next -> Finish -> Save changes -> Activate changes Step 5. Create DNS entry in your hosts file. For linux hosts file is: /etc/hosts Append the following line to the file as super user. 127.0.0.1 myvh.oracle.com Save the changes to 'hosts' file. Note: Just saving the changes to 'hosts' file is enough to activate the DNS entry. Step 6. Start the application. Go to Console -> left pane -> wl_server -> deployments -> Right pane: -> Select 'sample.war'. -> click on 'Start'. -> Complete the start process. Step 7. Access the virtual hosted application. Now you should be able to access the following url only from the machine where you modified the 'hosts' file as mentioned above. http://myvh.oracle.com:7003/sample/ If you want to use access the above url from any machine, appropriate DNS entries need to be created by your network administrator in your network Router.

OBIEE 11gR1 Security Explained : Working with the Default Security Configuration with AD ALSO

http://www.rittmanmead.com/2010/10/obiee-11gr1-security-explained-working-with-the-default-security-configuration/ http://www.rittmanmead.com/2010/11/01/oracle-bi-ee-11g-security-integration-with-microsoft-active-directory/

WNA configuration in Oracle Access Manager 11g R2 PS2

http://findiamsolution.blogspot.com/2014/04/wna-configuration-in-oracle-access.html

OAM 11g(integrated with OAAM 11g) user not able to login to a protected resource intermittently

Hi All, Recently I came across a weird intermittent login issue in OAM 11g protected resource when it's integrated with OAAM 11g. As far as I know there is only one place(OAM Admin console >> System configuration >> common settings) where we can change the max session timeout. By default, Max session value will be 480 min. I got requirement to change the max session timeout from 8 hrs to 12 hrs. So I just changed the setting accordingly and bounced the services. After increasing the max timeout setting user is not able to login all of sudden. After so much struggle i found the pattern of the issue. User will not be able to login starting from 8th hour of user last login and before 12th hour(Essentially, user will not be able to login for period of 4 hrs). Once clock hits 12th hour user can login as usual. Then finally after discussing with Oracle support there they provided a fix for this issue. Here is the solution: 1. On the Admin Server, take a backup of the $DOMAIN_HOME/config/fmwconfig/oam-config.xml 2. Edit the oam-config.xml file, searching for CredentialValidityInterval (this defaults to 480 minutes, or 8 hours) 3. Change this field to match the configured OAM session timeout 4. Find the Version field, eg: 20000 120 and increment the version value: 20000 121 Then, Bounce OAM services and test the scenario. http://findiamsolution.blogspot.com/2014/02/oam-11g-intermittent-login-issue.html

OBIEE 11g 11.1.1.7.1 New Features

http://www.clearpeaks.com/blog/oracle-bi-ee-11g/top-5-new-features-obiee-11-1-1-7-1

Security in OBIA 11.1.1.7.1

http://docs.oracle.com/cd/E23943_01/bi.1111/e10543/sso.htm http://docs.oracle.com/cd/E38317_01/doc.11117/e37986/security.htm#CJAICGCF http://www.rittmanmead.com/2012/03/obiee-11g-security-week-connecting-to-active-directory-and-obtaining-group-membership-from-database-tables/ 1343143.1 http://onlineappsdba.com/index.php/2011/12/05/integrate-obiee-11g-with-oam-11g-for-single-sign-on-in-13-steps/

How to change the logo in the OBIEE11G Reports

How to change the logo in the OBIEE11G Reports Place the customized logo n the below locations :\Oracle\Middleware\Oracle_BI1\bifoundation\web\app\res\s_blafp\images :\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\.appmergegen_1291264099332\analytics.ear\ukjjdc\res\s_blafp\images :\Oracle\Middleware\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\s_blafp\images After placing the image restart the BI Services. In Logo of Title View the format is like:- fmap:Images/image.jpg

Hyperion 11.1.2.3 Issues

http://hyperionvirtuoso.blogspot.com/ http://hyperion-appu.blogspot.com/2014/05/in-epm-version-11123-after-installing.html http://john-goodwin.blogspot.com/2013_05_01_archive.html http://www.mpowersolutions.com.au/news-events/news/11123-a-technical-summary-what-you-need-to-know

RAC Commands

http://satya-racdba.blogspot.in/2009/12/srvctl-commands.html srvctl commands in Oracle RAC SRVCTL: (Server Control utility) srvctl command target [options] commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config targets: database/db|instance/inst|service/serv|nodeapps|asm|listener targets: database/db|instance/inst|service/serv|nodeapps|asm|listener |diskgroup|home|ons|eons|filesystem|gns|oc4j|scan|scan_listener |srvpool|server|VIP -- From Oracle 11g R2 srvctl -help or srvctl -v srvctl -V -- prints version srvctl version: 10.2.0.0.0 (or) srvctl version: 11.2.0.1.0 srvctl -h -- print usage srvctl status service –h Database: -------------------------------------------------------------------------------- srvctl add database -d db_name -o ORACLE_HOME [-m domain_name][-p spfile] [-A name|ip/netmask] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-n db_name] [-y {AUTOMATIC|MANUAL}] srvctl add database -d prod -o /u01/oracle/product/102/prod srvctl remove database -d db_name [-f] srvctl remove database -d prod srvctl start database -d db_name [-o start_options] [-c connect_str|-q] srvctl start database -d db_name [-o open] srvctl start database -d db_name -o nomount srvctl start database -d db_name -o mount srvctl start db -d prod srvctl start database -d apps -o open srvctl stop database -d db_name [-o stop_options] [-c connect_str|-q] srvctl stop database -d db_name [-o normal] srvctl stop database -d db_name -o transactional srvctl stop database -d db_name -o immediate srvctl stop database -d db_name -o abort srvctl stop db -d crm -o immediate srvctl status database -d db_name [-f] [-v] [-S level] srvctl status database -d db_name -v service_name srvctl status database -d hrms srvctl enable database -d db_name srvctl enable database -d vis srvctl disable database -d db_name srvctl disable db -d vis srvctl config database srvctl config database -d db_name [-a] [-t] srvctl config database srvctl config database -d HYD -a srvctl modify database -d db_name [-n db_name] [-o ORACLE_HOME] [-m domain_name] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-y {AUTOMATIC|MANUAL}] srvctl modify database -d hrms -r physical_standby srvctl modify db -d RAC -p /u03/oradata/RAC/spfileRAC.ora -- moves p file srvctl modify database –d HYD –o /u01/app/oracle/product/11.1/db –s open srvctl getenv database -d db_name [-t name_list] srvctl getenv database -d prod srvctl setenv database -d db_name {-t name=val[,name=val,...]|-T name=val} srvctl setenv database –d HYD –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin” srvctl setenv db -d prod -t LANG=en srvctl unsetenv database -d db_name [-t name_list] srvctl unsetenv database -d prod -t CLASSPATH In 11g Release 2, some command's syntax has been changed: srvctl add database -d db_unique_name -o ORACLE_HOME [-x node_name] [-m domain_name] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-n db_name] [-y {AUTOMATIC|MANUAL}] [-g server_pool_list] [-a "diskgroup_list"] srvctl add database -d prod -o /u01/oracle/product/112/prod -m foo.com -p +dg1/prod/spfileprod.ora -r PRIMARY -s open -t normal -n db2 -y AUTOMATIC -g svrpool1,svrpool2 -a "dg1,dg2" srvctl remove database -d db_unique_name [-f] [-y] [-v] srvctl remove database -d prod -y srvctl stop database -d db_unique_name [-o stop_options] [-f] srvctl stop database -d dev -f srvctl status database -d db_unique_name [-f] [-v] srvctl status db -d sat -v srvctl enable database -d db_unique_name [-n node_name] srvctl enable database -d vis -n lnx01 srvctl disable database -d db_unique_name [-n node_name] srvctl disable db -d vis -n lnx03 srvctl config database [-d db_unique_name [-a]] srvctl config db -d db_erp -a srvctl modify database -d db_unique_name [-n db_name] [-o ORACLE_HOME] [-u oracle_user] [-m domain] [-p spfile] [-r {PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY}] [-s start_options] [-t stop_options] [-y {AUTOMATIC|MANUAL}] [-g "server_pool_list"] [-a "diskgroup_list"|-z] srvctl modify db -d prod -r logical_standby srvctl modify database -d racTest -a "SYSFILES,LOGS,OLTP" srvctl modify database -d ronedb -e rac1,rac2 srvctl relocate database -d db_unique_name {[-n target_node] [-w timeout] | -a [-r]} [-v] srvctl relocate database -d rontest -n node2 srvctl relocate database -d rone2db -n lnxrac2 -w 120 -v srvctl convert database -d .... srvctl convert database -d ronedb -c RAC -n rac1 srvctl convert database -d ronedb -c RACONENODE -i RoneDB Instance: -------------------------------------------------------------------------------- srvctl add instance –d db_name –i inst_name -n node_name srvctl add instance -d prod -i prod01 -n linux01 srvctl remove instance –d db_name –i inst_name [-f] srvctl remove instance -d prod -i prod01 srvctl start instance -d db_name -i inst_names [-o start_options] [-c connect_str|-q] srvctl start instance –d db_name –i inst_names [-o open] srvctl start instance –d db_name –i inst_names -o nomount srvctl start instance –d db_name –i inst_names -o mount srvctl start instance –d dev -i dev2 srvctl stop instance -d db_name -i inst_names [-o stop_options] [-c connect_str|-q] srvctl stop instance –d db_name –i inst_names [-o normal] srvctl stop instance –d db_name –i inst_names -o transactional srvctl stop instance –d db_name –i inst_names -o immediate srvctl stop instance –d db_name –i inst_names -o abort srvctl stop inst –d vis -i vis srvctl status instance –d db_name –i inst_names [-f] [-v] [-S level] srvctl status inst –d racdb -i racdb2 srvctl enable instance –d db_name –i inst_names srvctl enable instance -d prod -i "prod1,prod2" srvctl disable instance –d db_name –i inst_names srvctl disable inst -d prod -i "prod1,prod3" srvctl modify instance -d db_name -i inst_name {-s asm_inst_name|-r} -- set dependency of instance to ASM srvctl modify instance -d db_name -i inst_name -n node_name -- move the instance srvctl modify instance -d db_name -i inst_name -r -- remove the instance srvctl getenv instance –d db_name –i inst_name [-t name_list] srvctl setenv instance –d db_name [–i inst_name] {-t "name=val[,name=val,...]" | -T "name=val"} srvctl unsetenv instance –d db_name [–i inst_name] [-t name_list] In 11g Release 2, some command's syntax has been changed: srvctl start instance -d db_unique_name {-n node_name -i "instance_name_list"} [-o start_options] srvctl start instance -d prod -n node2 srvctl start inst -d prod -i "prod2,prod3" srvctl stop instance -d db_unique_name {[-n node_name]|[-i "instance_name_list"]} [-o stop_options] [-f] srvctl stop inst -d prod -n node1 srvctl stop instance -d prod -i prod1 srvctl status instance -d db_unique_name {-n node_name | -i "instance_name_list"} [-f] [-v] srvctl status instance -d prod -i "prod1,prod2" -v srvctl modify instance -d db_unique_name -i instance_name {-n node_name|-z} srvctl modify instance -d prod -i prod1 -n mynode srvctl modify inst -d prod -i prod1 -z Service: -------------------------------------------------------------------------------- srvctl add service -d db_name -s service_name -r pref_insts [-a avail_insts] [-P TAF_policy] srvctl add service -d db_name -s service_name -u {-r "new_pref_inst" | -a "new_avail_inst"} srvctl add service -d RAC -s PRD -r RAC01,RAC02 -a RAC03,RAC04 srvctl add serv -d CRM -s CRM -r CRM1 -a CRM3 -P basic srvctl remove service -d db_name -s service_name [-i inst_name] [-f] srvctl remove serv -d dev -s sales srvctl remove service -d dev -s sales -i dev01,dev02 srvctl start service -d db_name [-s service_names [-i inst_name]] [-o start_options] srvctl start service -d db_name -s service_names [-o open] srvctl start service -d db_name -s service_names -o nomount srvctl start service -d db_name -s service_names -o mount srvctl start serv -d dwh -s dwh srvctl stop service -d db_name [-s service_names [-i inst_name]] [-f] srvctl stop serv -d dwh -s dwh srvctl status service -d db_name [-s service_names] [-f] [-v] [-S level] srvctl status service -d dev -s dev srvctl enable service -d db_name -s service_names [–i inst_name] srvctl enable service -d apps -s apps1 srvctl disable service -d db_name -s service_names [–i inst_name] srvctl disable serv -d dev -s dev -i dev1 srvctl config service -d db_name [-s service_name] [-a] [-S level] srvctl config service -d db_name -a -- -a shows TAF configuration srvctl config service -d TEST -s test PREF:TST1 AVAIL:TST2 srvctl modify service -d db_name -s service_name -i old_inst_name -t new_inst_name [-f] srvctl modify service -d db_name -s service_name -i avail_inst_name -r [-f] srvctl modify service -d db_name -s service_name -n -i preferred_list [-a available_list] [-f] srvctl modify service -d db_name -s service_name -i old_inst_name -a avail_inst -P TAF_policy srvctl modify serv -d PROD -s DWH -n -i I1,I2,I3,I4 -a I5,I6 srvctl relocate service -d db_name -s service_name –i old_inst_name -t target_inst [-f] srvctl getenv service -d db_name -s service_name -t name_list srvctl setenv service -d db_name [-s service_name] {-t "name=val[,name=val,...]" | -T "name=val"} srvctl unsetenv service -d db_name -s service_name -t name_list In 11g Release 2, some command's syntax has been changed: srvctl add service -d db_unique_name -s service_name [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC|MANUAL}] [-q {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}][-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}][-z failover_retries] [-w failover_delay] srvctl add service -d rac -s rac1 -q TRUE -m BASIC -e SELECT -z 180 -w 5 -j LONG srvctl add service -d db_unique_name -s service_name -u {-r preferred_list | -a available_list} srvctl add service -d db_unique_name -s service_name -g server_pool [-c {UNIFORM|SINGLETON}] [-k network_number] [-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY] [-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-P {BASIC|NONE|PRECONNECT}] [-x {TRUE|FALSE}] [-z failover_retries] [-w failover_delay] srvctl add service -d db_unique_name -s service_name -r preferred_list [-a available_list] [-P {BASIC|NONE|PRECONNECT}] [-l [PRIMARY|PHYSICAL_STANDBY|LOGICAL_STANDBY|SNAPSHOT_STANDBY] [-y {AUTOMATIC|MANUAL}] [-q {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-x {TRUE|FALSE}] [-z failover_retries] [-w failover_delay] srvctl add serv -d dev -s sales -r dev01,dev02 -a dev03 -P PRECONNECT srvctl start service -d db_unique_name [-s "service_name_list" [-n node_name | -i instance_name]] [-o start_options] srvctl start serv -d dev -s dev srvctl start service -d dev -s dev -i dev2 srvctl stop service -d db_unique_name [-s "service_name_list"] [-n node_name | -i instance_name] [-f] srvctl stop service -d dev -s dev srvctl stop serv -d dev -s dev -i dev2 srvctl status service -d db_unique_name [-s "service_name_list"] [-f] [-v] srvctl status service -d dev -s dev -v srvctl enable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name] srvctl enable service -d dev -s dev srvctl enable serv -d dev -s dev -i dev1 srvctl disable service -d db_unique_name -s "service_name_list" [-i instance_name | -n node_name] srvctl disable service -d dev -s "dev,marketing" srvctl disable serv -d dev -s dev -i dev1 srvctl config service -d db_unique_name [-s service_name] [-a] srvctl config service -d dev -s dev srvctl modify service -d db_unique_name -s service_name [-c {UNIFORM|SINGLETON}] [-P {BASIC|PRECONNECT|NONE}] [-l {[PRIMARY]|[PHYSICAL_STANDBY]|[LOGICAL_STANDBY]|[SNAPSHOT_STANDBY]} [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z failover_retries] [-w failover_delay] [-y {AUTOMATIC|MANUAL}] srvctl modify service -d db_unique_name -s service_name -i old_instance_name -t new_instance_name [-f] srvctl modify service -d db_unique_name -s service_name -i avail_inst_name -r [-f] srvctl modify service -d db_unique_name -s service_name -n -i preferred_list [-a available_list] [-f] srvctl modify service -d dev -s dev -i dev1 -t dev2 srvctl modify serv -d dev -s dev -i dev1 -r srvctl modify service -d dev -s dev -n -i dev1 -a dev2 srvctl relocate service -d db_unique_name -s service_name {-c source_node -n target_node|-i old_instance_name -t new_instance_name} [-f] srvctl relocate service -d dev -s dev -i dev1 -t dev3 Nodeapps: -------------------------------------------------------------------------------- #srvctl add nodeapps -n node_name -o ORACLE_HOME -A name|ip/netmask[/if1[|if2|...]] #srvctl add nodeapps -n lnx02 -o $ORACLE_HOME -A 192.168.0.151/255.255.0.0/eth0 #srvctl remove nodeapps -n node_names [-f] #srvctl start nodeapps -n node_name -- Starts GSD, VIP, listener & ONS #srvctl stop nodeapps -n node_name [-r] -- Stops GSD, VIP, listener & ONS #srvctl status nodeapps -n node_name #srvctl config nodeapps -n node_name [-a] [-g] [-o] [-s] [-l] -a Display VIP configuration -g Display GSD configuration -s Display ONS daemon configuration -l Display listener configuration #srvctl modify nodeapps -n node_name [-A new_vip_address] #srvctl modify nodeapps -n lnx06 -A 10.50.99.43/255.255.252.0/eth0 #srvctl getenv nodeapps -n node_name [-t name_list] #srvctl setenv nodeapps -n node_name {-t "name=val[,name=val,...]"|-T "name=val"} #srvctl setenv nodeapps –n adcracdbq3 –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin” #srvctl unsetenv nodeapps -n node_name [-t name_list] In 11g Release 2, some command's syntax has been changed: srvctl add nodeapps -n node_name -A {name|ip}/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v] srvctl add nodeapps -S subnet/netmask[/if1[|if2|...]] [-d dhcp_server_type] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v] #srvctl add nodeapps -n devnode1 -A 1.2.3.4/255.255.255.0 srvctl remove nodeapps [-f] [-y] [-v] srvctl remove nodeapps srvctl start nodeapps [-n node_name] [-v] srvctl start nodeapps srvctl stop nodeapps [-n node_name] [-r] [-v] srvctl stop nodeapps srvctl status nodeapps srvctl enable nodeapps [-g] [-v] srvctl enable nodeapps -g -v srvctl disable nodeapps [-g] [-v] srvctl disable nodeapps -g -v srvctl config nodeapps [-a] [-g] [-s] [-e] srvctl config nodeapps -a -g -s -e srvctl modify nodeapps [-n node_name -A new_vip_address] [-S subnet/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port][,host:port,...]] [-v] srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0 srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "name_list"] [-v] srvctl getenv nodeapps -a srvctl setenv nodeapps {-t "name=val[,name=val][...]" | -T "name=val"} [-v] srvctl setenv nodeapps -T "CLASSPATH=/usr/local/jdk/jre/rt.jar" -v srvctl unsetenv nodeapps -t "name_list" [-v] srvctl unsetenv nodeapps -t "test_var1,test_var2" ASM: -------------------------------------------------------------------------------- srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile] srvctl remove asm -n node_name [-i asminstance] [-f] srvctl remove asm -n db6 srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q] srvctl start asm -n node_name [-i asminstance] [-o open] srvctl start asm -n node_name [-i asminstance] -o nomount srvctl start asm -n node_name [-i asminstance] -o mount srvctl start asm -n linux01 srvctl stop asm -n node_name [-i asminstance] [-o stop_options] [-c connect_str|-q] srvctl stop asm -n node_name [-i asminstance] [-o normal] srvctl stop asm -n node_name [-i asminstance] -o transactional srvctl stop asm -n node_name [-i asminstance] -o immediate srvctl stop asm -n node_name [-i asminstance]-o abort srvctl stop asm -n racnode1 srvctl stop asm -n devnode1 -i +asm1 srvctl status asm -n node_name srvctl status asm -n racnode1 srvctl enable asm -n node_name [-i asminstance] srvctl enable asm -n lnx03 -i +asm3 srvctl disable asm -n node_name [-i asminstance] srvctl disable asm -n lnx02 -i +asm2 srvctl config asm -n node_name srvctl config asm -n lnx08 srvctl modify asm -n node_name -i asminstance [-o ORACLE_HOME] [-p spfile] srvctl modify asm –n rac6 -i +asm6 –o /u01/app/oracle/product/11.1/asm In 11g Release 2, some command's syntax has been changed: srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring] srvctl add asm srvctl add asm -l LISTENERASM -p +dg_data/spfile.ora srvctl remove asm [-f] srvctl remove asm -f srvctl start asm [-n node_name] [-o start_options] srvctl start asm -n devnode1 srvctl stop asm [-n node_name] [-o stop_options] [-f] srvctl stop asm -n devnode1 -f srvctl status asm [-n node_name] [-a] srvctl status asm -n devnode1 -a srvctl enable asm [-n node_name] srvctl enable asm -n devnode1 srvctl disable asm [-n node_name] srvctl disable asm -n devnode1 srvctl config asm [-a] srvctl config asm -a srvctl modify asm [-l lsnr_name] [-p spfile] [-d asm_diskstring] srvctl modify asm [-n node_name] [-l listener_name] [-d asm_diskstring] [-p spfile_path_name] srvctl modify asm -l lsnr1 srvctl getenv asm [-t name[, ...]] srvctl getenv asm srvctl setenv asm {-t "name=val [,...]" | -T "name=value"} srvctl setenv asm -t LANG=en srvctl unsetenv asm -t "name[, ...]" srvctl unsetenv asm -t CLASSPATH Listener: -------------------------------------------------------------------------------- srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name] -- 11g R1 command srvctl remove listener -n node_name [-l listener_name] -- 11g R1 command srvctl start listener -n node_name [-l listener_names] srvctl start listener -n node1 srvctl stop listener -n node_name [-l listener_names] srvctl stop listener -n node1 srvctl status listener [-n node_name] [-l listener_names] -- 11g R1 command srvctl status listener -n node2 srvctl config listener -n node_name srvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME -- 11g R1 command srvctl modify listener -n racdb4 -o /u01/app/oracle/product/11.1/asm -l "LISTENER_RACDB4" In 11g Release 2, some command's syntax has been changed: srvctl add listener [-l lsnr_name] [-s] [-p "[TCP:]port[, ...][/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"] [-k network_number] [-o ORACLE_HOME] srvctl add listener -l LISTENERASM -p "TCP:1522" -o $ORACLE_HOME srvctl add listener -l listener112 -p 1341 -o /ora/ora112 srvctl remove listener [-l lsnr_name|-a] [-f] srvctl remove listener -l lsnr01 srvctl stop listener [-n node_name] [-l lsnr_name] [-f] srvctl enable listener [-l lsnr_name] [-n node_name] srvctl enable listener -l listener_dev -n node5 srvctl disable listener [-l lsnr_name] [-n node_name] srvctl disable listener -l listener_dev -n node5 srvctl config listener [-l lsnr_name] [-a] srvctl config listener srvctl modify listener [-l listener_name] [-o oracle_home] [-u user_name] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port][/SDP:port]"] [-k network_number] srvctl modify listener -n node1 -p "TCP:1521,1522" srvctl getenv listener [-l lsnr_name] [-t name[, ...]] srvctl getenv listener srvctl setenv listener [-l lsnr_name] {-t "name=val [,...]" | -T "name=value"} srvctl setenv listener -t LANG=en srvctl unsetenv listener [-l lsnr_name] -t "name[, ...]" srvctl unsetenv listener -t "TNS_ADMIN" New srvctl commands in 11g Release 2 Diskgroup: -------------------------------------------------------------------------------- srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f] srvctl remove diskgroup -g DG1 -f srvctl start diskgroup -g diskgroup_name [-n node_list] srvctl start diskgroup -g diskgroup1 -n node1,node2 srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f] srvctl stop diskgroup -g ASM_FRA_DG srvctl stop diskgroup -g dg1 -n node1,node2 -f srvctl status diskgroup -g diskgroup_name [-n node_list] [-a] srvctl status diskgroup -g dg_data -n node1,node2 -a srvctl enable diskgroup -g diskgroup_name [-n node_list] srvctl enable diskgroup -g diskgroup1 -n node1,node2 srvctl disable diskgroup -g diskgroup_name [-n node_list] srvctl disable diskgroup -g dg_fra -n node1, node2 Home: -------------------------------------------------------------------------------- srvctl start home -o ORACLE_HOME -s state_file [-n node_name] srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt srvctl stop home -o ORACLE_HOME -s state_file [-t stop_options] [-n node_name] [-f] srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt srvctl status home -o ORACLE_HOME -s state_file [-n node_name] srvctl status home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt ONS (Oracle Notification Service): -------------------------------------------------------------------------------- srvctl add ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v] srvctl add ons -l 6200 srvctl remove ons [-f] [-v] srvctl remove ons -f srvctl start ons [-v] srvctl start ons -v srvctl stop ons [-v] srvctl stop ons -v srvctl status ons srvctl enable ons [-v] srvctl enable ons srvctl disable ons [-v] srvctl disable ons srvctl config ons srvctl modify ons [-l ons-local-port] [-r ons-remote-port] [-t host[:port][,host[:port]...]] [-v] srvctl modify ons EONS (E Oracle Notification Service): -------------------------------------------------------------------------------- srvctl add eons [-p portnum] [-m multicast-ip-address] [-e eons-listen-port] [-v] #srvctl add eons -p 2018 srvctl remove eons [-f] [-v] srvctl remove eons -f srvctl start eons [-v] srvctl start eons srvctl stop eons [-f] [-v] srvctl stop eons -f srvctl status eons srvctl enable eons [-v] srvctl enable eons srvctl disable eons [-v] srvctl disable eons srvctl config eons srvctl modify eons [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-v] srvctl modify eons -p 2018 FileSystem: -------------------------------------------------------------------------------- srvctl add filesystem -d volume_device -v volume_name -g diskgroup_name [-m mountpoint_path] [-u user_name] srvctl add filesystem -d /dev/asm/d1volume1 -v VOLUME1 -d RAC_DATA -m /oracle/cluster1/acfs1 srvctl remove filesystem -d volume_device_name [-f] srvctl remove filesystem -d /dev/asm/racvol1 srvctl start filesystem -d volume_device_name [-n node_name] srvctl start filesystem -d /dev/asm/racvol3 srvctl stop filesystem -d volume_device_name [-n node_name] [-f] srvctl stop filesystem -d /dev/asm/racvol1 -f srvctl status filesystem -d volume_device_name srvctl status filesystem -d /dev/asm/racvol2 srvctl enable filesystem -d volume_device_name srvctl enable filesystem -d /dev/asm/racvol9 srvctl disable filesystem -d volume_device_name srvctl disable filesystem -d /dev/asm/racvol1 srvctl config filesystem -d volume_device_path srvctl modify filesystem -d volume_device_name -u user_name srvctl modify filesystem -d /dev/asm/racvol1 -u sysadmin SrvPool (Server Pool): -------------------------------------------------------------------------------- srvctl add srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_list] [-f] srvctl add srvpool -g SP1 -i 1 -l 3 -u 7 -n node1,node2 srvctl remove srvpool -g server_pool srvctl remove srvpool -g srvpool1 srvctl status srvpool [-g server_pool] [-a] srvctl status srvpool -g srvpool2 -a srvctl config srvpool [-g server_pool] srvctl config srvpool -g dbpool srvctl modify srvpool -g server_pool [-i importance] [-l min_size] [-u max_size] [-n node_name_list] [-f] srvctl modify srvpool -g srvpool4 -i 0 -l 2 -u 4 -n node3, node4 Server: -------------------------------------------------------------------------------- srvctl status server -n "server_name_list" [-a] srvctl status server -n server11 -a srvctl relocate server -n "server_name_list" -g server_pool_name [-f] srvctl relocate server -n "linux1, linux2" -g sp2 Scan (Single Client Access Name): -------------------------------------------------------------------------------- srvctl add scan -n scan_name [-k network_number] [-S subnet/netmask[/if1[|if2|...]]] #srvctl add scan -n scan.mycluster.example.com srvctl remove scan [-f] srvctl remove scan srvctl remove scan -f srvctl start scan [-i ordinal_number] [-n node_name] srvctl start scan srvctl start scan -i 1 -n node1 srvctl stop scan [-i ordinal_number] [-f] srvctl stop scan srvctl stop scan -i 1 srvctl status scan [-i ordinal_number] srvctl status scan srvctl status scan -i 1 srvctl enable scan [-i ordinal_number] srvctl enable scan srvctl enable scan -i 1 srvctl disable scan [-i ordinal_number] srvctl disable scan srvctl disable scan -i 3 srvctl config scan [-i ordinal_number] srvctl config scan srvctl config scan -i 2 srvctl modify scan -n scan_name srvctl modify scan srvctl modify scan -n scan1 srvctl relocate scan -i ordinal_number [-n node_name] srvctl relocate scan -i 2 -n node2 ordinal_number=1,2,3 Scan_listener: -------------------------------------------------------------------------------- srvctl add scan_listener [-l lsnr_name_prefix] [-s] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"] #srvctl add scan_listener -l myscanlistener srvctl remove scan_listener [-f] srvctl remove scan_listener srvctl remove scan_listener -f srvctl start scan_listener [-n node_name] [-i ordinal_number] srvctl start scan_listener srvctl start scan_listener -i 1 srvctl stop scan_listener [-i ordinal_number] [-f] srvctl stop scan_listener -i 3 srvctl status scan_listener [-i ordinal_number] srvctl status scan_listener srvctl status scan_listener -i 1 srvctl enable scan_listener [-i ordinal_number] srvctl enable scan_listener srvctl enable scan_listener -i 2 srvctl disable scan_listener [-i ordinal_number] srvctl disable scan_listener srvctl disable scan_listener -i 1 srvctl config scan_listener [-i ordinal_number] srvctl config scan_listener srvctl config scan_listener -i 3 srvctl modify scan_listener {-p [TCP:]port[/IPC:key][/NMP:pipe_name] [/TCPS:s_port][/SDP:port] | -u } srvctl modify scan_listener -u srvctl relocate scan_listener -i ordinal_number [-n node_name] srvctl relocate scan_listener -i 1 ordinal_number=1,2,3 GNS (Grid Naming Service): -------------------------------------------------------------------------------- srvctl add gns -i ip_address -d domain srvctl add gns -i 192.124.16.96 -d cluster.mycompany.com srvctl remove gns [-f] srvctl remove gns srvctl start gns [-l log_level] [-n node_name] srvctl start gns srvctl stop gns [-n node_name [-v] [-f] srvctl stop gns srvctl status gns [-n node_name] srvctl status gns srvctl enable gns [-n node_name] srvctl enable gns srvctl disable gns [-n node_name] srvctl disable gns -n devnode2 srvctl config gns [-a] [-d] [-k] [-m] [-n node_name] [-p] [-s] [-V] [-q name] [-l] [-v] srvctl config gns -n lnx03 srvctl modify gns [-i ip_address] [-d domain] srvctl modify gns -i 192.000.000.007 srvctl relocate gns [-n node_name] srvctl relocate gns -n node2 VIP (Virtual Internet Protocol): -------------------------------------------------------------------------------- srvctl add vip -n node_name -A {name|ip}/netmask[/if1[if2|...]] [-k network_number] [-v] #srvctl add vip -n node96 -A 192.124.16.96/255.255.255.0 -k 2 srvctl remove vip -i "vip_name_list" [-f] [-y] [-v] srvctl remove vip -i "vip1,vip2,vip3" -f -y -v srvctl start vip {-n node_name|-i vip_name} [-v] srvctl start vip -i dev1-vip -v srvctl stop vip {-n node_name|-i vip_name} [-r] [-v] srvctl stop vip -n node1 -v srvctl status vip {-n node_name|-i vip_name} srvctl status vip -i node1-vip srvctl enable vip -i vip_name [-v] srvctl enable vip -i prod-vip -v srvctl disable vip -i vip_name [-v] srvctl disable vip -i vip3 -v srvctl config vip {-n node_name|-i vip_name} srvctl config vip -n devnode2 srvctl getenv vip -i vip_name [-t "name_list"] [-v] srvctl getenv vip -i node1-vip srvctl setenv vip -i vip_name {-t "name=val[,name=val,...]" | -T "name=val"} srvctl setenv vip -i dev1-vip -t LANG=en srvctl unsetenv vip -i vip_name -t "name_list" [-v] srvctl unsetenv vip -i myvip -t CLASSPATH OC4J (Oracle Container for Java): -------------------------------------------------------------------------------- srvctl add oc4j [-v] srvctl add oc4j srvctl remove oc4j [-f] [-v] srvctl remove oc4j srvctl start ocj4 [-v] srvctl start ocj4 -v srvctl stop oc4j [-f] [-v] srvctl stop oc4j -f -v srvctl status oc4j [-n node_name] srvctl status oc4j -n lnx01 srvctl enable oc4j [-n node_name] [-v] srvctl enable oc4j -n dev3 srvctl disable oc4j [-n node_name] [-v] srvctl disable oc4j -n dev1 srvctl config oc4j srvctl modify oc4j -p oc4j_rmi_port [-v] srvctl modify oc4j -p 5385 srvctl relocate oc4j [-n node_name] [-v] srvctl relocate oc4j -n lxn06 -v

Oracle_EBS_Integration_OAM11g_OID11g

http://onlineappsdba.com/ebook/Oracle_EBS_Integration_OAM11g_OID11g_sample_chapter.pdf

OAM 11g Single Sign-On and OAM 11g Cookies

http://fusionsecurity.blogspot.com/2011/04/oam-11g-single-sign-on-and-oam-11g.html

How SSO works in OAM 11g

How SSO works in OAM 11g Here at Oracle, the access management PM team gets asked a lot of questions about how Oracle Access Manager 11g works, especially about the overall SSO model, what cookies are created and what they do, and processing flows between components, and how specific component interactions work to achieve authentication and SSO. In this post, we will explore the OAM 11g SSO model. It’s quite a bit different from the OAM 10g model, especially since we now support things like server side credential collection, server-based session management, and application scoped sessions. Before we get started, it’s worth noting that OAM 11g supports the use of both OAM 10g and 11g Webgates as well as mod_osso plug-ins for Oracle HTTP Server (OHS). We support this through what we call the Protocol Compatibility Framework, which lets the OAM server communicate with and interpret protocol messages from the webtier agents mentioned above. This is an extensible framework so has the potential to support other clients or agents in the future. OAM 11g uses a combination of host cookies or domain cookies (depending on the version of Webgate you use), a server cookie, and an in-memory session store (based on Oracle Coherence technology) to maintain and correlate user session information. Since OAM 11g supports different Webgate versions and mod_osso, you will see different cookies depending on the version of Webgate being used, you will either see the ObSSOCookie (for 10g) or OAMAuthnCookie_host:port (for 11g). However in both cases, the contents of the cookies are: Authenticated User Identity (User DN) Authentication Level IP Address SessionID (Reference to Server side session – OAM11g Only) Session Validity (Start Time, Refresh Time) Session InActivity Timeouts (Global Inactivity, Max Inactivity) Validation Hash These cookies are updated periodically using an algorithm of 1/4 of idle session timeout. There are two main differences between the 10g and 11g cookies: The 10g ObSSOCookie is domain scoped and cookie encryption uses a shared key for all 10g Webgates. The 11g OAMAuthnCookie is hosted scoped and different host cookies may be issued for each resource accessed that is protected by a different 11g Webgate. Cookie encryption for each 11g Webgate is unique to that Webgate. The values of the cookies will change over the life of a user's session, however you'll notice that the Session ID that is present is a reference to the server side session object, which remains the same across the life of a session. In the typical deployment topology, you’ll have one or more Webgates deployed on web servers in the Web Tier, a variety of components deployed in the App Tier including an OAM admin server running on the Weblogic domain’s admin server, one or more OAM runtime servers deployed on Weblogic managed servers, a database to support the OAM policies, an LDAP directory against which you will authenticate users, an optional auditing database, and an optional BI Publisher instance for reporting. Using an OAM 11g Webgate in the flow, let’s recap how this works: 1) An OAM 11g Webgate intercepts the incoming request for a resource, determines whether the resource is protected, and – if it is – the OAM 11g server constructs and returns a response back to the Webgate. That response contains the authentication scheme required to authenticate the user. 2) Next the Webgate sets a cookie (called OAM_REQ) to keep track of the target/requested URL and then redirects to the OAM 11g server, which routes the request to the credential collector. The credential collector serves up the login page, which captures credentials and posts the credentials to the OAM server. The credentials are validated against the ID store configured for this particular authentication scheme. Once the credentials are validated, the OAM server creates an authentication token, the session in Coherence, and creates a server side session cookie called the OAM_ID cookie, which has details about the user, the time the session was created, the idle timeout, and session identifier to the coherence session. 3) Then the OAM server constructs a response which is encrypted with the Webgate's key and redirects to the Webgate. The Webgate decrypts the response, extracts the authentication token and the session identifier, and uses that information to set OAMAuthnCookie, which is set as a host cookie: OAMAuthnCookie_. (In this step if you are using an OAM 10g webgate, the response from the server will contain the information required to set ObSSOCookie, if you are using mod_osso, the response will contain the information required to set the OHS host cookie.) 4) When subsequent requests are made from that Webgate, the authentication token is passed by the Webgate to the OAM server, which validates the authentication token, checks the validity of the OAM_ID cookie and session timeout, and does the appropriate authorization checks. As the result of authorization checks, additional attributes may be added to HTTP Headers and passed to downstream applications. This is especially useful when asserting user identity and group or role information to downstream applications such as those running on Oracle WebLogic Server and Oracle Fusion Middleware. 5) When requesting a resource protected by a second Webgate, the request flow will be similar to the above. Webgate2 will check if the resource is protected, and get the authn scheme details from the OAM server. From there WG2 redirects to the OAM server, the OAM server checks the OAM_ID cookie, and then generates a new authentication token for WG2, creates an encrypted response using the key for WG2, and redirects to WG2. WG2 decrypts the response, extracts the authentication token and session identifiers and sets an OAMAuthnCookie as a host cookie for W courtsey : http://oracleaccessmanagement.blogspot.com/2011/03/here-at-oracle-access-management-pm.html

Install Oracle Solaris 11 VM Template

http://www.oracle.com/technetwork/server-storage/solaris11/vmtemplates-vmvirtualbox-1949721.html Installation of Oracle Solaris 11.1 Appliance in VirtualBox ------------------------------------------------------------------------- Requirements: X86 system with a minimum of 4GB RAM A minimum of 4 GB free disk space is needed for initial installation. The available space on the virtual disk can grow to a maximum of 64 GB. Instructions: ------------ 1) tar xvf OracleSolaris11_1-VM.tgz Contents are: README.txt : This README OracleSolaris11_1.ova : machine configuration file 2) Start VirtualBox application. 3) From File Menu, select Import Appliance 4) Select the OracleSolaris11_1.ova file from the directory in which the OracleSolaris11_1-VM.tgz file was uncompressed in step 1. 5) In the Appliance Import Wizard, change Appliance Import Settings to suit your system: RAM: Systems with more RAM should increase this amount (up to half of available RAM is recommended). Virtual Disk Image: Select a directory in which the image size can expand (up to 64GB). 6) Start system image. Proceed through configuration screens that prompt for hostname, timezone, default user and passwd, and root passwd. Do not choose "oracle" as a default user because it already exists as a user in the system. 7) Either log in as the default user configured in the previous step or log in as user "oracle", password "oracle". Changing the password for the user "oracle" is recommended. Notes: ----- * To install additional software, start the Package Manager by clicking on the Add More Software icon on the desktop. * A message may appear which states that a newer version of Guest Additions is available. see the following link for more information on Guest Additions: http://www.virtualbox.org/manual/ch04.html#id490876 * ntp is enabled by default. If the appliance is not able to see the NTP servers, the service can be disabled with: root# svcadm disable ntp * Link to Solaris 11 Third-Party License information: http://docs.oracle.com/cd/E23824_01/html/E25014/index.html * Download File OracleSolaris11_1-VM.tgz : 1.7GB md5: b242a9036f5b618314bed471bdc2f483

Oracle Solaris 11 VM download for Oracle Virtual Box

http://www.oracle.com/technetwork/server-storage/solaris11/downloads/index.html http://laurent-leturgez.com/2013/10/17/install-solaris-11-1-x86-64-on-a-virtual-box-vm-step-by-step/ http://unixed.com/blog/2013/07/setting-up-a-solaris-lab-virtualbox/ http://thegeekdiary.com/installing-oracle-solaris-11-in-virtualbox/

E-Business Suite 12.1.3 Templates for Oracle VM

http://edelivery.oracle.com/oraclevm https://blogs.oracle.com/stevenChan/entry/oracle_vm_virtual_appliances_available http://chavalis.blogspot.com/2014/04/installing-ebs-1223-vision-on.html https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=353883727248693&id=1620448.1&_afrWindowMode=0&_adf.ctrl-state=102bytdmxx_4 Oracle VM Virtual Appliances for Oracle E-Business Suite Deployment Guide, Release 12.2.3 (Doc ID 1620448.1) https://blogs.oracle.com/stevenChan/entry/ebs1213_oraclevm http://www.oracleappsnfusion.com/2013/01/installing-ebs-r1213-using-oracle-vm_22.html http://www.pythian.com/blog/build-an-ebs-12-2-2-sandbox-fastish-in-virtualbox-from-ovm-templates/ https://blogs.oracle.com/stevenChan/entry/oracle_vm_virtual_appliances_available

Weblogic: unable to get file lock, will retry

Weblogic: unable to get file lock, will retry You encounter “unable to get file lock, will retry” is the weblogic 10.3.5/10.3.6 admin server log while trying to start a weblogic Admin Server or Managed server Solution: Remove the AdminServer.lok or ManagedServer.lok or EmbeddedLDAP.lok file in the Oracle Middleware home $MW_HOME/user_projects/domains/servers/”Server name you are trying to start”/tmp directory.

Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1)

Oracle Hyperion Essbase and EAS Master Note [Video] (Doc ID 1328972.1) APPLIES TO: Hyperion Essbase Administration Services - Version 9.3.0.0.00 to 11.1.2.3.000 [Release 9.3 to 11.1] Information in this document applies to any platform. Added New Content on 01-Apr-2014 PURPOSE The purpose of this document is to serve as a quick reference for Essbase and Essbase Administration Services (EAS). SCOPE This Master Note is intended to provide an index and references to the most frequently used My Oracle Support Notes with respect to Oracle Hyperion Essbase Administration Services environments. This Master Note is subdivided into categories to allow for easy access and reference to notes that are applicable to your area of interest. This includes the following categories: EAS Server Issues EAS Console Issues SQL Load Issues Essbase Issues Web Browser Issues Business Rule Issues Planning Issues Analytic Provider Services (APS) Server Issues How To Articles DETAILS The Oracle EPM and BI Support Newsletter Current Edition (Document 1347131.1) is available; released quarterly it provides proactive support information on numerous product topics. The following articles will assist in troubleshooting issues with Essbase and EAS. EAS Server Issues Document 1592931.1 Externally Authenticated User Cannot Login to EAS when Password is Due to Expire Document 1467673.1 Administration Services (EAS) Fails to Start: "Failed to initialize the application eas_datasource due to error weblogic.application.ModuleException" Document 1339633.1 Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 888704.1 Error Connecting To Essbase Administration Services (EAS) Installed on a Windows 64-bit Server "EAS Server is not responding" Document 1315512.1 Essbase Administration Services (EAS) Server Is Crashing Intermittently on a Unix Server Document 1290761.1 Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" Document 948652.1 Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." Document 1223357.1 Migrating an Aggregate Storage (ASO) Outline Crashes the Essbase Administration Services Server (EAS) When Using 64 bit Installation Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 1512957.1 Unable to Connect to the Essbase Administration Services (EAS) Server, Server Not Starting Video - EAS_RDA (02:33) Trouble seeing this video? EAS Console Issues Document 1594567.1 Essbase Administration Services (EAS) v11.1.2.3 Console Does Not Work With Java 7 Update 45 Document 1484136.1 Opening an Essbase Outline or Calc Script in the Essbase Administration Services (EAS) Console is Extremely Slow and May Crash Document 1479726.1 Essbase Administration Services (EAS) Console Displays Strange/Garbage Characters in Properties Document 1342779.1 Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled Document 1328740.1 Essbase Server Crashes When Expanding Essbase Database in Essbase Administration Services (EAS) Console Document 1151474.1 Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding Document 1142474.1 Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 Document 1157266.1 Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application Document 1323193.1 Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option Document 1317100.1 Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box Document 972348.1 Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client. Document 1061868.1 Cannot Open Shared Services User Management Console from EAS Console Document 1312810.1 Essbase Client and Essbase Administration Services (EAS) Console v11.1.1.3 Do Not Work On Windows 7 Document 1064352.1 Substitution Variables Do Not Display in Essbase Administration Services (EAS) Document 875814.1 Essbase Agent Hangs When Doing a View Session in the Essbase Administration Services (EAS) Console Document 1197963.1 Windows Non-Administrator User Cannot Edit Essbase Filters or Calc Scripts in the Essbase Administration Services (EAS) Console Document 1293757.1 Unable To Connect To Essbase Administration Services (EAS) from Console. Error: "Cannot Connect to Essbase Administration Server" Document 787079.1 Error "1090004: Unable to open file" When Trying to Open Data File on Shared Network Drive Via the Essbase Administration Services Console Document 1510195.1 Essbase Administration Services (EAS) Online Help Link Fails with "Error 404--Not Found" Document 1520339.1 MaxL Script Editor in Essbase Administration Services (EAS) Does Not Accept Command for Multiple SQL Data Loads, Error: "{Rulename} does not exist" SQL Load Issues Document 1202533.1 "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Console Document 1205065.1 SQL Retrieve in Essbase Administration Services (EAS) Dimension Build Clears Field Information and Does Not Allow Subsequent Validation Essbase Issues Document 1270220.1 Essbase is Hanging When Essbase Administration Services (EAS) is Used to Create an Application Document 1062514.1 Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console Document 844320.1 EAS 9.3.1 Error message error: "109: MAXL API instance is not active" Video - ESS_RDA (04:24) Trouble seeing this video? Web Browser Issues Document 1074209.1 Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser Document 779329.1 "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser Document 1141766.1 Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) Document 1170773.1 Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " Document 1438928.1 Calcscript Run via Essbase Administration Services (EAS) Webconsole Returns Errors 1042070 & 1013080 & Times Out After 5 Minutes Despite Conf Changes to WebLogic Document 1293608.1 Essbase Administration Services (EAS) Connection Issues when Using the Web Console Business Rules Issues Document 1082284.1 Not Able to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" Document 1297976.1 Unable to see Business Rules Node in Essbase Administration Services (EAS) Document 1328483.1 Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase Planning Issues Document 1274440.1 Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console Document 1233363.1 Unable To Select a Planning Outline "Error Connecting between The EAS Server and The Planning Server" Document 1297825.1 War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server Analytic Provider Services (APS) Server Document 1314669.1 Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 Document 1083714.1 Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) Document 1127083.1 Unable To Connect To Essbase Administration Services (EAS) and Analytic Provider Services (APS) in a Distributed Environment in Version 11.1.2 How To Articles Document 968836.1 Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 Document 1305927.1 Increasing the Java Heap Setting for Essbase Administration Services (EAS) v11.1.1.x for Unix Environments Document 1286018.1 Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2. Document 968961.1 How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase Document 1136095.1 How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console Document 751857.1 Set the Essbase Administration Services (EAS) Session Timeout Interval Document 1175294.1 How To Change the Essbase Administration Services (EAS) ESSLANG setting in EPM v11.1.2 (Doc ID 1175294.1) Document 1338020.1 How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? Document 974043.1 How To Set/Increase the Essbase Administration Services (EAS) Debug Level Document 763070.1 Re-externalize Essbase Administration Services (EAS) Users Lifetime support policy: http://www.oracle.com/us/support/lifetime-support/index.html EPM Certification/Compatibility Matrix: http://www.oracle.com/technetwork/middleware/bi-foundation/hyperion-supported-platforms-085957.html To discuss this information further with Oracle Experts and industry peers, we encourage you to review, join or start a discussion in the related Essbase Communities. Oracle Essbase in communities.oracle.com Essbase in forums.oracle.com REFERENCES NOTE:972348.1 - Java Web Start Error When Launching the Essbase Administration Services (EAS) Console Via a Web Browser "Unable to load resource: http://easserver:10080/easconsole/eas_client.jar" NOTE:974043.1 - How To Set/Increase the Essbase Administration Services (EAS) Debug Level NOTE:1290761.1 - Opening Small Outline in Essbase Administration Services (EAS) Console Returns Warning "EAS Server has -1695 MB available memory, and estimated memory needed to open the outline is 0 MB" NOTE:1297825.1 - .War Files are Getting Deleted On Restart of Essbase Administration Services (EAS) on Planning Server NOTE:888704.1 - Error "EAS Server is not responding" When Connecting To Essbase Administration Services (EAS) on Windows 64-bit Server NOTE:948652.1 - Error When Logging in to Essbase Administration Server (EAS) From the EAS Console "Could not connect Administration Server. Client and server are different versions." NOTE:844320.1 - EAS 9.3.1 Error Message Error: "109: MAXL API instance is not active" NOTE:968836.1 - Increase the Java Heap Memory Size For Essbase Administration Services (EAS) on Unix Deployed with Weblogic 8.1 NOTE:968961.1 - How to Create a Successful Connection to SAP R/3 from Essbase Administration Services (EAS) for Essbase NOTE:1323193.1 - Error."Analytical Services user [%s] Authentication Fails against the Shared Services@ with Error [EPMCSS-251014: Invalid token]" if Connecting Essbase Server via EAS Console Using SSO Option NOTE:1328483.1 - Error: "Error connecting to Essbase server EssbaseCluster-1" When Trying to Connect Business Rules to Essbase NOTE:1082284.1 - Unable to View the Business Rules in Essbase Administration Services Console: "Error (1051514) Essbase failed to get roles for users and groups for applications during refresh/login sync/user sync" NOTE:1347131.1 - Oracle Business Analytics Support News Current Edition - Volume 11 : March 2014 NOTE:1315512.1 - Essbase Administration Services (EAS) Server is Crashing Intermittently on a Unix Server NOTE:1136095.1 - How to Pass the Value for the Substitution Variable in a MaxL Script and Display it with Quotes in Essbase Administration Services (EAS) Console NOTE:1274440.1 - Unable To See Planning Servers When Creating Business Rule In Essbase Administration Services EAS Console NOTE:1286018.1 - Increase the Java Heap Size For Essbase Administration Services (EAS) v11.1.2 NOTE:1233363.1 - Unable To Select a Planning Outline "Error Connecting between the EAS Server and the Planning Server" NOTE:1270220.1 - Essbase is Hanging when Essbase Administration Services (EAS) is Used to Create an Application NOTE:1061868.1 - Cannot Open Shared Services User Management Console from EAS Console NOTE:1083714.1 - Unable to add Analytic Provider Services (APS) Server in Essbase Administration Services (EAS) Console. "Cannot connect to Analytic Server. Error: Analytic Server Error (1030008): NULL argument (4) NOTE:1297976.1 - Unable to see Business Rules Node in Essbase Administration Services (EAS) NOTE:1170773.1 - Error When Launching Essbase Administration Services (EAS) Console v11.1.2 Via Web Browser "Unable to load resource: http://servername:80/easconsole/eas_client.jar " NOTE:1314669.1 - Fail to Connect to Analytic Provider Service (APS) from Essbase Administration Services (EAS) Console in 11.1.2.0 NOTE:1317100.1 - Essbase Administration Services (EAS) Console Does Not Remember the EAS Server Name in the Login Box NOTE:1205065.1 - Column Headers Defined in Data Load Rules Files Are Changing or Lost when Retrieving from a SQL Data Source NOTE:1312810.1 - The Essbase Administration Services (EAS) Console 11.1.1.3 Does Not Work on Windows 7 NOTE:1062514.1 - Cannot Use Function List to Create Essbase Filter in Essbase Administration Services (EAS) Console NOTE:779329.1 - "easconsole.jnlp" Error When Launching Essbase Administration Services (EAS) Console via a Web Browser NOTE:1338020.1 - How To Change The Default Timeout Period For Essbase Administration Services (EAS) Sessions? NOTE:1339633.1 - Essbase Administration Services (EAS) Deployment is Failing on the Second Server in a Clustered Environment NOTE:1142474.1 - Calculation Scripts Submitted From Essbase Administration Services (EAS) Console Fail With Error: Server Returned Http Response Code: 500 NOTE:1151474.1 - Special Characters Are Not Shown Correctly in the Essbase Administration Services Console (EAS) Outline as Seen Previously Without Byte Order Mark (BOM) Encoding NOTE:1202533.1 - "Error 408 [DataDirect][ODBC SQL Server Driver][SQL Server]A constant expression was encountered in the ORDER BY list, position 1" When Trying To View Table Data In Essbase Integration Services Consol NOTE:1157266.1 - Opening Calc Script in Essbase Administration Services (EAS) or Query with Large SmartList Crashes Application NOTE:1064352.1 - Substitution Variables Do Not Display in Essbase Administration Services (EAS) NOTE:1074209.1 - Errors in eas.log When Launching Essbase Administration Services Console (EAS) via a Web Browser NOTE:1342779.1 - Essbase Administration Services (EAS) v11.1.2.x: Unable to Change Essbase Database Properties, Save/Verify/Close/Help Buttons are Disabled NOTE:1141766.1 - Unable To Launch the Essbase Administration Services (EAS) Web Client v9.3.1.x From Internet Explorer 8 (IE8) NOTE:751857.1 - Set the Essbase Administration Services (EAS) Session Timeout Interval NOTE:1386679.1 - How to Set the Session Timeout Interval for Essbase Administration Services(EAS) 11.1.2.1