Home
Search results “Kill session script oracle”
How to find Oracle Database locked session using Oracle Enterprise Manager 12C
 
02:09
Video tutorial on how to find Oracle Database locked session using Oracle Enterprise Manager 12C. For more Database Administration articles and scripts go to www.aodba.com & www.verticablog.com More Articles, Scripts and How-To Papers on http://www.aodba.com
Views: 5403 AO DBA
How to Monitor Session in SQL Developer | Oracle SQL Developer Tips and Tricks
 
04:10
How to Monitor Session in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners, Oracle Database Tutorial for Beginners, Oracle SQL Developer Tips and Tricks, Oracle Tutorial for Beginners, Oracle Tutorial How to Monitor Session in SQL Developer, How to Monitor Session Using SQL Developer, How to Monitor Session in Oracle SQL Developer, How to Monitor Session Using Oracle SQL Developer, how to check number of connections in oracle, how to check active sessions in oracle, oracle sql developer real time sql monitoring, how to check active session in oracle 11g, sql developer monitor sessions table or view does not exist oracle monitor sql statements how to check query performance in oracle sql developer
Views: 1158 Oracle PL/SQL World
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2589 jbleistein11
Faster Inserts!
 
05:06
Lots of tools generate insert scripts from existing data. But here's a trick to make those inserts run MUCH faster. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Subscribe for new tech videos every week Music: Night Owl (Broke For Free) #oracle #insert #performance
Views: 452 Connor McDonald
Oracle DBA Justin - How to execute RMAN commands from an operating system file
 
07:27
How to execute RMAN commands from an operating system file
Views: 8076 jbleistein11
Oracle DBA Justin - How to wrap PL/SQL code in an Oracle database
 
15:28
How to wrap PL/SQL code in an Oracle database
Views: 16299 jbleistein11
Oracle DBA,  Create a script, 1e7
 
03:21
How to create a script
Views: 1451 hammadshams
smtp_out_server and sending mail from the database
 
08:47
blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A #smtp #utl_mail #oracle Music: Night Owl (Broke For Free) #oracle #sql #performance
Views: 342 Connor McDonald
Solved - Attempt to load Oracle client libraries threw BadImageFormatException- Close the PS session
 
04:30
Make sure you close the PowerShell ISE session window and start again in new for changes to take effect else you will continue to receive these errors Exception calling "Fill" with "1" argument(s): "Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64-bit mode with the 32 bit Oracle client components installed." At .ps1:216 char:2 + [void]$da.Fill($ds) + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : InvalidOperationException
Views: 3730 Maruti AIR Tech
Oracle DBA Justin - How to disable variable substitutions in Sqlplus
 
07:21
How to disable variable substitutions in Sqlplus
Views: 1129 jbleistein11
Oracle DBA Justin - How to disable and re-enable an Oracle database trigger
 
08:27
How to disable and re-enable an Oracle database trigge
Views: 1688 jbleistein11
Oracle 11g and RMAN substitution variables
 
03:16
You can create RMAN command files and stored scripts that accept user input at runtime. Thus, backup scripts can use RMAN substitution variables for tags, filenames, restore point names, and so on.
Views: 1546 CLEO & CUQUIN
Oracle DBA Justin - How to setup user password complexity in an Oracle database
 
13:14
How to setup user password complexity in an Oracle database
Views: 3610 jbleistein11
Oracle DBA Justin - How to define and undefine variables in sqlplus
 
16:16
How to define and undefine variables in sqlplus
Views: 1977 jbleistein11
Oracle DBA Justin - How to create a basic user account in an Oracle database
 
11:57
How to create a basic user account in an Oracle database
Views: 21260 jbleistein11
Oracle DBA Justin - How to use the public role for database objects
 
13:14
How to use the public role for database objects.
Views: 1601 jbleistein11
How to upgrade SQL Developer to 19.1
 
02:02
blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) Kevin McLeod (incomptech) #oracle #sqldeveloper #upgrade
Views: 432 Connor McDonald
Oracle Forms opening slowly Troubleshooting
 
06:22
https://amzn.to/2Ph2CbI [affiliate link] We are back again with some issues and solutions. Actually one of my friends asked me regarding performance tuning if forms are opening slow. That time I gave him some ideas and promised him that I will back very soon with some more information. There are lots of factors which may impact the applications but there are some work around which can helpful fixed the issues. One more thing I would like to tell, friends I shared my knowledge’s as per my real time experiences and real life experiences. So, there is not like just copying and pasting the stuff. As already I have shared my real life time stories which I have learned from my life. So, let’s start now. Suppose, our forms are opening slow then what things we should be check and how to debug it. I will try to explain here and share my knowledge. I am sure; it will be useful because it’s having been experienced. 1. We should check which forms are opening slowly either any particular form or all forms. 2. If all forms are opening slowly for particular machine then clear the cache and try again. It can be machine speed slow, machine hardware and bandwidth speed. If all forms are opening slow and for all machine then we really need to check below things such as: A. Check whether Trace is enabled or disabled and if it is enabled then kindly disabled it. B. Check the top commands if any resources are consuming high CPU usage. C. Check for all Inactive Sessions if it’s there then kill those sessions. D. Check for deadlocks. E. Every user should close the forms and logout properly. But actually we don’t care. We just close windows tab at a time and left for break :D :P but that’s also impact our EBS internally. F. A programmer if ran any program with infinite loops then this also cause a performance issue. That’s why we need to write any program carefully. If program not properly then it may cause deadlock as also which I have explained it in my previous posts. G. It can also be because of increasing the number of users. Also need to check users have one active session. H. Check for the Performance Pack (Native I/O) is turned on for WLS. And most and always we use this method. If the users have issue for any custom forms then we should follow below steps which are easy and very effective. When he run the program that time you should follow below steps: 1. Enable the Trace file. Login to front-end - Help - Diagnostics - Trace - "Trace with Binds and waits” . Then there will be a trace file generate under below patch: $cd $ORACLE_HOME/admin/$CONTEXT_NAME/udump Now you can run either Trace Analyzer or tkprof as shown below commands: Trace Analyzer command: $sqlplus apps/apps_password SQL START TRCANLZR.sql UDUMP ora-data_ora1919.trc; TKPROF command: $ORACLE_HOME/admin/$CONTEXT_NAME/udump $tkprof ora-data_ora_1919.trc ora-data_ora_1919.txt explain=apps/apps_pwd Hope this may useful and helpful. We will come back again with new troubleshooting and solution as what we should do if forms opening slow after increasing the number of session. For any concerns or suggestions please reach to us either by comment box or contact us @ ora-data.blogspot.com.
Views: 2133 ORACLE SUPPORT
Oracle DBA Justin - How to multiplex RMAN backup pieces when running a backup
 
13:00
How to multiplex RMAN backup pieces when running a backup
Views: 4330 jbleistein11
Create & Destroy Sessions - Log In and Log Out in PHP
 
06:44
In this video I will illustrate a functional example of creating and destroying a session on a web site. The web site will consist of a login and a log out page.
Views: 36080 Ken Swartwout
Oracle DBA Justin -  How to re-create a dropped/deleted data dictionary view
 
08:34
How to re-create a dropped/deleted data dictionary view
Views: 1995 jbleistein11
Finding and Killing Connections in Postgres
 
05:09
In this episode Josh Branchaud will show you how to kill idle connections in PostgreSQL. To learn more and for full transcript visit us at https://www.pgcasts.com This episode is sponsored by Hashrocket a consultancy specializing in PostgreSQL. Visit us at https://hashrocket.com
Views: 1185 PG Casts
Kill session and require logout test
 
01:55
Recorded with ScreenCastify (http://www.screencastify.com), the screen video recorder for Chrome
Views: 415 Fabian Brussa
Oracle DBA Justin - What happens to transactions when the sqlplus program is closed
 
06:39
What happens to transactions when the sqlplus program is closed
Views: 1640 jbleistein11
Oracle DBA Justin - How to clone an Oracle database not using RMAN
 
20:23
How to clone an Oracle database not using RMAN
Views: 61649 jbleistein11
Oracle DBA Justin - How to drop/delete a user account from an Oracle database
 
07:41
How to drop/delete a user account from an Oracle database
Views: 5735 jbleistein11
USER MANAGEMENT HOW TO LOCK UNLOCK EXPIRE USER ACCOUNT IN ORACLE
 
06:51
HOW TO LOCK_UNLOCK_EXPIRE USER ACCOUNT IN ORACLE ================================================= alter user naveen account lock; alter user naveen account lock password expire; alter user naveen account unlock; alter user naveen account unlock password noexpire; alter user naveen identified by newpassword; HOW TO RESET USER PASSWORD TO PREVIOUS EXPIRED PASSWORD (Admin related) ======================================================= select name,password from user$ where name='NAVEEN'; alter user naveen identified by values '&encrypted_values'; HOW TO CHANGE USER PASSWORD FROM USER SIDE ===================================== password
Views: 694 Praveen Biyyapu
Oracle DBA Justin - How to reset the log sequence number in an Oracle database
 
10:39
How to reset the log sequence number in an Oracle database
Views: 5267 jbleistein11
SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE
 
04:54
This is preview of SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE. You can sign up for the training here: https://sqlbits.com/information/event18/21_Essential_Scripts_Performance_Tuning_for_EVERYONE/trainingdetails Reach out to me personally, if you want me to deliver this course for your organization exclusively.
Views: 992 Pinal Dave
The rules of werewolf game (for JINROU TLPT)
 
04:56
“Werewolf” is the party game, which you try to find a liar, who is pretending to be on your side, by having a conversation. _______________________________________________________________ ◆JINROU TLPT http://oracleknights.co.jp/english/contents.php#tlpt “Werewolf” is kind of a party game. You find a liar among the players by discussing and debunk. The play is consisted of 3 parts such as the opening, discussion time and the ending. The opening is performed by actors. “Werewolf, it is such an abominable existence. at the night with the full moon, it pretends to be someone who it had eaten by the mysterious charm of the moonlight, and prey on families or fiends every night, .” 3 werewolves who pretend to be villagers are disappeared into a small village. The villagers decide to kill those wolves to keep up the village however they are old friends and all of them seem so familiar. You get to see people’s conflict. From discussion time(game time) , there is no script. In fact, actors are passed on each different roles’ of cards 15 min before the play starts so that they have their own roles. Every performance, your role might be different. Sometimes you are a “werewolf” and sometimes you are a “villager”. You only know your own role and don’t know others’. You think/infer by discussing as improv, trust, betrayed, and penetrate others. For example, at today’s performance, there is a scene like “Mary convinces that her sister is a werewolf and killed her with other villagers. However she was a villager not a werewolf. After knowing the truth, Mary cried out in a loud for regretting. But Mary might be the “werewolf”!” Mary’s sister could be a werewolf for tomorrow’s performance! The biggest attraction of this play is that each performance has a completely different story. Ending is also developed by the actors as improv. Who would survive? Can villagers beat all the wolves? 《Attraction of Jinrou TLPT》 ✥ Audiences think together… All the audiences respond to who are the wolves, in the middle of the performance. ✥ Ghost time… the actors who were doubted and eliminated/ killed during the play come out and explain the rule or get the situation straight or make a free conversation. So even some of them get eliminated from the performance, they still have a chance to be on the stage. ✥Free view of the world… By changing the purpose along the themes, TLPT performances are possible to correspond to unlimited view of the world. The picture below is the theme of“ Shinsengumi” the Japanese representative samurai.
Views: 3691 Oracle Session
Oracle Database Tutorial 53 : Data pump expdp - How to Export tablespace in Oracle Database
 
06:26
Oracle Database tutorial/SQL Tutorial 52 On Data Pump expdp export utility here in this tutorial you'll learn how to export tablespace using expdp export (a.k.a. How To Take Logical Backup of tablespaces in oracle database). Data pump expdp Tablespace Mode ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/export_tablespace_expdp_datapump Previous Tutorial (Tut 52 Full export) http://youtu.be/K8_PjUksT54 ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at [email protected] Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 33417 Manish Sharma
PHP Login Form with Sessions and MySQL
 
10:36
In this video, I will demo how to create PHP Login Form with Sessions and MySQL ====================================================== You can see and download source code demo from my Apps at https://play.google.com/store/apps/developer?id=PMK+Lab ====================================================== You also can buy my apps in http://codecanyon.net/user/octopuscodes/portfolio ====================================================== You also can read my blog in http://learningprogramming.net/ ====================================================== You also can learn Microsoft Office in https://www.youtube.com/channel/UCFrMOR6KF4cpa92OOPRyOng ====================================================== TODAY IS A GREAT DAY TO LEARN SOMETHING NEW! ====================================================== Finding Software videos help you watch reviews for Open Sources:Joomla, wordpress, drupal, magento, html template, free admin template, free bootstrap admin templates, SilverStripe, Cake PHP, CodeIgniter, Concrete5, Modx, ExpressionEngine, Alfresco,TYPOlight, laravel, magento, angularjs, node.js, html, css, javascript, jquery, java, .net, wamp server, xampp, php, mysql, sql server, oracle, open sources, android, hibernate, jpa, html5, jquery
Views: 127308 Learning Programming
PASS Pre Con - 21 Essential Performance Tuning Scripts
 
03:28
21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs Please register quickly as seats are limited - http://bit.ly/passperf18 Additional information: https://blog.sqlauthority.com/2018/04/12/sqlpass-pre-con-21-essential-scripts-jump-start-performance-tuning-for-accidental-dbas/
Views: 1416 Pinal Dave
How to solve ORA-01940: cannot drop a user that is currently connected
 
06:12
This video demonstrates how to solve the ORA-01940 cannot drop a user that is currently connected error. This error is raised when we try to drop a user that is connected to the database or having an active connection to the database. We will demonstrate a solution in which we would kill the user that is connected to the oracle database by its serial# and PID. This tutorial will guide viewers on how to kill an active session and then drop the user. If you would like to look at more such videos please visit www.youtube.com/c/kishanmashru Visit our blog at www.oracleplsqlblog.com
Views: 1573 Kishan Mashru
Keynote Live Stream: Oracle Code Bengaluru
 
01:56:27
https://developer.oracle.com/code/bengaluru-april-2018
Views: 1457 Oracle Developers
Oracle WebLogic Server & EBS R12.2 Q/A: JVM, Heap, GC, Stack, Thread Dump
 
56:23
More details at http://k21academy.com/live13 We recently had a Masterclass on Oracle WebLogic Server covering What, Why & How at http://k21academy.com/weblogic02 in that webinar there were a lot of questions. Most of these questions were answered in Webinar however not all questions were covered because of time. We'll be adding these questions over a period of time in Private Facebook Group for WebLogic Server at http://k21academy.com/weblogicqa This post covers weekly live show on our Facebook Page at http://facebook.com/k21academy covering Oracle WebLogic Server and issues reported with WebLogic Server in Oracle EBS R12.2 asked in WebLogic Masterclass at http://k21academy.com/weblogic02 Question Asked "I am working on Oracle EBS R12.2.3, My Questions is that OACore managed server is going into warning state frequently. I've increased Java Heap Size from 1 GB to 2 GB but still getting the same error sometimes. After collecting Garbage, it will be OK, but want to resolve the issue permanently. Need You Guidance ... Q1: What would you do in a situation like this? Q2: What is JVM & Heap Size in JVM? Q3: How do you know what is Heap Size Value and How do you change the value of Heap from 1GB to 2 GB? Q4: What is Garbage Collection and How Often you should run it? Q5: What does parameter -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize mean when you start JVM? I've covered all this in this video Here is what Atul Covered in Weekly Live Show 00:00-8:18: Introduction & Welcome 8:18-15:47 What is WebLogic Server & Task Performed by WebLogic Admins 15:47-17:15 Q: Managed Server in EBS (R12) going in Warning State 17:15-30:06 Oracle E-Business Suite R12.2 Architecture, WebLogic Domain, Admin & Managed Server, Config Files for Domain in EBS R12.2 30:06 - 41:00 What is JVM, JVM Parameters like -Xms, -Xmx, -XX:PermSize, -XX:MaxPermSize, Garbage Collection - GC (Major / Minor), JVM Tuning Guidelines, Q/A 41:00- 50:00 Heap, Stack & Thread Dump, Warning State issue in EBS R12.2 for Managed Server 50:00-56:14 Wrap-Up and FREE Training Now back to the original question If you are in a situation like this, How would you troubleshoot or approach to fix the issue (Leave a comment and see If you can help others https://www.youtube.com/watch?v=Zmd96z-5qO0 More details at http://k21academy.com/live13
Views: 5183 K21Academy
PHP Login page with session
 
13:00
This Video will guide you how to use session in login page.
Views: 1426 Programming Funday!
Query Parameter in Oracle Datapump
 
19:05
Hello Friends Today, In this video I used to show you How to Used Data pump Query Parameter. In Query Parameter we can take export backup using particular query. Suppose iwant to take a export backup of EMP table but in this table i want to take backup only department no 20. so it is possible . please watch this video and subscribe In Some Methods i am showing you. Method 1: (Using Parameter File) ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Create Par file. ------------------------------------------------------------ directory=dump dumpfile=d1.dmp tables='SCOTT . TEST' query=TEST:"WHERE deptno=20" ---------------------------------------------------------------- Save this file test.par --------------------------------------------------------------- 3. Go to Command Prompt Export expdp system/admin parfile='/u01/app/parag/test.par’  Import impdp system/admin directory=dump dumpfile=d1.dmp tables=‘SCOTT . TEST‘ ------------------------------------------------------------------------------------- Method 2: ------------------------------------------------------------ 1. Create Table Test. (Create table scott.test as select * from scott.emp;) 2. Go to Command Prompt Export expdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ’ query=TEST:\”WHERE deptno=20\”  Import impdp system/admin directory=dump dumpfile=d2.dmp tables=‘SCOTT . TEST ' -----------------------------------------------------------------------------------------------------------
Views: 642 Parag Mahalle
USER MANAGEMENT CREATE USER DROP USER   CASCADE
 
07:46
USER MANAGEMENT HOW TO CREATE A USER ===================== create user naveen identified by naveen; create user pavan identified by pavan default tablespace king; HOW TO DROP USER ================= drop user naveen; (it will work if no objects) drop user pavan cascade; HOW TO GRANT ORACLE PREDEFINED ROLES TO USER ============================================ grant connect,resource to naveen; select * from session_privs; set lines 180 pages 200 col username for a30 select username,default_tablespace,temporary_tablespace from dba_users where username like '&user';
Views: 446 Praveen Biyyapu
Kill process in kali linux with command
 
00:47
Find process id Open terminal: ps -a | grep firefox kill ProcessID
Views: 2793 Linux How To
Oracle DBA Justin - How to reset RMAN persistent parameters back to their defaults
 
06:47
How to reset RMAN persistent parameters back to their defaults
Views: 2702 jbleistein11
Session Time Out - TMOUT - BASH - Linux
 
03:34
http://filmsbykris.com/wordpress/?p=118 Got Questions? visit http://FilmsByKris.com/forum Chat with us and learn more http://FilmsByKris.com/irc
Views: 3258 Kris Occhipinti
Using nohup to allows jobs to continue on logout
 
04:04
More videos like this online at http://www.theurbanpenguin.com Running jobs overnight may well be useful to you, especially if it going to take some time, if you can't schedule it to start then start it before you go home with nohup, you can then log off and the job continues in the background even though you are eating tea and toast at home
Views: 14501 theurbanpenguin
Oracle DBA Justin - How to disable user password sensitivity.
 
08:09
How to disable user password sensitivity.
Views: 2757 jbleistein11
Creating Multiple user with default password
 
12:56
Default password for multiple user with shell script. This can help you to manage users on real time.
New features for DBAs in Toad for Oracle
 
10:48
http://Software.Dell.com/Toad-Oracle Learn about the new features specifically for DBAs within Toad for Oracle, Dell Software's solution for increased development and administraton productivity in Oracle.
Views: 213 Dell EMC Support
How to install cluster Pacemaker on linux CentOS 7 for SQL Server High Availability
 
26:23
How to Install cluster pacemaker on linux CentOS 7 for SQL Server High Availability video explains below Validating Nodes IP address Disable firewall and SELINUX (for Installation Only) -- Not Recommended for Prod Installing pacemaker Configuring Cluster User, i.e. hacluster Starting and Enabling Pacemaker services Adding members node to cluster Creating and starting cluster Confuring cluster resources a) Virtual IP of the cluster b) Apache Services -httpd-- Just to test the failover cluster Create Constraint of cluster resources Test Fail-over Script used in this video: #How to create Pacemaker Cluster on Linux CentoS 7 # IP Configuration verification of all possible nodes # installing httpd to verify in the end of cluster on both nodes yum install httpd -y # Disable SELINUX and Firewall vi /etc/sysconfig/selinux Change SELINUX=enforcing to Permissive and save the file on both nodes and setenforce 0 systemctl stop firewalld systemctl disable firewalld # Install Pacemaker software on both nodes yum install pacemaker pcs fence-agents-all -y # Once installed, you will see user created named hacluster - we need reset the password for this user on both nodes tail /etc/passwd --- To see if user is created passwd hacluster # Start and Enable PaceMaker Services on both nodes systemctl start pcsd systemctl enable pcsd # Add membership of the cluster using hacluster username pcs cluster auth TBSLinuxNode1 TBSLinuxNode2 -u hacluster # Create Cluster named "LinuxSQLCluster" in my case pcs cluster setup --name LinuxSQLCluster TBSLinuxNode1 TBSLinuxNode2 # View Configuration of the Cluster on both nodes Cat /etc/corosync/corosync.conf #Start the cluster pcs cluster start --all #Check the status of the cluster and enable the cluster pcs status pcs cluster enable -all # Configure the resources of the cluster a) Virtual IP of the cluster pcs resource create VirtIP IPAddr ip=192.168.1.102 cidr_netmask=24 op monitor interval=60 b) apache services (To check the failover, not necessary for SQL Server) pcs resource create Httpd apache Configuration="/etc/httpd/conf/httpd.conf" op monitor interval=60s -- # Check the status again to see if resources are configured right and you will notice both resources are created and in stopped state # Let's create Constraint and Policies on the cluster pcs constraint colocation add Httpd with VirtIP INFINITY pcs property set stonith-enabled=false pcs property set no-quorum-policy=ignore pcs property set default-resource-stickiness="INFINITY" # Check the status again to see if resources are online pcs status # Check virtual IP on active node ip a # Now let's create an HTML page to see where which node our resources are running vi /var/www/html/index.html #Type anything for example Hey I am TBSClusterNode1 (if creating on TBSLinuxNode1 in my case) etc. and save it on each node # Now let's view the page using IE or any browser # Let's failover the cluster and recheck the html page file we just created pcs cluster stop TBSLinuxNode1 (If it is running on node1, if node2, stop cluster services on that node)
Views: 284 TechBrothersIT
Informatica : Infra Installation On Linux Part6  - Restarting Oracle And Infra Services
 
12:44
If your Infra Admin Console web page is not appearing, please try to restart Oracle and Informatica Services..
Views: 1232 Mandar Gogate