Wednesday, August 5, 2009

MOSS 2007: Installing Helpdesk Template

I tried to install this few times and finally I got the idea of installing it...

1. We have to install: ApplicationTemplateCore.exe to your sharepoint server. You may download it here. Click the exe file and extracted the file to a respective folder. A file called ApplicationTemplateCore.wsp will be extracted to that folder. You may refer to the visual steps from my previous post.

2. Open command prompt and do this:
  • stsadm -o addsolution -filename \ApplicationTemplateCore.wsp
  • stsadm -o deploysolution -name ApplicationTemplateCore.wsp -allowgacdeployment -local
  • stsadm -o copyappbincontent
...it should appear like this...

3. Next we install: HelpDesk.exe that can be downloaded from here. Again click the exe file and extracted the file to a respective folder. A file called HelpDesk.wsp will be extracted to that folder. You may refer to the visual steps from my previous post.

4. Open/Proceed with the command prompt and do this:
  • stsadm -o addsolution -filename \HelpDesk.wsp
  • stsadm -o deploysolution -name HelpDesk.wsp -allowgacdeployment -local
5. How to check whether the files have been deployed?
  • goto Start > All Programs > Microsoft Office Server >Sharepoint 3.0 Central Administration
  • Click the Operation Tab
  • Click Solution Management under global configuration.
  • Check under Deployed To header. If it states Globally Deployed...then type iisreset in your command prompt.
  • close your Central Administration Page..then reopen it back.

Tuesday, August 4, 2009

Oracle 10g: New Instance.

After creating a new instance into our machine. Below basic items must be done before data can be stored.

1. Create Tablespace



  • create tablespace [tablespacename] datafile [path] size [size];

2. Create User


  • create user [username]
    identified by [password]
    default tablespace [tablespace]
    temporary tablespace temp;


3. Granting Rights



  • grant create session to [user];

  • grant create table to [user];

  • grant create view to [user];

  • grant create sequence to [user];

  • grant create procedure to [user];



4. Grant All Privileges..[make sure to connect as the sysdba of the instance]:

  • conn system/system as sysdba;
  • grant all privileges to sa;

Monday, August 3, 2009

Oracle 10g: Database Connection via SQL*PLUS

1. Open a command prompt.
2. To open SQL*PLUS console..do this..:
  • set oracle_sid=[instance/database]
  • sqlplus /nolog

3. Then...[I just created my table ..therefore I am logging in as sysdba]:
  • conn [username]/[password] as sysdba
4. There you go..You are connected!

MOSS 2007: Installing Templates

Where to start? I started by downloading a MOSS template called SiteAdminTemplate from this site.

A. Uploading templates to your server.

...unzip downloaded EXE file to any folder...

...2. u'll see a lot of *.stp files and *.wsp files

3. goto Start > All Programs > Microsoft Office Server >
Sharepoint 3.0 Central Administration...
goto Site Actions > Site Settings..

..4. click Site Templates from Galleries..

..5. Click Upload > Upload Multiple Documents..

..6. Select All downloaded files [stp and wsp]..

..7. Progress bar will pop up...

..8. All selected files will be appeared as Site Template Gallery..


B. Create New Project By Using Templates

..1. goto Site Actions > Site Settings..

..2. goto Sites and Workspaces under Site Administration..

..3. Fill up New Site information...
After files being uploaded a new tab called 'Custom' will be appeared...
..Choose any template that you reckon..

...4. Automatically files being created...

ok guys..that will be the 'GUI' way of doing it..I shall test out the command prompt installation any sooner than today....

Sunday, August 2, 2009

I went speechless

Damn...as I arrived at the training center..plus felt so DBA at that time...sweating..but yet excited...someone reached me..saying...- 'I'm so sorry..but your name is not in the list..you are not being registered'...WHAT??????

waited for nearly 45 minutes...sweating...tensed...I just went speechlessss...yup there we go again...my excitement flushed into the toilet!....

called the HR manager..and he said..the company is pulling back the budget for the oracle training..and they are planning to send me for the .NET certification...oh god..oh dear...not again..my body shivered..this happened last year..and its happening again...

started googling...i kept on thinking...and searching...don't we have good market for oracle here in Malaysia?...OR...am i wanting it so much...that makes it real hard to get?

Today Will Be IT!

...today will be my first day of attending the Oracle 11g administration class..Mind setting of the day: I AM A SPONGE....Talked to some experts on this matter...no matter how many courses we attend...the experiences and the skills are so needed in this field rather than a piece of paper..

Okay..got if chief!