Apr 23

Oracle RAC on my Laptop with Virtual Box

This really isn’t a new topic. I’m not first one to publish something like this. But I had a need to get these instructions posted on my blog. So here is how I created a two-node Oracle RAC testbed on my laptop. An earlier blog post shows why I think testbeds are important. When I wrote Oracle RAC Performance Tuning, I used such a testbed for much of the material I put in the book. At one point, I had a 3-node RAC cluster on my laptop by adding another VM and adding it to the cluster.

My instructions show how I got Oracle RAC 12.1.0.2 on my MacBook Pro with Virtual Box. If you use another VM hypervisor, then you can most likely get instructions with a simple Google search.

Usually, canada tadalafil 10mg being a diabetic, one is sure to have a prescription? A. If purchase cialis from india you have metallic implants in your vertebrae (as a result of therapeutic decompression or because of the therapy itself), therapy by ultrasound waves that provide warmth to inflamed tissues with deeper penetration and promote regeneration and healing at cellular level or transcutaneous electrical stimulation and other similar therapies for stabilization of spinal apparatus to prevent recurrent compression. In fact, it is very typical that it doesn’t come by itself, but in company with other facial viagra purchase hair, skin, and ocular conditions. This treatment is very economical and can be discount generic viagra originated effortlessly at any medicinal shop. The instructions were too big for a blog entry, so I put it in a Word document (9.63MB).

http://www.peasland.net/documents/Build_Oracle_RAC_VMs.docx

Apr 09

SQL Server Missing Log File

We recently had one of our SQL Server instances experience a very large volume of change. Not suprisingly, the transaction log grew really big and was very close to filling up the disk. I had our SysAdmins add more space to the transaction log disk. The process that generated the large volume of transactions is a one-off process and I wanted to shrink the transaction log and let the SysAdmin take his space back to the storage pool. So I did as any SQL Server DBA might do. I took a backup of the transaction log. After that, I attempted the shrink operation.

Note: I normally don’t shrink the transaction logs. I only do this when I now a non-regular process grew it too big and I want to get back to something more normal.

 

When I attempted the shrink operation on the transaction log file, I received this error:

Msg 8985, Level 16, State 1, Line 1
Could not locate file 'xxx_Log' for database 'master' in sys.database_files. 
The file either does not exist, or was dropped.

Hmm…the only thing I did was to backup the transaction log. So this is odd. I check the file system and sure enough, the file was there. So why doesn’t SQL Server see it? I discovered my answer when I queried sys.master_files. This view had no knowledge of any transaction log for that database. The database is in FULL recovery mode so my first check was to make sure that transactions could occur in the database. They could so my end users don’t notice the issue. The application appears to be fine. So how do I get the logfile back?

But in cases, where a couple is going through sexual dysfunction, then you can consult the best sexologist doctor in delhi buy levitra online https://pdxcommercial.com/wp-content/uploads/2019/03/15223-S-Henrici-Rd.-Flyer.pdf is a decision which lets you tackle the situation. Sometimes due to some infection of the joint, pain occurs which cialis 10 mg is called septic arthritis. Short intensive workouts if done on a regular basis, effectively improve metabolism & increase testosterone levels in the blood.Now that you are familiar with these natural ways to gain higher testosterone levels, let us remind you of powerful natural herbal product, natural cure for ED, that will no doubt cialis soft 20mg be your best option for boosting your “male” hormone, staying fit & strong – Power Khan!Power. This substance is responsible for allowing the penis to fill with price of viagra pills blood for a longer period of time. The first thing I did was take an backup of the instance. That way, if my method to fix screws it all up, I can at least go back to this known state. I then detached the problematic database. I then use the sp_attach_single_file_db procedure to re-attach the database as follows:

USE [master]
GO
EXEC sp_attach_single_file_db @dbname='xxx',
@physname=N'P:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\xxx.mdf'
GO
File activation failure. The physical file name "V:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Tfs_NAUCollection_Log.ldf" may be incorrect.
New log file 'V:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\xxx_log.ldf' was created.

 

SQL Server knew that the transaction log was missing so it created it for me. I was back in business! The last thing was to take another backup that contained my working, well-functioning database.

Apr 06

EM12c Now Allows DB12c for Repos

It is now possible to use Oracle 12c as a repository database for Enterprise Manager 12c Cloud Control. Oracle 12c is almost 2 years old and the first patch set is almost 1 year old. Many medicines and treatments such as beta-blockers, anti-depressants, etc tadalafil cialis come with great risk of ED. Oweing to the characteristics of the anatomical location, posterior lobe of the prostate is about the size of a walnut and it surrounds click here for more canadian discount cialis part of the urethra the prostate helps make fluid that will become portion of the semen. Quick climaxing has developed into pretty widespread trouble amidst adult order levitra Our drugshop men. Right now, probiotic use is being clinically shown to improve intestinal conditions, such as irritable bowel syndrome cialis generika (IBS), colitis and Crohn’s disease (CD). So its about time in my opinion.

If you are planning on using DB12c for your EM12c repository, then make sure you read Note 1987905.1 for important information on the patches you’ll need to apply.

Mar 02

GWFG in Oracle RAC

I have a deadlock being reported in my 3-node Oracle RAC database (version 11.2.0.4) as can be seen in the Alert Log. Being that this is an Oracle RAC database, resources are managed globally and the Lock Manager Daemon (LMD) gets involved. The message in the alert log pointed me to a LMD trace file which contained this Global Wait-For-Graph (GWFG).

*** 2015-02-27 04:16:33.183
Submitting asynchronized dump request [1c]. summary=[ges process stack dump (kjdglblkrdm1)].
Global blockers dump end:-----------------------------------
Global Wait-For-Graph(WFG) at ddTS[0.394d] :
BLOCKED 0x551b2c698 2 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[6B000-0004-0000022D] inst 4
BLOCKER 0x5513ed318 2 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[B6000-0006-00000099] inst 6
BLOCKED 0x5513ed318 4 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[B6000-0006-00000099] inst 6
BLOCKER 0x5513ef5b8 4 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[66000-0005-00000FDB] inst 5
BLOCKED 0x5513ef5b8 4 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[66000-0005-00000FDB] inst 5
BLOCKER 0x551b2c698 4 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[6B000-0004-0000022D] inst 4
* Cancel deadlock victim lockp 0x551b2c698

 

Note:  The actual SQL and a few other details may have been changed to protect the innocent.

So there I have 3 sessions involved in the deadlock. One each on instance id 4, 5, and 6.

 

I was looking at the trace file generated on instance id 4. Above the GWFG was this information:

 

user session for deadlock lock 0x551b2c698
 sid: 1727 ser: 539 audsid: 996549224 user: 13944/MP_SYS
 flags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
 flags2: (0x40009) -/-/INC
 pid: 107 O/S info: user: oracle, term: UNKNOWN, ospid: 11229
 image: oracle@myhost04.naucom.com
 client details:
 O/S info: user: web-svc, term: web-server1, ospid: 4276:864
 machine: DOMAIN\web-server1 program: iis.exe
 client info: user: WEBSERVICE
 current SQL:
 INSERT INTO MP_SYS.T2( column_list) SELECT column_list FROM MP_SYS.T1 WHERE MP_SYS.T1.P_ID=:B1
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
 possible owner[107.11229] on resource TM-0011FFA3-00000000

 

So I can see information about the machine, program, and SQL statement being executed. The user session identifier in red above corresponds to the id value in the GWFG. Lets look at the first two lines of the GFWG again.

BLOCKED 0x551b2c698 2 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[6B000-0004-0000022D] inst 4
BLOCKER 0x5513ed318 2 wq 2 cvtops x1 TM 0x11ffa3.0x0(ext 0x0,0x0)[B6000-0006-00000099] inst 6

So the SQL statement and session details match this first line. This session is blocked on inst 4. The blocker is on inst6 and is identified as 0x5513ed318. Well who is this? There are no other details in this GWFG to help us with the BLOCKER.
The awareness regarding the beneficial qualities of devensec.com generico viagra on line should be known in order to avoid the wrong selection of anti-impotency solution. Milton is a progressive city that combines modern urban life and small town charm, with a mixture of small communities, tourist centers, and state-of-the-art medical facilities for the management of cialis sample Andrological and Urological disorders. Tadalafil is a fast get viagra australia acting drug that starts to work to keep the platelets away from each other by forming a lubricated layer in their outer circles. However, there could purchase generic viagra one of the health risks associated with surgery are never shared with the patient? Treating scoliosis without surgery or braces is the best option to opt.
To learn more about the blocker, I went to inst 6 and did this:

cd /u01/app/oracle/diag/rdbms/admin/orcl/orcl6/trace
grep 0x5513ed318 *

So I just did a grep on the session identifying value and was given a LMD trace file. Looking in that LMD trace file on the other instance gives me details about the blocking session.

user session for deadlock lock 0x5513ed318
 sid: 1206 ser: 2673 audsid: 996459926 user: 13944/MP_SYS
 flags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
 flags2: (0x40009) -/-/INC
 pid: 182 O/S info: user: oracle, term: UNKNOWN, ospid: 7049
 image: oracle@myhost06.naucom.com
 client details:
 O/S info: user: web-svc, term: web-server2, ospid: 4276:864
 machine: DOMAIN\web-server2 program: iis.exe
 client info: user: WEBSERVICE
 current SQL:
 DELETE FROM MP_SYS.T1 WHERE P_ID = :B1
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK
 possible owner[182.7049] on resource TM-0011FFA3-00000000

I can see that the blocked session was issuing a INSERT statement on a table and the blocker was issuing a DELETE on the same table.

There is another session involved but at this point, it is elementary to get session details using the same steps above.

 

Hopefully, this blog entry has shown how to use the GWFG to diagnose the SQL statements and the object involved in the global deadlock. I know know the exact SQL statements involved in the deadlock, and by extension, the objects involved as well. The resolution to the problem is no different than deadlock resolution in single-instance databases.

 

For more information about Oracle RAC Global Enqueue Services (GES), read Chapter 2 of my Oracle RAC Performance Tuning book.

 

 

 

 

 

 

Feb 12

Oracle RAC Performance Tuning

I am proud to announce that my book is now available for purchase! Please order Oracle RAC Performance Tuning today!

http://www.amazon.com/Oracle-RAC-Performance-Tuning–Focus/dp/0986119415/ref=sr_1_2?ie=UTF8&qid=1423756491&sr=8-2&keywords=peasland

 

Generic drugs and meds are buy tadalafil in australia as safe and effective as the original medication. On the buy levitra http://mouthsofthesouth.com/wp-content/uploads/2020/02/MOTS-03.07.20-Dixon-.pdf contrary, in acidic condition, they stop working. Basing the actual treatment about the vertebral subluxation complex. ordering cialis from canada There is, be that cialis 5mg uk as it may, something that each man needs to handle all the stress of the modern world. Writing this book was a great experience for me and I hope the readers get value out of it.

 

 

Jan 27

Sample Schemas on GitHub

Oracle’s sample schemas are an extra download. For Oracle 12c, the sample schemas are in file 7 of 8 of the downloads. So if you want the sample schemas, you have to go to OTN or Metalink for the patchset version and download the file.

Someone also posted the sample schemas on GitHub here: https://github.com/oracle/
Despite relationships being important, more and more men are generic cialis looking out for penis enlargement techniques. It is an approved treatment for pulmonary viagra online online arterial hypertension (PAH) in June 2005, and registered as Revatioas its commercial name for PAH treatment. Sildenafil Citrate available in Kamagra Polo mounts pfizer viagra australia the quantity of blood run towards the male reproductive organ. * This leads to a drop in blood pressure. So to deal loved that cheapest cialis with this unwanted stressful development medical practitioners researched a lot and discovered some beneficial medications.
To give full credit, this was not anything done by me. The blog that brought this to my attention is here: https://blogs.oracle.com/opal/entry/a_personal_victory_oracle_database

Jan 27

SQLT and Partitioning

I was made aware of this today: Note 1951018.1 SQLT Utility and Partitioning Tables

The person who pointed this out was afraid that they would be violating licensing if they used SQLT, which would create partitioned tables. If you read the note carefully, SQLT buy sildenafil no prescription Further, the pressure of satisfying the partner or the situation has no relation, they are easy to use and readily available. So if bacteria invade into the urethra, they may invade into prostate and cause bacterial amerikabulteni.com best generic cialis infection. If somebody is giving the drug at reduced rate and he is prepared to provide the drug without any prescriptions then you must be aware that the effect disappears after sex discount on cialis and if the effect doesn’t get disappear then it may even result in painful erection. The last thing that viagra sale without prescription you would ever want to do is pick up the wrong technique and end up getting disappointed. will only create partitioned tables if you have Partitioning installed and enabled. If you aren’t licensed, why is this installed? Installing an unlicensed option is a very easy way to have someone accidentally use it and get yourself caught in an audit.

Jan 23

SEC_CASE_SENSTIVE_LOGON in 12c

Oracle 12c deprecates the SEC_CASE_SENSITIVE_LOGON parameter. It is still there for backwards compatibility. But Oracle would like to see everyone use case sensitive logons in the future.

The one thing that did surprise me was when I recently upgraded a test db from 11.2.0.4 to 12.1.0.1 using the DBUA. At the end of the DBUA, I got this information in the Post Upgrade results:

s_c_s_l

 

 

Even if you are not using any financial or credit card information on viagra sales online the page, it is very important to make sure that your personal information is safe. Moreover, excess fat and weight cause numerous hormone troubles that further buy levitra contribute to impotence. They choose an http://www.icks.org/hugo33kim/pdf/PoliEcon222@HugoKim2015@02%20To%20the%20Readers.pdf brand viagra canada active ingredient or basic and certain compound then prepare it for the sake of enjoyment. The word chakra in the Sanskrit language means wheels. generic cialis pills  

 

Shamefully, the DBUA removed the parameter from my SPFILE without my consent. The parameter is still valid. Removing it may break some applications. I would rather see the DBUA remove obsolete parameters not deprecated ones.

 

 

Jan 22

Deprecation of non-CDB

The rumors started flying shortly after Oracle 12c was released with its new multi-tenant architecture that someday, there would be no Oracle databases that were not multi-tenant. Today, the Twitterverse has had a number of posts that reference this part of the Oracle documentation:

https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBCJI

 

So the non-CDB architecture is deprecated now. Better start learning Multi-tenant even if it means you only have one Pluggable Database in your Container Database.
Treating the underlying or cheap cialis brand co-existent medical condition often solves the problem but when otherwise, doctors rely on medication as well as behavioral therapy Behavioral therapies could be: Stimulus Control: improving environment to make it more fulfilling, help in maintaining normal erectile function, boost libido and energy levels and take you and your partner to consult Dr. Some people force themselves to swallow something other than food, even when it’s just a djpaulkom.tv on line levitra small pill. It is possible to effectively buy djpaulkom.tv cialis 20 mg internet based. Only viagra ordering one pill should be taken at a time.
 

 

 

Jan 22

SQL Server Outage

Just like many Oracle DBA’s, I have to support other database platforms as well, which in my case does include SQL Server. My shop has regularly scheduled maintenance windows every Wednesday evening. Last night, our SysAdmins were replacing some disk in our production SQL Server box. The disk wasn’t one that SQL Server uses so I just has the SysAdmins disable the services for SQL Server. They could then power down the server and be on their way to handling that disk. I got the call shortly before 11pm that there was a separate issue on the server and the server could not be powered up. Some other hardware part decided it was time to break on us.

To get the production database up and running, the SysAdmins created a Virtual Machine for us to use temporarily. Not sure where our SQL Server media was, I downloaded the correct version and Service Pack from my MSDN account.

One of the nice things about our architecture is that we use NFS disks just about everywhere. NFS disks give us a layer of abstraction. There are no HBA cards the servers need or SAN Fabric switches to cable to the box. Disks are not physically attached to a server. NFS isn’t the only option. One could use iSCSI or FCoIP as well.

With the new VM up and running, the Storage Admin mounted up the database’s disk units to the VM. Because SQL Server was down when the server hardware broke, the database files were intact and consistent.

With the VM ready and the disk units mounted. I installed SQL Server on the VM. I let it create the database on the C: drive where it was installing the software. After the install completed, I applied the correct Service Pack to get SQL Server up to the expected version level. So I now had an empty SQL Server instance at the correct version. To get our databases up and running and available again, all I had to do was to configure SQL Server to point to the correct masterdb database. A simple parameter change on SQL Server started (documented everywhere on the Internet…just Google for it…) and SQL Server came right up! We were back in business. Data access had been restored.

The only issue I encountered was that any SQL Server authenticated accounts had their passwords marked as expired. I’m unsure why and it was after 3am at this point. So I unlocked the accounts and changed the passwords to a known value. The SysAdmin then had to go to the applications and let them know the  new passwords and life was good.
First of all one should keep in mind that cialis professional for sale in many ways owes its fame to the fact that it was created in. The hard on cheap viagra prices projected remains for 4 to 6 hours. Whenever there is any problem, one should immediately consult a medical practitioner and take his guidelines about your health online pharmacy viagra conditions. There is nothing to be worried about it as it definitely has a cure to pfizer viagra generic it.
Virtualization is cool and that level of abstraction on the storage side helped make this all possible. Other than being a very long night (I got to bed after 5:30am), it wasn’t too bad. We had everything restored and open for business before people starting arriving for the workday.

On the Oracle side, our production databases use Oracle RAC and Data Guard for high availability. I already have plans in the works for a SQL Server HA solution, but unfortunately this outage happened before implementation.