Oracle database admin

ORACLE DATABASE ADMIN COURSE CONTENT Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in ORACLE DATABASE ADMIN COURSE CONTENT 1: Creating the Database 2: Starting Up and Shutting Down • Viewing the Quiesce State of an Instance • Suspending and Resuming a Database 3: Managing Oracle Database Processes • Terminating Sessions • Identifying Which Session to Terminate • Terminating an Active Session • Terminating an Inactive Session 4: Monitoring the Operation of Your Database • Server-Generated Alerts • Monitoring the Database Using Trace Files and the Alert Log • Monitoring Locks • Monitoring Wait Events • Process and Session Views 5: Oracle Database Structure and Storage • Managing Control Files • Managing the Redo Log • Managing Archived Redo Logs 6: Managing Table spaces Transportable Table spaces 7: Managing Data files and Temp files 8: Managing the Undo Table space undo retention, switching undo table space 9: User management creation of users and roles, assign privileges 10:Automatic Storage Management create ASM instance, create disk groups 11:Managing Schema Objects • Tables, indexes, views, synonyms and sequence generator • Space management • Managing resumable space allocation, reclaiming wasted space • Managing Tables • adding, renaming and dropping of table columns • Managing Indexes • B*tree, bitmap • Managing Partitioned Tables and Indexes • Range, hash,list and composit partitioning • Managing Clusters • creation and altering of clusters • Managing Views, Sequences, and Synonyms • Oracle Network • Listener and tnsnames • Distributed Database Concepts • Utilities • Data pump , SQL*Loader • Backup and Recovery • Rman • Performance Tuning • Data Guard • configuring physical standby database • Miscellaneous Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN Class Room Training, ORACLE DATABASE ADMIN Training in Magarpatta City, ORACLE DATABASE ADMIN Jobs and Placement, ORACLE DATABASE ADMIN Remote Support, ORACLE DATABASE ADMIN Online Help, ORACLE DATABASE ADMIN Videos training, ORACLE DATABASE ADMIN Training by Learning Hub, Fast track classes in ORACLE DATABASE ADMIN, Best ORACLE DATABASE ADMIN Training institutes in Pune, Best Faculty in ORACLE DATABASE ADMIN, Best online Faculty in ORACLE DATABASE ADMIN, Professional classroom training in ORACLE DATABASE ADMIN, Professional online training ORACLE DATABASE ADMIN, ORACLE DATABASE ADMIN Certification , ORACLE DATABASE ADMIN training in Dubai, ORACLE DATABASE ADMINTraining in Melbourne, ORACLE DATABASE ADMIN Training in Dubai, ORACLE DATABASE ADMIN Training, ORACLE DATABASE ADMIN Workflow Training ORACLE DATABASE ADMI Training, ORACLE DATABASE ADMI Online Training, ORACLE DATABASE ADMIN certfication and support

Overview: Oracle Database 12c introduces a new multitenant architecture that makes it easy to deploy and manage database clouds. Innovations such as Oracle Multitenant, for consolidating multiple databases quickly, and Automatic Data Optimization with Heat Map, for compressing and tiering data at a higher density, maximize resource efficiency and flexibility. These unique advancements, combined with major enhancements in availability, security, and big data support, make Oracle Database 12c the ideal platform for private and public cloud deployments. ABOUT ECORPTRAININGS: Ecorp Trainings are one of the best institute providing quality level of training in E-learning process.This is instructor led online training. We also provide corporate training , if group of people interested in same technology. Contact us for detailed course content & register for a free demo. We also provide support in client interviews , resume preparation , ticket resolving. Contact us for custom designed training course by experts exclusively for yourself. We provide training for almost all IT technologies i.e ; JAVA , DOTNET , SAP ,ORACLE , PEOPLESOFT ,HYPERION etc, contact us if you have any particular need. ECORP TRAININGS. Gtalk ID : ecorptrainings Skype ID : ecorptrainings

We offer you Oracle database 11g training in Noida where you learn database ideas specifically to an oracle database furthermore as regarding the applying of those database ideas to the oracle database server and surroundings. Multisoft Systems B - 125, Sector-2, Near Sector 15 Metro Station, Noida (U.P.)-201301 (India) (+91) 120 2540300 / 400 (+91) 9810306956 info@multisoftsystems.com http://www.multisoftsystems.com/ http://www.multisoftsystems.com/training/6-weeks-industrial-training-in-oracle

SOA ADMIN Training in Hyderabad @Sadguru Technologies Ph: 8179736190 What is Oracle Fusion ADMIN? We are providing Oracle Fusion ADMINISTRATION under Yashwanth, MTech, and Technical Manager in CMMI Level 5 Company with 9+ years of middleware experience, successfully placed above 800 members in 1 year. We provide sufficient lab facility and also 24/7 online Lab facility.

Oracle SOA Training ( Administration)@Sadguru Technologies-8179736190 This course gives indepth knowledge on how Oracle SOA Suite 11g, a component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management) for designing, deploying, and managing Service Oriented Architecture (SOA) composite applications. You will learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. You’ll learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. You will cover how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery, and you will get a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. We are providing Oracle Fusion ADMINISTRATION(Web Logic & SOA ADMIN) under Yashwanth, MTech, and Technical Manager in CMMI Level 5 Company with 9+ years of middleware experience, successfully placed above 800+ members in 1 year. We provide sufficient lab facility and also 24/7 online Lab facility, Student can connect from home to do the LAB practical’s.

Oracle SOA Training ( Administration)@Sadguru Technologies-8179736190 You will learn how to install and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. You’ll learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. You will cover how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery, and you will get a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. We are providing Oracle Fusion ADMINISTRATION(Web Logic & SOA ADMIN) under Yashwanth, MTech, and Technical Manager in CMMI Level 5 Company with 9+ years of middleware experience, successfully placed above 800+ members in 1 year. We provide sufficient lab facility and also 24/7 online Lab facility, Student can connect from home to do the LAB practical’s.

Oracle SOA Training ( Administration) This course gives indepth and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. You’ll learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. You will cover how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery, and you will get a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. We are providing Oracle Fusion ADMINISTRATION(Web Logic & SOA ADMIN) under Yashwanth, MTech, and Technical Manager in CMMI Level 5 Company with 9+ years of middleware experience, successfully placed above 800+ members in 1 year. We provide sufficient lab facility and also 24/7 online Lab facility, Student can connect from home to do the LAB practical’s. Address: SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, Sai Manor Apartment, S.R. Nagar Main Road, Landmark: Beside Umesh Chandra Statue, Hyderabad-500038, Mob: 91-8179736190,Ph: 040-40154733.

Oracle WebLogic Server 11g Administration@ 8179736190 Duration: 25hours What you will learn This course trains Web administrators on techniques for installing and configuring Oracle WebLogic Server 11g. It alsotrains Web administrators to deploy Java EE applications to Oracle WebLogic Server 11g using Administration Consoleand command-line and scripting tools like WLST. Course Objectives: • Describe the architecture of WebLogic Server including domains, servers and machines • Install, configure and use WebLogic Server • Perform routine Oracle WebLogic Server administration functions • Set up a cluster of servers and distribute applications and resources to the cluster • Configure Oracle HTTP Server as the Web-tier front end for Oracle WebLogic Server instances and clusters • Deploy different types of Java EE applications to Oracle WebLogic Server •

sadguru technologies 8179736190 ​We are Providing Level 1 & 2 (Essential & Advanced) Trainings on Oracle Fusion Middleware 11g Admin, OIAM Admin, Oracle SOA 11g Admin, Web Logic Admin (Classroom & online) Training By working in CMMI Level 5 Company with 8 years of Middleware Admin Experience. Successfully placed so many members as SOA Administrators and Weblogic Administrators in CMM Level 5 companies in last 3 Years. We are providing Real Time Lab facility with excellent infrastructure i.e. with the required tools for Administrators to get the Real Time exposure. Offered Courses: 1) Oracle Fusion Middleware 11g Admin 2) Oracle Weblogic 11g Essential and Advanced Admin 3) Oracle SOA 11g Admin (Weblogic + SOA) 4) Oracle OSB 11g Admin (Weblogic + OSB) 5) Oracle Web center 11g Admin (Weblogic + Web center) 6) Oracle Identity and Access Mgmt Admin 7) JBoss Administration 8) OBI 11g 9) Apache Tomcat Administration 10) SOA Development 11SCM build and release Special Feature: We are providing Real Time Lab facility with excellent infrastructure i.e. with the required tools for Administrators to get the Real Time exposure. Features: Job oriented real time Training. Exercise Real time project explanation & Practical Resume preparation & Work Assistance.

We are Providing Trainings on Oracle Fusion Middleware 11g SOA Development, Oracle SOA 11g Admin, Web Logic Admin (Classroom & online ) Training By MR.YASHWANTH working in CMMI Level 5 Company with 12 years of Middleware Admin Experience. Successfully placed so many members as SOA Administrators and Weblogic Administrators in CMM Level 5 companies in last 3 Years. We are providing Real Time Lab facility with excellent infrastructure i.e with the required tools for Administrators to get the Real Time exposure. Offered Courses (Class Room & Online):  Oracle ADF training  Oracle Service Oriented Architecture(SOA) suite11g Development  Web Logic & SOA Administration  Oracle Service Bus (OSB)  Oracle Application Integration Architecture (AIA)  Oracle Business Process Management (BPM)  Oracle Applications Framework (OAF)  Web Sphere Application Server (WAS)  Oracle Billing & Revenue Management (BRM)  Sales Force CRM  Siebel CRM  Business Analyst (BA)  JAVA  Oracle Identity Access Management (OIAM)  Oracle Data Integrator (ODI)  Web Center  Oracle Apps (Functional, Technical)

We are Providing Trainings on Oracle Fusion Middleware 11g SOA Development, Oracle SOA 11g Admin, Web Logic Admin (Classroom & online ) Training By MR.YASHWANTH working in CMMI Level 5 Company with 12 years of Middleware Admin Experience. Successfully placed so many members as SOA Administrators and Weblogic Administrators in CMM Level 5 companies in last 3 Years. We are providing Real Time Lab facility with excellent infrastructure i.e with the required tools for Administrators to get the Real Time exposure. Offered Courses (Class Room & Online):  Oracle ADF training  Oracle Service Oriented Architecture(SOA) suite11g Development  Web Logic & SOA Administration  Oracle Service Bus (OSB)  Oracle Application Integration Architecture (AIA)  Oracle Business Process Management (BPM)  Oracle Applications Framework (OAF)  Web Sphere Application Server (WAS)  Oracle Billing & Revenue Management (BRM)  Sales Force CRM  Siebel CRM  Business Analyst (BA)  JAVA  Oracle Identity Access Management (OIAM)  Oracle Data Integrator (ODI)  Web Center  Oracle Apps (Functional, Technical) For New Batch Contact Us: Mob: 08179736190 (OR) Mail: SDTECH.SOA@GMAIL.COM

sadguru technologies 8179736190 ​Course name : WEBLOGIC11G 24*7 technical support faculty : Realtime experience Rs Trainings:is a brand and providing quality online and offline trainings to students in world wide. We are giving best online training on WEBLOGIC Highlights in our training service: Every faculty has Real Time experiance .Trained Resources placed in countries like Australia, USA, UK, JAPAN, SWEDEN etc.Any critical issues faced by resource resolved using Teamviewer, webex.Supporting the resource with Top 100 Interview questions. Résumé built in best corporate standards according to the job description. We will market the resume for top technolgy countries.After each week a status exam is conducted. Offline online trainings are conducted everyday.Weekend trainings for job goers.flexible timings in accordance with the resource comfortability.If version related to any Tool is upgraded. We will send the upgraded information via email.we will develop the Aquintance with Production,development and testing environments.Real time scenarios covered accross Software Development Life Cycle.for every 10 hours One hour catered to resolve the doubts.Explaining bugs and critical issues and development activities 24*7 technical supports sevices. Course content: WEBLOGIC ADMINISTRATION 11G ( on Linux Environment ) Description An enterprise application consists of various components and resources such as Enterprise JavaBeans, Servlets, JSPs, Database Connections, HTML files, XML files, etc. After application developers finish developing the various components, it is the system administrator's job to put everything together into the WebLogic Server environment and make it available to users at Web browsers. As a WebLogic Server Administrator, you are responsible for, among other things: • Starting and stopping servers • Balancing the load on servers or connection pools • Selecting and monitoring the configuration of resources • Detecting and correcting problems • Monitoring and evaluating system performance • Deploying Enterprise JavaBeans, Web Applicatio

knowledge on how Oracle SOA Suite 11g, a component of Oracle Fusion Middleware, provides a complete set of service infrastructure components (such as Mediator, BPEL, Human Workflow, Business Rules, and Business Process Management) for designing, deploying, and managing Service Oriented Architecture (SOA) composite applications. You will learn how to install SADGURU TECHNOLOGIES provides SOA Training for Administrators as well as Developers. Oracle SOA suite is part of the Fusion Middleware Stack that Oracle has released recently. Currently SOA is one of the hottest profiles in Middleware market. Oracle SOA Training ( Administration) This course gives indepth and configure Oracle SOA Suite 11g components in Oracle WebLogic Server domains. You’ll learn to use the Oracle Enterprise Manager Fusion Middleware Control Console to perform administrative tasks such as deploying SOA composite applications, configuring SOA composite application resources, monitoring SOA composite applications, managing and monitoring service engines, and updating the state of SOA composite applications. You will cover how to troubleshoot SOA composite applications by performing corrective actions such as fault recovery, and you will get a brief introduction to tuning and configuring Oracle SOA Suite 11g environment for high availability. We are providing Oracle Fusion ADMINISTRATION(Web Logic & SOA ADMIN) under Yashwanth, MTech, and Technical Manager in CMMI Level 5 Company with 9+ years of middleware experience, successfully placed above 800+ members in 1 year. We provide sufficient lab facility and also 24/7 online Lab facility, Student can connect from home to do the LAB practical’s. Address:

WHAT IS WEBLOGIC :? WebLogic Server contains Java 2 Platform, Enterprise Edition (J2EE) technologies. J2EE is the standard platform for developing multitier enterprise applications based on the Java programming language. The technologies that make up J2EE were developedcollaboratively by Sun Microsystems and other software vendors, including BEA Systems. online ) Training By MR.YASHWANTH working in CMMI Level 5 Company with 12 years of Middleware Admin Experience. Successfully placed so many members as SOA Administrators and Weblogic Administrators in CMM Level 5 companies in last 3 Years. We are providing Real Time Lab facility with excellent infrastructure i.e with the required tools for Administrators to get the Real Time exposure. Offered Courses (Class Room & Online): Ø Oracle ADF training Ø Oracle Service Oriented Architecture(SOA) suite11g Development Ø Web Logic & SOA Administration Ø Oracle Service Bus (OSB) Ø Oracle Application Integration Architecture (AIA) ØOracle Business Process Management (BPM) Ø Oracle Applications Framework (OAF) Ø Web Sphere Application Server (WAS) ØOracle Billing & Revenue Management (BRM) Ø Sales Force CRM

I often get mails from people asking what are the questions generally asked in Weblogic by interviewers. Generally for an Administrator’s positions, in addition to Weblogic questions, there are a lot of Unix questions and a few questions related to process and case handling. These are the important questions that I cover while interviewing. 1. How do you differentiate between a server hang and server crash issue? When a Server crahes, the JAVA process no longer exists. When the Server is hung, it stops responding. We can use the weblogic.ADMIN utilty to ping the server. In case of a hang situation we can take multiple thread dumps and analyze the cause of hang. 2. What can be the various reasons for a server crash? a) Native IO b) SSL Native Libraries c) JVM d) Supported Configuration e) JDBC Driver issue 3. How do you troubleshoot a crash? JVM crash generates a hs_err_pid file. We need to look into the stack trace of the hs_err_pid file . If the thread is from a native io, we need to disable native io. if the stack trace is from the driver, we need to get in touch with the drive team. Quite possibly its a problem with driver. Changing the type of driver can be a workaround. If the thread shows it coming from an optimzed code, we can turn of optimization. If the stack is from native calls of application, its a bug with the application and it has to b modified. 4. Ho do you troubleshoot Server Hang? We can use java weblogic.Admin PING to check if we get a normal response. We need to take multiple thread dumps with kill -3 pid on unix and CTLR Break on Windows. Analyze the thread dump to find the root cause. 5. What can be the reasons of Server hang? Memory leak, databse query taking a long time to return, Deadlock. 6. What is memory leak? Memory leak is when objects are not romved from the heap even when they are not required. 7. What are the various causes for OUT OF MEMORY? a) Insufficient heap size, not able to match the extra load. b) Objects licing too long, like HTTP Sessions. c) Memory leak in application code. d) Full GC not happening due to JVM Bug. 8. How to troubleshoot and overcome such issues? Gather memory data by enabling GC verbose. If its due to Http Session, timing out http session after certain interval might help. Look into the code for jdbc connection handling. Optimizing the heap size according to the load. 9. When does High CPU Usage occur? It occurs when one process or one thread utilizes unexpectedly high proportion of CPU. 10. How to troubleshoot it? In Solaris environment, we need to take pstack and prstack and see what the threads are doing. In Windows we need to use pslist and process explorer. 11. What is Clustering and what is achieved through it? Clustering is the grouping together of servers for the purpose of high availability and scalability. Load balancing and Failover is achieved. 12. How does Cluster Communication Happen? Members of the Cluster communicate over the Cluster Multicast IP and Port by sending periodic heart beat messages. 13. What is the difference between the Sun JVM and BEA JRockit JVM? The most well know JVM is the implementation from Sun. The Sun JVM is called HotSpot. The Sun JVM is shipped in the Java Developer’s Kit (JDK) and Java Runtime Environment (JRE) from Sun. The BEA JRockit JVM from BEA systems is optimized for reliability and performance for server side applications. To achieve this, BEA JRockit JVM uses technologies such as code generation, hot spot detection, code optimization, advanced garbage collection algorithms and tight operating system integration. 14. TUning JVM Parameters. If you have a single processor, single thread machine then you should use the serial collector (default for some configurations, can be enabled explicitly for with -XX:+UseSerialGC). For multiprocessor machines where your workload is basically CPU bound, use the parallel collector. This is enabled by default if you use the -server flag, or you can enable it explicitly with -XX:+UseParallelGC. If you’d rather keep the GC pauses shorter at the expense of using more total CPU time for GC, and you have more than one CPU, you can use the concurrent collector (-XX:+UseConcMarkSweepGC). Note that the concurrent collector tends to require more RAM allocated to the JVM than the serial or parallel collectors for a given workload because some memory fragmentation can occur.