Friday 31 July 2015

oracle schema and tablespace for liferay portal setup

prompt 'creating tablespace COMPETENCY_DATAand COMPETENCY_IDX'
 CREATE TABLESPACE "COMPETENCY_DATA" DATAFILE 
  'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\COMPETENCY_DATA01.DBF' SIZE 5242880
  AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO;
  
  CREATE TABLESPACE "COMPETENCY_IDX" DATAFILE 
  'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\COMPETENCY_IDX01.DBF' SIZE 5242880
  AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT SPACE MANAGEMENT AUTO;

prompt 'creating LPORTAL schema'     
drop user lportal cascade;
accept l_portalpwd prompt "LPORTAL Password : "
create user lportal identified by &l_portalpwd;
prompt 'granting privileges to the LPORTAL schema'
grant resource, connect, dba to lportal;
MOVING TABLESPACE:

declare
l_sqltext varchar2(500);
begin
for i in (select owner, table_name, tablespace_name from dba_tables where owner in  ('LPORTAL') and tablespace_name ='USERS') loop
l_sqltext := 'ALTER TABLE '||i.OWNER||'.'|| i.TABLE_NAME|| ' MOVE TABLESPACE COMPETENCY_DATA';
execute immediate l_sqltext;
end loop;
end;
/


declare
l_sqltext varchar2(500);
begin
for i in (select owner, index_name from dba_indexes where TABLE_OWNER in ('LPORTAL') AND index_type = 'NORMAL'  AND TABLESPACE_NAME = 'USERS') loop
l_sqltext := 'ALTER INDEX '||i.OWNER||'.'|| i.INDEX_NAME|| ' REBUILD TABLESPACE COMPETENCY_IDX';
execute immediate l_sqltext;
end loop;
end;
/

Liferay default role associations via portal-ext.properties

system.roles=Moderator
system.role.Moderator.description=This is Moderator role.

Friday 24 July 2015

Dr. Manoj R Dudhgaonkar, Radha Madhavi, Ankit Pancholi, Dharithi Pancholi, Maruthi Prasad Anumula, Mahammad.s.ali and Siddharth Thomas with me

We (My spouse & myself) never forget the day (February 16, 2014), which day changed our life. We woke up as usual at 6:30 AM. I have changed my breakfast menu from Wheat Upma to Corn Flakes after toilet because I felt that I had so much heat inside of my body

Suddenly, I felt so much stomach pain at 7:00 AM. Swallowed normal stomach pain tablet & tried to sleep to get rid from that pain. I could not won from that pain.

To overcome that pain I had done many unknown Asanas with standinng, sitting & bending, and laid down in my balcony on the mat. I understood that my Asanas knowledge is vague that time. 

She unable to understand whats going on to her life partner, at the same time unable to control fear & sorrow. She controlled herself and offered butter milk. That butter milk I offered to bathroom as vomiting. 

To console her or to make her normal, I tried to hide that pain and behave as normal. I unable to do so.

I vomited water after had water with sugar to bring down my body temparature. 

Few friends are forever: I called one of my friend (Mr. Ankit) & boast out whats happened. He told home remedy to adjust stomach nerves. I called other friend (Mr. Maruthi) to enquired opened hospitals (sunday evening fews hospitals are opened at Hinjewadi in pune) at that time. Mean time, we (spouse & myself) started to hinjewadi area to get treatment from Maruthi enquired hospital. We admitted at Mulshi millenium hospital before Ankit's family has reached that hospital. 

Few doctors believes Service is primary, money is secondary : Around 4:00 PM, Dr. Manoj R Dudhgaonkar, injected medicine via syringe to my both buttocks to surpass that severe pain and injected saline to get energy. From morning, Spouse had not been taken anything. Still, she is normal because her focus to see me as normal. I became normal with these medicines and saline. To get rid from that pain. It took 45 mins after that two injections. Dr. Manoj, He has limited equipment but he has unlimited love on his duty/service. 

He took X-Ray and confirmed that leaking from the intestine and instructed that immediately join multi speciality hospital that day itself, do not do any travel now. We (Spouse, Ankit's family, Maruthi & Ali) are preparing to move to Aditya birla emergency department enquired by Dr. Manoj. One of manager (Mr. Siddharth from Cignex) came to meet me and he got to know that I got appendicitis. 

Dr. Gajanan Wagholikar, Radha Madhavi and her parents (Mr. Venkateswarlu & Suvarna Kumari), and her sister's family (Srinivasulu, Vani & Shanmukha teja) and her brother (Muralidhar), my parents (Ramanama) and my brother in law (Satyanarayana P) and my friend (Yesu ratnam), Ankit Pancholi & his parents, Dharithi Pancholi, Maruthi Prasad Anumula,with me.

Mr. Ankit drove to Aditya Birla Hospital, Emergency Department for admission. Due to that severe pain abdominal internal parts getting pain due to car jerks whenever car crossing speed brakers while driving on road. After joined into the emergency ward then doctor suggested Abdominal CT-Scan to diagnosis the problem. While preparing for the Abdominal CT scan, drinking water again started that stomach pain. But, I know that I need to complete 2 litres of water to get proper Abdominal CT Scan.

All are praying and hope for good entire night. 

On Feb 17, 2014, Doctor came and told that this is perforation (intenstine damaged/leaking). He instructed that one more Abdominal CT Scan to take decision lazer surgery or open surgery is required. Afternoon doctor confirms that we need to do open surgery. 

At 7:00 PM, Spouse & Friends, they dropped me at operation theatre with tears and wet hearts. spouse signed on the required documents for surgery declarations. Some other specialists came, explained and took my consent and sent me to the surgery room. I saw a light, heard some sounds and felt very hot on my stomach due to lamp. 

My brother in law (Mr. Murali) reached Pune at 2:00 PM. Father in law, mother in law and mother, they reached at 8:00 PM. 

Around at 11:30 PM, Doctor shown infected intestine piece to them. After that I shifted to ICU Room. The following morning I am in the surgical intensive care unit. I have a central line in my neck, an IV in my arm, a catheter in my penis, a tube down my nose, a drainage tube coming from my stomach. My stomach is held together by 18 stitches and I was wearing "medical mittens" so I cannot pull any of it out.

Dr. Wagholikar sir, visits every day and each time asks me how I am feeling. One the third day I told him I was feeling good; that I was not a perforation patient anymore. I was getting bad nightmares and daymares then my father in law told that chant Anjaneya slokams to get rid of them. I was shifted to general ward. But, I was unable to stay there, I was getting feel like my stomach flesh was burning, and lack of proper weather conditions and so much disturbance. Finally, we moved to other separate ward where we have proper weather conditions. Dr. Panda sir, observing hepatitis B due to my hepatitis B results are positive. Finally, we understood that due to Abdominal TB this perforation happened. Slowly, I started walking, drinking, eating and trying to improve my breath. I spend one week in the hospital. All were coming for visiting and staying at the hospital premises. One week later, Dr. Wagholikar & Dr. Panda, they confirmed that I can go home the next day.