04 May, 2013

ORA-12154: The other uncommon cause, and the solution

Image representing Oracle Corporation as depic...
Image via CrunchBase
ORA-12154: It is not always due to the listener down, or something...
-----


04-May-2013

2 weeks ago, while I was preparing my arsenal of personal computers (now 9, with 1 laptop and 8 desktops) at work, one requirement is to be able to synchronize the TNS file across all the 9 computers.

This would need me to have a read/write priv to the Ora folder in the 9 PCs, and so I opened it up for me by sharing the folders. This, in turn, closed the folder access to everybody else, because I shared the folder only to me – I removed access for Everybody/Everyone. The priv then was full control.

That began the issue of all users of the web apps running in these computers, where ORA-12154 is being thrown. I didn’t see it, and I could just imagine their shock that suddenly, the application doesn’t work properly. Until one of the customer service personnel came over to ask something, and just remembered to check with me why the web apps aren’t working.

I quickly checked, and I got ORA-12154. Since that same day I got to sync all the code files and accessory files in all of the computers, I didn’t know where to start at first. I gathered my wits, and thought of checking the particular web apps having problem. Problem was there. Half a day passed, and the problem persisted. Then I thought of verifying the web apps from my laptop. It was working! So I got even more confused, believing that it was the file transfer that I run which caused the problem.

A few more check here and there on the web apps having problem, and still no luck. I then started to check on the other web apps and Windows apps using the same files and libraries, and to my surprise, they are all working!

What now?

At this point, I knew I had to break away from the pressure, so I called up the Oracle DBA, and asked him about ORA-12154, and since I can’t do desktop sharing on any of the affected computers (yes, all having problem, actually, and on the same web apps), he came over. He checked a few items, and he is also stuck. Told him all that I‘ve done so far, and I said the other Web and Windows apps are running, to which he checked with me, “And these are running under your account?”

I said “Yes.”

At that queue, he checked the Ora folder, looked at the sharing setup, and opened it to “Everybody”.

That PC worked. After that, he went on his way, trusting me to be able to manage the rest.

So there you are. ORA-12154 error. It is not always that the listener at the server machine is down, or whatever. For my case, it was the access privilege that got screwed up. Anybody running the web apps that uses Oracle client must have access to the installation folder, at least “Read” access.

Hope this helps anybody there running into the same problem, but is not due to the listener down or not running.

Till then!
Enhanced by Zemanta

28 March, 2013

GT-9103: SD Card Is Damaged!

Image representing Android as depicted in Crun...
Image via CrunchBase
28-Mar-13


I have a few items to write on, but I believe this one is quite urgent.

Two weeks ago, I sort of “tampered” once again my already-quiet Samsung Galaxy R. I searched for the latest Android custom ROM, which is 4.2.2. I found the one that is offered by Paranoid Android. I actually managed to flash that one properly, both the kernel and the Google Apps. These are the files: i9103-3.00-16FEB2013-192725.zip and gapps-full-4.2-20130308.zip. These are coming from Paranoid Android.

Of course, things don’t end there.

When I was installing those root apps, I came to the SuperUser app, and to my mistake, I selected the wrong option, when I was offered something like “usually for HTC phone”, and that broke my phone’s SD card.

A lot of apps don’t work after that: Camera, Wallpaper Changer, etc. I found that many things are so much dependent on the internal SD card. Anyway, I already have the other phone, my GT-I3100, so the impact isn’t that much.

Still, I can’t rest assured. I’m not convinced that nothing can be done with the “broken” SD card. Nonetheless, I am one step short of bringing that old phone, although unused, to Samsung Service Center.

I did try and try and try to re-flash the ROM, so that by any chance, re-installing SuperUser app, if I tap the ‘correct’ button, the SD card may get fixed all by itself.

Furthermore, within the last week, I noticed that my phone is showing some “inversion” in the display, like the upper diagonal half (top left to bottom right) getting inverted. The time showing 10:50 is upside down. Imagine that!

Bad becoming worse. Really no fix, I thought. I searched the web for help on the ‘Damaged SD Card’, and although it was consistently mentioned in the articles that I found not to do format, I still tapped on the ‘Format’ button in the suggested fix by the apps that identified the SD card as damaged. I was wondering, the one who developed the App isn’t the one who wrote the articles…?

Then my insatiable curiosity got me.

I said, there could be something offered by CM, the same 4.2.2 kernel, for my GT-i9103. So yesterday, I searched the web. Something came up. There were 2, actually. There was the kernel alone, cm-10-20121223-UNOFFICIAL-i9103.zip, and the pair: I9103DXLP6_I9103OLBLP6_XSP.zip and gapps-jb-20121011-signed.zip. Looking at the dates, I said, these are earlier released than the one from Paranoid Android. So I was asking myself, “Why didn’t I see these first?”

Anyway, I went to download the files, not knowing whether I should do flash using the standalone kernel, or the pair.

I decided to use the pair, but to be sure, in case something doesn’t work, I also copied the standalone zip file. True enough, there was an error thrown out with the pair, the main zip file. I proceeded to install the Google Apps from the zip file despite the fact that the main file didn’t install properly, and then after reboot, the phone was in a boot loop.

I now tried to install the standalone file, and it worked! Still, first reboot resulted to a boot loop.

I did another flash, and this time, using the standalone kernel file, and this went through without a problem, and the reboot also went through nicely, and when the phone came up, I entered all the necessary credentials, and the apps were installed back automatically.

But Play Store app was missing, and though I can search and “install” it using the browser, the app doesn’t show in the Apps list. It is nowhere to be found. So I thought, can I bring it up using the other half of the pair, just the Google Apps file?

And that I did. I flashed the GApps file, and after reboot, the Google Apps were in.

And guess what? The main reason for my posting this article is to say that after flashing the CM 4.2.2 kernel for my GT-i9103, the SD Card came back to life!

Also, the other reason why I would be more comfortable running CM codes is that there is a regular update, which I download and install now and then, sometimes every night (NIGHTLY builds). That is what I do with the GT-P3100 phone.

So now I have a CM custom Android 4.2.2 ROM running, with the Google Apps in, and the SD Card fully functional once again!

Hope this short post will be of help to somebody as well.

Till then!
Enhanced by Zemanta

13 March, 2013

Jelly Bean 4.2 on my Galaxy Tab 2 7.0, Rooting my wife’s Note II LTE

Samsung Galaxy Tab 2 7.0
Samsung Galaxy Tab 2 7.0 (Photo credit: phossil)
13-Mar-13


2 weeks ago, my wife got her Samsung Galaxy Note II LTE (GT-N7105) for her plan re-contract with Starhub. I would have to mention (again) that we got the Samsung Note 2 7.0 (GT-P3100) weeks before, from the yearly early re-contract privilege only available with SingTel service provider. I mean, Starhub used to offer the same perk, but this was taken out about 2 years ago. Business decision, I suppose.

Anyway, the point I wanted to make is this: now that my wife has her new phone, then I am already free to “take” the Tab for my own use. This action will leave 2 phones without lines: the iPhone 4 and the Samsung Galaxy R (GT-I9103). This would mean that our 3-year old girl would have, at any point in time, 3 phones to play with while at home, juggling between the 3 devices, until the batteries die out. She would then turn to her inanimate play things in her toy box…

2 weeks ago, it was Wednesday, and I made the decision, so I switched the SIM cards. I brought with me the Tab, but I grew restless. I knew I can do more with it. The trigger was pulled, and bang! I was searching for the ‘latest’ ROM, kernel, updates, etc. This is me, what I set my mind to do, it consumes me!

And with the internet littered with tons of pages of (sometimes useless) information, I found what I am looking for – the Jelly Bean 4.2 kernel for my new GT-P3100. Having had rooted and flashed ROMs on my Galaxy R phone, I thought to myself, “This should be a piece of cake.”

Then the dilemma came.

I started flashing the new kernel while at work, and it failed. Several times I tried, and still failed. And all the time, I would have to reset the phone to the root and kernel that works. I have a saving patch, I could say. It is well worth mentioning: the filename is “P3100XXCLL2_P3100XEFCLK1_P3100XXCLJ3_HOME.tar.md5”. And this has a very faithful partner, the rooting file: “CF-Auto-Root-espressorf-espressorfxx-gtp3100.tar.md5”. Of course, all the time, I am using Odin3-v1.85. So when the flashing fails, I resort to flashing with the ‘working’ ROM, then to rooting the phone.

And the whole day of Wednesday, I was flashing, until I got home, and even late at night, till midnight, I was flashing. Still fails. The time I came home from office, my girl did as she would always do before: ask for my phone, so she can play with it. Well, I had to admit my failure, so I quietly told her, “It’s not working.” And showing her the black, blank screen, she took my word for it and went on her way.

Thursday came, I since I didn’t have a working phone, I told my wife that I’d ‘borrow’ the old Galaxy R phone while I am ‘fixing’ the Galaxy Tab 2 7.0 unit. I got 2 units with me when I went to work.

Having had no luck the day before, I decided to try something else, and since it is something that I really wanted to try out, I searched for ROM kernels that will offer over-clocking and under-clocking – of course, with Jelly Bean 4.2 as the base item. I could say I’m becoming overly-zealous, am I? Sure enough, I found some, till I settled with one that makes a high-pitched offer, which I took, like a fish swallowing the hook, line and sinker. I was getting too ambitious, I suppose.

And even this one failed. The whole day of Thursday, I repeatedly tried, of course, each time, my saving pair of working kernel and rooter would help me get back to my feet each time my Android phone falls. I ended the day with all attempts ending in failure.

Friday, learning from the past 2 days, I searched, and only then I realized, that the Wednesday flashing was using an ‘incompatible’ file – and not that I am blind to it. Galaxy Tab 2 7.0 were of 2 kinds, basically: one is GT-p3100 (3G + WiFi), and the other, GT-P3110 (WiFi only). And there is one more: GT-P3113. What I was using was one specifically meant for the GT-P3110, while my unit is the GT-P3100. Of course, I went with this because some guy in the forum said that “it should be okay,” reading from some other user’s query of using that particular file for flashing.

As for the over-clocked module, it was already highlighted in the XDA pages that it was not verified, and you would do it with caution; a caveat. Of course I failed, and I learned from it.

It was already about lunchtime when I found one file that may be the answer. And it is complicated by the fact that I have to download it, and then later on, to try and flash my device.

The download finished about half past 4pm, and that left me with no more time to try anything, so I just run my saving pair, flashing my device with the working kernel, and then I got it rooted. All that’s needed is to try the newly-downloaded kernel.

When I arrived home, I restrained myself by going through the usual things when coming home. So after simmering down, I set up my laptop, booted it up, and then let it idle for a short while. I took the USB cable, held the device and pressed Volume Up and Power buttons simultaneously, I activated CWM Recovery, then selected install from zip file.

Did that installation work? You bet!

One shot. That’s all that was needed to install the new ROM, and to my pleasant surprise, the Android version is 4.2.2 – the latest!

And to attribute to the developers all the praise due them, I found it from the XDA forums. The file name is “cm-10.1-20130308-NIGHTLY-p3100.zip”, with the other file, “gapps-jb-20121212-signed.zip”, both installing without fail.

So now my Galaxy Tab 2 7.0 GT-P3100 unit is fully functional with Jelly Bean 4.2.2 installed.

-----

The other phone, the GT-N7105, since there wasn’t any issue I encountered when I rooted, I’ll just mention the rooting file I used is this, “CF-Auto-Root-SGN2.zip”.

-----

Caution: the zip files, while they all would be tagged as WinRAR archive files, are different – some aren’t simply compressed files. But you should know that already, don't you?


Till then!
Enhanced by Zemanta