This was not the first installation of this nature and in this manner we have done but in this case, we found that quite close to the end of the installation we noticed the Analysis Services component did not start on the and the installation failed effectively.
Fig. 1 SQL Server Analysis Services StartUp Failed
Note that Database Engine services had been installed and was up and running both on SQL Server Configuration Manager and on the Failover Cluster Manager. The error we got on the front end was this:
Unable to read parameters from registry for Service '(null)'. Error: 13, property in error is 'ServiceName'.
As part of troubleshooting we removed the /Q parameter and ran the command again. This gave the opportunity to view the GUI in detail for the error. We still got the error at the end of the installation and had to dig into the Windows Event Log where we found the error below after filtering for errors with MSOLAP$<Instance_Name> as Source:
The service cannot be started: File system error: The following error occurred during a file operation: Access is denied. . (\\?\K:\INST5_AVAYA_DATA_01\DATA\CryptKey.bin).
We were able to solve this by granting full control of the parent folder for this file Cryptkey.bin to the account NT SERVICE\MSOLAP$<Instance_Name>. As at now we do not knw whey the permissions were not automatically granted but once we retried the started on the installer (an option we had because we resorted to GUI), the installation completed successfully.
Fig. 2 SQL Server Analysis Services StartUp Successful
“Climb and get some for them … that is how you earn their respect and love”
A Senior Officer at Ekiti State NYSC encouraging me to climb a mango tree to get mangoes for my female colleagues. To me that was ancient wisdom on how to really win a woman’s heart and what it means to be a man not just a male. It struck me more because I often perceived him as one who was always joking yet there was this hidden wisdom in him.
“If you always tell the truth you do not have to remember what you said last”
Mr. Ibraheem Salau back when we worked together at Airtel Nigeria. I was particularly struck by this because some Christians do not have this firm position about telling the truth especially in the workplace when their jobs of professional reputations are at stake. It was a challenge to me as a Christian.
“I know what happened. You were depending on old anointing”
My Mum after I had failed to deliver a sermon in church as expected even though everyone else clapped. Only those who know you well ans really love you will tell you the truth. Sycophants are always clapping for you up to when you fall flat on your face. True friends who love you can tell you your flaws to you face even at the risk of losing you.
“If you read the bible very well, you will discover you are not supposed to abandon him”
Rev. Alan Okumeng Mensa when I asked his counsel on an elderly person whom I perceived to be bothering me with incessant requests for assistance. Some burdens are heavy but necessary and they are the true test of our claims of godliness.
Hope you read something striking! Feel free to share statements from people around you that have stuck with you over the years.
Let’s start with the definitions of these Recovery Manager errors
RMAN-05502: the target database must be mounted when issuing a DUPLICATE command RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
In Oracle’s database duplication, who is the target? The Target is actually the source database that you are trying to duplicate. The auxiliary is the destination. Thus when establishing a connection for the purpose for configuring Oracle Dataguard for example you must connect to BOTH instances in one statement:
It is very important to realise that you are connected TWO databases in ONE RMAN session thus any command you issue affects BOTH. For example suppose you issue a dumplicate command as below:
RMAN > duplicate target database for standby ;
and get this error:
RMAN-05001 auxiliary filename /usr/datafile/users03.dbf conflicts with a file used by the target database
This occurs because you have not used DB_FILE_NAME_CONVERT in your parameter file and your data files are on the same path in both TARGET and AUXILLIARY. You then decide you need to circumvent this this by add the NOFILENAMECHECK clause since you want to maintain the uniform paths and overwrite the AUX database. To start all over again you shutdown the instance(s) from the same RMAN session! Big MISTAKE! You just shutdown your LIVE database.
This results in the confusing scenario where you attempt the duplicate command again and get:
RMAN-05502: the target database must be mounted when issuing a DUPLICATE command
You issue alter database mount: in the very same RMAN session and try the duplication command again and then get:
RMAN-05500: the auxiliary database must be not mounted when issuing a DUPLICATE command
Be careful when issuing shutdown database form RMAN
Understand who the TARGET is and who the AUXILLIARY is
It’s 2018 and I should start by saying “Happy New Year and thanks for stopping by”.
One of the things we are pursuing this year is the penetration of our new book Entangled in the ever-so-competitive world of literature. We worked very hard on pre-sales publicity starting October 2017 and we did get some support thanks to VentSell and Wigal (our USSD Code Provider). It is really fun to use technology to do something seemingly ordinary.
During the launch we took it a step further and streamed online, allowing friends to share in our effort and equally be inspired to pursue their own gifts. I really enjoyed the Book Launch and we really didn’t have to spend so much. Ever so grateful we are to friends who helped out. It is simply an awesome thing to have people around you who give their time and talents to assist one pursue their dreams. Whatever you do, find great friends.
Social Media? Amazing. Chris Greenwood taught me a cool way to grow Facebook audience which worked in an amazing manner. It help reach uncharted regions. In the course of this publicity we also got to meet good supporters right here in Ghana. Even out YouTube Channel has seen significant growth since the launch of Entangled.
Challenges? Yup, we had them. From printing errors to illness to technical flaws with our streaming, challenges are part of our journey to greatness. It is all part f the story. Whatever you are pursing on this planet, expect difficulty. If grows you. We thank God we are overcoming overcomers. We have a story to tell those who are coming after us.
After all the efforts we finally started reaching the bookshops and the reception has been quite encouraging. The feedback from the earlier book Till Death also nudged us on to put in more effort. People are actually reading the books, I mean people asides our friends and family. It is just awesome. That alone is enough inspiration to write more. So far Challenge Bookshops and Dreams & Visions have given the best returns and we are grateful. It can only get better.
Entangled. Wow. Virtually everyone who has read it has said they could hardly drop the book. They want more. I am looking forward to make more time to write “If I Were to Live Again”, “Mission West Africa”, “I Survived” , “The Thought Compendium” , “Alternatives: The Spouse I Never Had” and so on. Ideas are brewing and it is just a matter of time.
OK. Signing out today’s scribble, I do hope to read your feedback on Amazon, Smashwords, our Facebook Page or YouTube Channel after you read Entangled. Thank you and whatever you do, express yourself!
Warning: The series on this blog can be considered my private studies and are still in progress.
New Heaven and New Earth
The concept of Heaven and Earth is interpreted by some as meaning the Jewish system of worship. This appears to be corroborated by Jesus’ reference saying not one word of the law passes away except Heaven and Earth pass away. This statement would mean that it was necessary for the Temple and state of Israel to pass for the New Covenant to be in force. This apparently “preterist” view of the meaning of Heaven and Earth (passing away) is necessary for the book of Revelation to be interpreted as it is by Preterists. It also appears to align with Daniel’s prophecy concerning Jesus’ Kingdom as one that has no end and came to destroy Rome. (assuming we leave out the concept of a gap of unknown length some people call the “Times of the Gentiles”.
Another fact that must be true in other for this view to align is that the book of Revelation must have been written before 70 A.D. Another interesting factor seeming to agree with this is the presence of the Kings of the earth and the “glory of the gentiles”. This would mean the New Jerusalem coming out of Heaven from God was actually the present day Church. In addition, Rev. 21:16 states the city was twelve thousand furlongs (2414.0208km) in length, breadth and height. It is the height that is scary.
There is a strong emphasis on the fact that the Bible was written to Jews for the most part and most of the terminology is based on Jewish culture. Regarding Heaven, Earth and Sea, authorities in the Preterist circles point to Josephus (Josephus, Wars of the Jews, 5.215-37, Josephus, Antiquities, Book 3, Chapter 6, Paragraph 4, Section 123, Josephus, Antiquities, Book 3, Chapter 7, Paragraph 7, Section 181). If this is true then it explains what Jesus said in the following:
Matthew 24:35 “Heavenandearth will pass away, but My words will by no means pass away.”
Matthew 5:18 “For assuredly, I say to you, till heavenandearth pass away, one jot or one tittle will by no means pass from the law till all is fulfilled.”
Revelation 21:1 “[ All Things Made New ] Now I saw a new heavenand a new earth, for the first heavenand the first earth had passed away. Also there was no more sea.”
A lot of other scriptures refer to the expression “heaven and earth” and this direct interpretation may seem tricky for someone them though.
The first time I met Kenny, was at an interview about four years ago. A few of the things that carried across to me as the interview progressed, were his sincerity, intelligence and then this feeling of someone with a mission on his heart.
I saw the graphics of the book cover “ENTANGLED ” before reading the book. I was captivated by the attractive, well designed cover. My initial thoughts after admiring the cover design was, “Don’t judge a book by its cover.” I decided to start reading a little of the book during my 30 minutes lunch break with the intention of continuing with the reading in the evening.
… Big “mistake”…
My curiosity got the better of me as I couldn’t put the copy down and kept flipping page after page till I had found out the outcome of the choices made by our protagonist. I finished reading the book by that evening.
Entangled is a real page turner and will get the reader hooked right from the very first page through till it ends. Kenny manages to portray some of the very real challenges of present day life in ENTANGLED.
The reality of these challenges is the heart of the whole story. The desperation of our protagonist, Phillip to live an exemplary life. The frustration of re-occurring failure to the challenges he faces. His awareness and acceptance of standards of morality that are acceptable to the Creator. Presumptions of people that lead to feelings of having been “Led on”.
Peeling off the first layer of the entertaining pastime “Entangled” offers, the reader will identify the many faucets of life’s personalities represented here in the names of Helen, Zainab, Phillip, Abena, Hassan and even Victoria.
Highlighting the weakness in human strength, the dangers of allowing sin to snowball and grow bigger; Entangled has some really good life lessons for the young adults and above.
Within a short time from the outset of Entangled, Kenny makes it look effortless as he skillfully takes the reader into the heart of the challenge making the reader empathize with the protagonist, admiring him for setting his own boundary lines, and silently screaming at him for decisions he considers taking that could lead him to cross same.
The writer manages to ease the tense, fast paced narrative by slipping in some side splitters. The way the story ends is another skillful mark of a great story teller. Entangled is a great piece of work and there is no doubt that this writer is getting better with each book he writes.
In closing, I can confidently say that the well written contents of the book “Entangled” and the meaningful cover design of the book, deserve each other. This is one case where it would be fair to judge a book by its cover.
For a 6-hour flight, a trip on a bus or train, a case study that groups of young adults and above could read and discuss its life lessons or just a relaxing weekend read, the perfect book and companion would be…
Mr. Daniel Ayittey is the CEO and Principal Architect at Diseño Cisne which he runs with his brilliant wife, Xola.
When I first started attending church in Ghana back in 2012, I used to buy the CD for every message preached on Sundays. Before then I already had a large collection of CDs which I carried from Lagos. I remember William Ilenikhena asked me once back at Covenant Christian Centre why I bought the message every Sunday. You know those why questions we often fail to ask ourselves, don’t you? While I did not give a ready answer to that question then, I had imagined that it was necessary to have a record of every message preached in Church even though I got the point of his question: It was more important to have the message inside one, the parts relevant to one.
Recently I began to question the usefulness of every message I have ever heard from the likes of Dr. Mensah Otabil and Pastor Poju Oyemade who have been my Main Senior Pastors For the past ten years or so. I am not questioning their usefulness because the messages themselves are querstionable. They certainly are all extremely powerful contributions of these great minds/spirits. But I am asking myself what I have actually done with those useful messages. I asked myself the same question about every professor in whose class I sat back in school, about the over a hundred and fifty books in my current library and many others in my past read and unread.
Every now and then in the office or other fora we find grown men arguing about what is accurate knowledge in certain fields and what is not. At the end of the day one person or the other concludes that they are right. But then what does it mean to be right? What is the value of being right? What is the value of knowledge? Is the physical, emotional and mental exertion we exercise in these discussions meaningful? Taking it a little wider, does the number of professors in a nation has translate to development? Who is responsible for the major breakthroughs of the world? Those who could talk well about what they knew?
The direction of this piece is we need to ask ourselves what the value of knowledge is. How does my education translate to a better life for me and my family? For my nation? Is any additional schooling necessary? What knowledge do I really need for self-actualization in life. These questions become more relevant as we live in a society which is obsessed with paper qualifications and academic achievements. I dare say in our individual lives we need to ask again what we are doing with all this knowledge and all this schooling. Keeping them in our shelves, in our debate platforms or even in our heads just does not seem to be good enough. Whether spiritually or socially, what we know has to have a way of measurably adding to the quality of our lives and those of others around us.
I have been doing a short HA/DR refresher on www.pluralsight.com and Russ Thomas said something during the module on backups that caught my attention. he said taking a backup and leaving the only copy of the backup on the same server whether backup was taken is one sure way of displaying your incompetence as a database administrator. This statement caught my attention because it made me begin thinking of all the other ways the “incompetence” of a professional with a lot of years of experience can be displayed through just one or two acts of negligence or carelessness.
However, I do think that the exposure of such “incompetence” may not be because the professional is actually incompetent, it could just be because he or she is not paying attention to the little details. We all have situations where an external consultant or auditor comes into our environment and makes a twenty page PowerPoint presentation which a lot of screen shots and three quarters of the slides have pictures of gargantuan log files, almost-full file systems, and wrong parameters. The Consultant or Auditor ends up scoring a huge point on your account.
I am sure this happens in other areas too: finance, security (both physical security and IT Security). it happens because the pressure of work has made a lot of us forget the basics we learnt. We know all the stuff and we can all discuss it in long meeting with a lot of finesse in our vocal prowess (was that even a correct expression?) but we simply have stopped practicing what we know. I do think some consultants would have less to do and show off with if we are a bit more careful in out apparently routine jobs.
I heard a wise boss once say “You are as good as the last good thing you did” and he was right. Getting things wrongs tends to get more attention in IT and in the world than getting things right. getting things right is considered normal. You have to be either extraordinarily adept at you implementations or extraordinarily loud in promoting them for you good work to get any attention in the eyes of you managers. But just let one single file system get full and everyone will know your name!
So what is the point? Well I believe since knowledge is so prolific and accessible in our day, our problem is not likely to be that we do not know what to do, we may be simply lack the motivation, courage or resources to do it. But there are some things we can do that we are yet to do and I do think in order to preserve your professional pride, you need to pay attention to those little things. Get what the standards are from the Internet and apply them, keep the routine jobs going, assess yourself before someone else does. Russ also did say it is much better for YOU to find a problem and solve it (even when everything looks fine) that for someone else to find it for you.
In the past week or so I have been involved in a number of tasks that required a little bit more involving problem solving skills. Not involving because the problems were particularly difficult to solve but because there were a number of approaches to solving these problems and the issue became finding the most effective way. Have you ever come across one of those exam questions where you are asked to choose the best answer or the most appropriate answer or the answer that required the least administrative effort. That is the kind of thing I am writing about.
The first case I will share is the case where we were trying to map the columns of a set of tables from one database to those of a single table in a another separate but related database. We had managed to combine a set of about thirty structurally uniform tables into one data set using the WITH and UNION ALL clauses then we ran into the challenge that all columns at source were not present at destination. The columns we were seeing at the destination were derived for the most part. We had one or two options: simply offload the problem to the vendor or re-write the application code which needed the table (involving a different vendor). Both approaches involved a third party who did not share our enthusiasm to make this work for obvious reasons. However we at least got the first vendor to give us the mappings that existed; the rest we had to get by painstakingly extracting sample rows and comparing source and destination then writing simple SQL to create derived columns. It took some time and effort and the tenacity of Joshua Adom.
The second example I will share is that of a situation we observed after performing an upgrade over the weekend on an Oracle installation sitting on AIX. It so happened that the upgraded databases shared a certain server with another set of databases in the reporting environment which were yet to be upgraded. The first thought was to move the data to another reporting serve which still had the old Oracle version during the next restore cycle. Good idea but might overload the other server. The Christopher Atayero and Ugonna Udunwa nailed it simplistically – install two Oracle homes on the same server!
Such “simple breakthroughs” happen in our work environments when we are able to apply simple principles to our approach to problem solving:
1. Agility. Be open to a variety of approaches. They say there are many ways to kill a cat. Some ways end up being more efficient and less expensive. Expense here refers to effort not necessarily money.
2. Skill. Expose yourself to much product knowledge. You may not be using a particular skill set just yet but one day the knowledge you have been accumulating will be demanded by a new problem.
3. Depth. Take a moment to think through an issue. The first thought is not always the best. Subject your ideas to scrutiny and keep asking whether there is a better way.
4. Collaboration. Brainstorm, review and brainstorm again. The solution to a problem should create as few new problems as possible and very low probability of re-occurrence. Having a colleague analyse the solution achieves this goal.
5. Openness. Be humble enough to accept other solutions and contribute to them even when yours simply was not good enough. Develop a Team Mentality and let your motive be to solve the problem not to show off your smartness. You are not the world’s smartest and even if you are, sometimes those you consider below you do have ideas that are above you.