Oracle Automation / Cloud

+++++++++++++++++++++++++++++++++++++++ ++ +   Create a TimesTen in memory database     +++ +++++++++++++++++++++++++++++++++++++++   Assumption: TimesTen database software has been installed Oracle user has been used for TimesTen installed. So OS user Oracle is the administrator user for creating TimesTen database. 1. Define a Data Source Name (DSN) ============================== DSN defines the configuration of the database and must be defined before creating Database.     Modify the sys.odbc.ini [Add DSN anywhere in the ODBC DATA Sources section]   2. Specify New data Source definition =================================== edit sys.odbc.ini to add source definition and save Driver - location of the TimesTen direct linked ODBC driver DataSource - location and name of the database files LogDir - directory for the transaction logs PermSize - Permanent partition of the database size in M...

12c Testing Audit Features for Data Pump and RMAN jobs

First Down load software from OTN http://www.oracle.com/technetwork/products/timesten/downloads/index.html?ssSourceSiteId=ocomen I have downloaded : TimesTen 11.2.2.5.0 for Linux x86 (64-bit) Unzip and tar the installation software    Run the installer by running setup.sh I have used default Instance name,  Select [1] for both the Data Manger and Client components; Then define the TimesTen software directory to be installed For TimesTen in memory database to start up automatically after reboot we need to run ./setuproot -install Setup the environment variable Check the database daemon and processes are running So installation has been completed successfully.    

The What-if command (eval, predict)  is the 12c clusterware new features. This feature is used to determine the impact of cluster operations without actually executing these commands.Administrators can use these commands to analyze and determine the impact of a certain operation before actually executing the operation and minimizes the potential risk. Check what will happen if we delete server, rac2 -------------------------------------------------- [oracle@rac1 bin]$ ./crsctl eval delete server rac2 Stage Group 1: -------------------------------------------------------------------------------- Stage Number    Required        Action --------------------------------------------------------------------------------      1              Y           Resource 'ora.ASMNET1LSNR_ASM.lsnr' (rac2) will ...

In Oracle Flex ASM architecture, Oracle ASM instances can run only a small number of cluster nodes. These ASM instances are connected by all the database instances on the cluster to provide storage access for all these database instances. When an ASM instance fails, the database instances reconnect to other ASM instances for the failed ASM instance. This features supports the platform for variety of application which includes RAC with large number of nodes. There is a new type of network, ASM network with Flex ASM which is used for communication between ASM and its clients. ASM network is accessible from all nodes. In oracle Flex Cluster, the nodes are arranged in two ways i.e. Hub Node and Leaf Node. Hub Nodes : tightly connected with each other like standard configuration and have direct access to the shared storage. Leaf nodes: Leaf nodes can be added as many as more and can host different applications other than hub nodes. This type of nodes doesn't require direct ac...