Skip to main content

Kalido Setup and Default Passwords of Oracle Schemas

When setting up Kalido for the first time it asks you to create a number of schemas in the database. It also expects them to have default passwords, e.g. goldeneyex for WHSUSR or gatekeeper for GATEKEEPER schema.

However, there are strict password guidelines these days in almost every organization. A strict DBA group would never let you have the kind of passwords mentioned above. If DBAs do decide to have difference passwords for these schemas then it would be a problem. When you create a Kalido Gatekeeper it goes to gatekeeper schema and grabs the encrypted username and password for WHSUSR schema from USER_DETAILS table. If you have changed the password of GATEKEEPER schema itself then you can override that by checking the option ‘Force the GateKeeper to connect to the database as a specific user’ and then supplying the schema name and new password. However, even after that, gatekeeper configuration will fail. It fails because of the fact that it grabs the encrypted password for WHSUSR schema from USER_DETAILS table that equals the default password of WHSUSR, goldeneyex.

You would think that it is not a problem. You will use the KSetPass utility and change the password of WHSUSR schema. However, that would not work because for KSetPass utility to work you would need gatekeeper configured first. So now you are into a vicious circle. There are two ways to solve this puzzle. One is by asking Kalido Support to give you encrypted value of WHSUSR password and then update the USER_DETAILS table manually. Another way is by asking your DBA team to change the password of WHSUSR schema to default goldeneyex. Once you have configured your gatekeeper they can change it back to whatever they want and then you can change it accordingly using KSetPass utility.

The key here is to get your Kalido gatekeeper configured first and foremost. Once the gatekeeper is there, you can do pretty much whatever you want.

Comments

Popular posts from this blog

Koshish Karne Walon Ki Haar Nahin Hoti …

An inspirational poem from Harivansh Rai Bachchan. Thanks to Vishva for the lyrics


Lehron se Darkar nauka par nahin hoti,
koshish karne walon ki haar nahin hoti

Nanhi cheenti jab daana lekar chalti hai,
chadhti deewaron par,
sau bar phisalti hai.
Man ka vishwas ragon mein saahas bharta hai,
chadhkar girna,
girkar chadhna na akharta hai.

Akhir uski mehnat bekar nahin hoti,
koshish karne walon ki haar nahin hoti.

Dubkiyan sindhu mein gotakhor lagata hai,
ja ja kar khali haath lautkar aata hai
Milte nahi sahaj hi moti gehre paani mein,
badhta dugna utsah isi hairani mein.

Muthi uski khali har bar nahin hoti,
koshish karne walon ki haar nahi hoti.

Asaflta ek chunauti hai,
ise sweekar karo,
kya kami reh gayi,
dekho aur sudhar karo.
Jab tak na safal ho,

neend chain ko tyago tum,
Sangharsh ka maidan chhodkar mat bhago tum.

Kuch kiye bina hi jai jaikar nahin hoti,
koshish karne walon ki haar nahin hoti.


- Harivansh Rai Bacchan

लहरों से डर कर नौका पार नहीं होती ,
कोशिश करने वालों  की हार नहीं होती।

नन्ही चींटी जब दा…

The latest #BigData #Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto @AltheaDelalune @Parker_B_Assoc #bigdata #analytics

The latest #BigData #Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto @AltheaDelalune @Parker_B_Assoc #bigdata #analytics Source: The latest #BigData#Analytics Daily! https://t.co/BDdeMOiHQ2 Thanks to @oriolto@AltheaDelalune@Parker_B_Assoc#bigdata#analytics — Sachin Sinha (@SachinSinha) November 23, 2017November 23, 2017 at 03:12PM
via IFTTT