Thursday, November 28, 2013

Changing Weblogic Admin Console Password

[orapsoft@box1 bin]$ MW_HOME=/data/Oracle/product/11.1.2.2.0/ses/seshome;export MW_HOME

 DOMAIN_HOME=/data/Oracle/product/11.1.2.2.0/ses/seshome/search/base_domain;export DOMAIN_HOME

  ./stopWebLogic.sh

 mv /data/Oracle/product/11.1.2.2.0/ses/seshome/search/base_domain/servers/AdminServer/data /data/Oracle/product/11.1.2.2.0/ses/seshome/search/base_domain/servers/AdminServer/data_old

 ./setDomainEnv.sh

 cd $DOMAIN_HOME/security

 java weblogic.security.utils.AdminAccount epsys Password1
 failed with Error: Could not find or load main class weblogic.security.utils.AdminAccount

  java -cp /data/Oracle/product/11.1.2.2.0/ses/wlserver/server/lib/weblogic.jar:$CLASSPATH weblogic.security.utils.AdminAccount epsys Passw0rd .

cd /data/Oracle/product/11.1.2.2.0/ses/seshome/search/base_domain/servers/AdminServer/security

edited boot.properities
username=xyz
password=abc

cd $DOMAIN_HOME/bin and startweblogic.sh
 nohup ./startWebLogic.sh >/dev/null 2>&1 &

Sunday, July 21, 2013

Reclaiming the space PSFILE_ATTDET

PeopleSoft table PSFILE_ATTDET is used to store attachment.

Non Production environments generally would not require these attachments.Since this table contains Long Objects, ORACLE DB creates SYS_LOB% tables.

At one of our client database was consuming almost 70G in attachments.

Below are the steps to free up this space and reclaim it.

1.  Enable Row movement before the truncate step.

ALTER TABLE SYSADM.PSFILE_ATTDET enable row movement;

2. Truncate table SYSADM.PSFILE_ATTDET

3. ALTER TABLE SYSADM.PSFILE_ATTDET SHRINK SPACE;

4. ALTER TABLE SYSADM.PSFILE_ATTDET MODIFY LOB(FILE_DATA) (SHRINK SPACE);

5. Alter the database to re-size the datafiles.
ALTER DATABASE DATAFILE '/psimage.dbf'


Some helpful queries

select sum(bytes)/1024/1024 from dba_data_files;

select sum(bytes)/1024/1024 from dba_free_space where tablespace_name='PSIMAGE';




Monday, February 25, 2013

Psadmin Does not detect TUXDIR env variable

Windows Registry Issue for invoking psadmin

Failed to query Windows Registry for TUXDIR environment variable when invoking psadmin....

Do the following

Navigate to

HKEY_LOCAL_MACHINE-SOFTWARE-WOW6432NODE-ORACLE-TUXEDO-10.3...-ENV

Add TUXDIR String \locale\C
Add  NLSPATH

Tuesday, February 19, 2013

PeopleTools 8.52 requires Oracle 32 bit client on Win2k8

I installed Peopletools 8.52.11 on Windows 2k8 64 bit, but it just could not connect to the Oracle 11.2.0.3 database.

Wonder what was the issue!!!

The issue was Oracle 64 bit client.

Peopletools 8.52 connects to Oracle database using Oracle 32 bit client.

1. Download Oracle 32 bit client for 11
2. Deinstall Oracle 64 bit client
3. Reinstall Oracle 32 bit client on the same location.

You should be fine. Now all PeopleSoft tools connect to the database. Data Mover, Change Assistant, Application Designer.

Monday, January 14, 2013

Singapore - The Lion Country


Singpore - the Lion Country



Before penning down my experience about Singapore let me take the opportunity to thank Mihir for inviting me to write on his travel website.

"SINGAPORE" OR "Sin-ga-pura" in Sanskrit meaning the Lion City and so the Lion head symbol "MERLION"

Had planned to visit this beautiful Country in 2006 October but probably was not destined then ...After 6 years we chose the best time of the year to visit this LION COUNTRY ... The December of 2012 ..just before the Christmas Eve

This is the peak season but I chose as it is also the season of deals

My 4 year daughter was so excited with just the thought of sitting in the plane ... but we were curious as she had traveled on a plane as a baby but not as a kid so was unsure if she would get motion sickness or something similar..but all went superb .. kids have there way of adjusting she just avoided eating anything and we did not force.. :)

Guys this writing is for those with family  and not for honeymooner or couple as they might want choose more interesting attractions in Singapore like the Clarke Quay, a romantic candle lit dinner in the cable car from Harbor Front to Sentosa

Perils/threat of reaching Singapore hotel early during peak time popped it's head .. we did not get an early check in , our hotel was full and visitor staying in our room had not checked out .. and we had now 4 hours to spend

Leaving our bags to the reception care we hit the Singapore roads.

Main criteria while looking for hotel was proximity to MRT and in no time we were in front of Farrer Park train station. Our hotel was located at 270, Jalan Besar. We were happy about this fact that we chose the right hotel.

Tired from the flight .. our scanner started looking for restaurant names that would give us our "INDIANISEDMASALA TEA" AND our eyes rested on MUSTAFA CAFE. Straight into the cafe the order flew 2 masala tea and 2 bournvita.
After refreshments we spent some time at the Mustafa centre,Farrer Park Station(gathering info) had lunch.
Strolled the Syed Alwi Road,Kitchner road before checking into our hotel. This locality was very very close to Little India. Restaurants for all tastes have their presence. This area is very very busy during evenings.

Back in our rooms we slept for a couple of hours and started tour-de-Singapore.

I kept my plans floating as there was a dependency on how kids adapt to the weather,water food change

 After taking a couple of hours rest we got ready and decided to reach the city hall train station and spend the evening walking around. Instead of taking the train we took the bus from  our hotel. Cost us $3 (4 of us) to reach City Hall train station.
City Hall area is so much like South Bombay with all the office-goers, commercial buildings, the CBD area.
Standing there I could see the Marina Bay Sands Hotel Buildings. So we all started walking in that direction and found ourselves besides the Merlion .. a big tourist attraction. We all tourists were doing the same thing ... capturing the moments in different form and formats. One thing I like to do , observe different gadgets and if i see something interesting, I do not stop myself from taking it's review from that user. From the Merlion we walked all our way to the Marina Bay Stands. It was long beautiful stretch with bay on one side and huge tall concrete structures on the other side. We met a friend there , had dinner at the food court. I had Laksa.. I just loved it..!!!


   Universal Studios 
Sentosa
Jurong Bird Park
Zoo 
   Night Safari
   
Google Information center would  give all the information one would need to know about the above attractions.I gave one day to each of the attraction as kids would get overly tired and my son wanted to board every ride.

Few interesting things that might be of use to you.

  • If you are going to take the train tickets , the MRT refunds you $1 from your ticket when you reach the destination. So if you are going from Farrer park to Harbour front station, the ticket cost is $2.70 per adult and $1 will be refunded by returning the ticket at Harbour Front.
  • If your kid is below a particular height(3feet) irrespective of age.. the kid can travel free of cost.
  • You get two day pass at train station for Universal Studios / Sentosa Attraction. If one of those days is a weekend, cable car ride  to Sentosa Island is included. 17 rides on Sentosa are free. Ofcourse do not expect star attractions to be included.   (Underwater World/Songs of the Sea)
  • Buses do not refund if you pay in excess of fare, I donated $1SGD.
  • The Souvenirs that you get all the attractions are expensive .. i found same stuff at Mustafa to be heaper.
  • Keep One full day each Universal Studios/Sentosa/bird park / zoo. 
  • Carry a stroller or you can rent one at each of the attractions.
  • Carry raincoats
  • For Sentosa carry your swim wear, Ports Of Lost World is simply superb for kids. Kids play on the water slides and you can enjoy nice chilled beer or wine
  • Teleivision Sets are extremely cheap here (as compared to India) ...I noticed so many people check in TV sets at the airport.
  • Avail of GST return before you board your flight back home
  • Your Singapore is pretty useful app for your mobile while you are planning your trip as well as when your are in Singapore 
  • We could carry dry India snacks without any hassle. Instant source of energy for kids.
  • Dolphin Show at Underwarter World, High flyer Show,Lori's Loft at Juron Bird park were pretty impressive, Song of the Seas,Sky luge, Segway Butterfly Kingdom at Sentosa are good to be on the top of your wish list for Singapore.

I'll end here with the hope that readers find this article informative.