Tuesday, March 18, 2014

Normal.dot Fix

In MS Word the COM Add-Ins can cause problems when more than one window of MS Word is open. Launch MS Word and navigate to Word Options:
Highlight 'Add-Ins' on the left pane. At the bottom of the page in the Manage section, make sure COM Add-Ins is shown in the Manage drop down. Select GO.
Un-check any Add-Ins. Select OK. Exit MS Word Test the changes. Enjoy.

Friday, February 28, 2014

Windows Shortcut Keys

End Goes to end of current line
Ctrl + End Goes to end of document
Shift + Home Highlights from current position to beginning of line
Shift + End Highlights from current position to end of line
Ctrl + Left arrow Moves one word to the left at a time
Ctrl + Right arrow Moves one word to the right at a time


Alt + Tab Switch between open applications
Alt + Shift + Tab Switch backwards between open applications.
Alt + double-click Display the properties of the object you double-click on. For example, doing this on a file would display its properties.
Ctrl + Tab Switches between program groups or document windows in applications that support this feature.
Ctrl + Shift + Tab Same as above but backwards.
Alt + Print Screen Create a screen shot only for the program you are currently in.
Ctrl + Alt + Del Reboot the computer and/or bring up the Windows task manager.
Ctrl + Esc Bring up the Windows Start menu. In Windows 3.x this would bring up the Task Manager.
Alt + Esc Switch Between open applications on taskbar.
F1 Activates help for current open application.
F2 Renames selected Icon.
F3 Starts find from desktop.
F4 Opens the drive selection when browsing.
F5 Refresh Contents.
F10 Activates menu bar.
Shift + F10 Simulates right-click on selected item.
F4 Select a different location to browse in the Windows Explorer toolbar.
Alt + F4 Closes Current open program.
Ctrl + F4 Closes Window in Program.
F6 Move cursor to different Windows Explorer pane.
Ctrl + Space bar Drops down the window control menu.
Ctrl + (the '+' key on the keypad) Automatically adjust the widths of all the columns in Windows explorer
Alt + Enter Opens properties window of selected icon or program.
Shift + Del Delete programs/files without throwing them into the recycle bin.
Holding Shift Boot safe mode or by pass system files as the computer is booting.
Holding Shift When putting in an audio CD, will prevent CD Player from playing.
Enter Activates the highlighted program.
Alt + Down arrow Display all available options on drop down menu.
* (on the keypad) Expands all folders on the currently selected folder or drive in Windows Explorer.
+ (on the keypad) Expands only the currently selected folder in Windows Explorer.
- (on the keypad) Collapses the currently selected folder in Windows Explorer.

Tuesday, January 28, 2014

Sugar CRM Notes

SugarCRM Setup:

O/S: CentOS-6.4-x86_64

yum install php php-mysql

yum install mysql mysql-server

yum install php-imap

yum install php-mbstring

download SugarCRM-CE (Community Edition):
SugarCE-6.5.16.zip

Make sure httpd is running
    (test web connection - should get Apache intro page)
service start httpd
Make sure mysqld is running
service start mysqld
verify php version
php -v

stop httpd service

extract Sugar...zip into /var/www/html

Change permissions on 
/var/www/html/config.php
/var/www/html/config_override.php
/var/www/html/cache
/var/www/html/custom
/var/www/html/modules
/var/www/html/upload


start httpd service

navigate to http://127.0.0.1  Should get the SugarCRM Setup Wizard page.  The page will provide information about file permissions and settings that need additional adjustment.

After install - navigate to Admin section and Password Management - disable 'Enable system-generated passwords feature'
this will allow admins to set user passwords.


Set HTTPD service to automatically start with server restart:
chkconfig --level 35 httpd on

MYSQL Connection Info:
login and set mysql password:
     mysqladmin -u root password 'password'  <--- Don't use password as your password!!

Connect to MYSQL:
     mysql -u root -p

Friday, December 13, 2013

Oracle 12c Installation - CentOS 6.4

Oracle 12c on Linux Installation Steps

Oracle Documentation Links:
http://docs.oracle.com/cd/E16655_01/server.121/e17643/install.htm#ADMQS02122

http://docs.oracle.com/cd/E16655_01/install.121/e17720/install_overview.htm#LADBI7430

Oracle Yum Repository:
http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/



#################################################################################
#####  Verify SSH is installed:
#################################################################################

# rpm -qa | grep ssh
openssh-5.3p1-84.1.el6.x86_64
libssh2-1.4.2-1.el6.x86_64
openssh-server-5.3p1-84.1.el6.x86_64
openssh-askpass-5.3p1-84.1.el6.x86_64
openssh-clients-5.3p1-84.1.el6.x86_64

#################################################################################
#####  Verify Physical RAM (Recommended Between 2 GB and 16 GB):
#################################################################################

# grep MemTotal /proc/meminfo
MemTotal:        3915400 kB

#################################################################################
#####  Verify Swap Space:
#################################################################################

# grep SwapTotal /proc/meminfo
SwapTotal:       4046840 kB

#################################################################################################
#####  Verify Temp Space (1 GB Minimum free space):
#################################################################################################

# df -h /tmp
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_marino2013-lv_root
                       50G  3.6G   44G   8% /

#################################################################################
#####  Verify All File Space (Mimimum just for DB Install 6.4GB):
#################################################################################

# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/vg_marino2013-lv_root
                       50G  3.6G   44G   8% /
tmpfs                 1.9G  300K  1.9G   1% /dev/shm
/dev/mapper/ddf1_mainp1
                      485M   38M  422M   9% /boot
/dev/mapper/vg_marino2013-lv_home
                      497G  5.2G  466G   2% /home

#################################################################################
#####  Memory Check
#################################################################################

# free
             total       used       free     shared    buffers     cached
Mem:       3915400    3757152     158248          0      77428    2724184
-/+ buffers/cache:     955540    2959860
Swap:      4046840          0    4046840

#################################################################################
#####  Verify 64bit OS:
#################################################################################

# uname -m
x86_64

#################################################################################
#####  Minimum Display:
#################################################################################

1024x768


runfixup.sh = created by OUI to help resolve dependency issues

#################################################################################
#####  Required RPMs:
#################################################################################

binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

#################################################################################
#####  Check Linux Version (use command appropriate for Linux flavor):
#################################################################################

#cat /etc/oracle-release
#cat /etc/redhat-release
#cat /etc/centos-release

#################################################################################
#####  Check Kernal version:
#################################################################################

uname -r

#################################################################################
#####  Check Shared Memory:
#################################################################################

more /etc/fstab |grep "tmpfs"
tmpfs                   /dev/shm                tmpfs   defaults        0 0

#################################################################################
#####  Check Hostname resolution:
#################################################################################

# ping <hostname>

#################################################################################
#####  Create Oracle user and Oinstall group:
#################################################################################

groupadd -g 511 oinstall
groupadd -g 512 dba
useradd -u 510 -g oinstall -G dba oracle

system-config-users = GUI app for user and group management

#################################################################################
#####  Setup Oracle Mount point (/u01):
#################################################################################

# mkdir /u01
# chown oracle /u01
# chgrp oinstall /u01

#################################################################################
#####  Resource Limits for Oracle user (run these commands as oracle):
#################################################################################

$ ulimit -Sn
1024
$ ulimit -Hn
65536
$ ulimit -Su
1024
$ ulimit -Hu
30432
$ ulimit -Ss
10240
$ ulimit -Hs
32768

Add the following lines to: /etc/security/limits.conf
@oinstall        soft    nofile          4096
@oinstall        hard    nofile          63536

Log out and back in as oracle user.  Verify settings.


######################################################################################  Cluster Verification Utility - Found on Oracle DB install media in the #####  /rpm dir.
#################################################################################

Requires oinstall Linux group.
# rpm -iv cvuqdisk-1.0.9-1.rpm

Preparing packages for installation...
Using default group oinstall to install package
cvuqdisk-1.0.9-1

#################################################################################
#####  Apply umask setting to profile
#################################################################################
edit user's .bash_profile - add the following lines:

ORACLE_BASE=/u01/app/oracle 
export ORACLE_BASE 

ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 
export ORACLE_HOME 


PATH=$PATH:$HOME/bin :$ORACLE_HOME/bin

umask 022


#################################################################################
#####  Configure/Install Oracle Grid Infrastruction for Oracle Start
#################################################################################

as user oracle luanch 'runInstaller' from Oracle installation files.
./runInstaller

Configure Security Updates
uncheck 'I wish to receive security updates via My Oracle Support'
select NEXT

Software Updates
select 'Skip software updates'
select NEXT

May get error [INS-13001]Environment does not meet minimum requirements
Error on CentOS6.4 - unsupported O/S?? ---everything worked fine on my CentOS

Installation Opion
Select 'Install database software only'

Grid Installation Options
Select 'Single instance database installation'

Product Languages
English is the default

Database Edition
Select 'Standard Edition One'

Installation Location
Oracle base: /u01/app/oracle
Software location: /u01/app/oracle/product/12.1.0/dbhome_1

Create Inventory
Inventory Directory: /u01/app/oraInventory
oraInventory Group Name: oinstall

Operating System Groups
Default = dba
I changed to = oinstall

?? It skipped Prerequisite Checks and went to Summary

Summary
Select 'Install'

When prompted - executes the following scripts as root user
/u01/app/oraInventory/orainstRoot.sh
/u01/app/oracle/product/12.1.0/dbhome_1/root.sh
click OK when done

Finish
The installation of Oracle Database was successful.
Close.



#################################################################################
#####  Listener Creation
#################################################################################

execute netca to launch GUI to configure Listener service.

Select the default options throughout the GUI to create the typical LISTENER on port 1521.


#################################################################################
#####  Database Creation
#################################################################################
Launch Database Configuration Assistant:

$ORACLE_HOME/bin/dbca


Database Operation
Select 'Create Database'
other options:  Configure Database Options
Delete Database
Manage Templates
Manage Pluggable Databases

Creation Mode (Two options, Default or Advanced - both options noted in these instructions)
'Create a database with default configuration'
Assign Global Database Name: testdb
Storage Type: ASM or File System
Database File Location: accept default
Fast Recovery Area: accept default
Database Character Set: accept default
Administrative Password: dontusethis
8 characters with at least 1 UPPER, 1 lower and one number
Confirm Password: same as above
Create As Container Database - Checked by default (if firtst db???)
Pluggable Database name: required on fisrt install?  Example: seat1
Advanced Mode: not selected by default
select NEXT

At end of database creation click the Password Management button to unlock accounts and change passwords.

### OR ###

Select Advanced

Database Template
Select Template - General Purpose or Transaction Processing
other Option:
Custom Database
Data Warehouse

Database Identification
Global Database Name:   Example: stadium
SID:   (typically same as Global Database Name)
other options (not used in this example)
Create a Container Database

Management Options:
Select - 'Configure Enterprise Manager (EM) Database Express'
other option
Register with Enterprise Manager (EM) Clooud Control

Database Credentials
Use Different Administrative Passwords
SYS
SYSTEM
select - 'Use the Same Administrative Password for All Accounts'
Administrative Password:    Example:DontUseth1s
8 characters with at least 1 UPPER, 1 lower and one number
Confirm Password: same as above

Network Configuration
Select Listeners  (choose the Listener created in previous steps - status should be 'UP')
-- or create a listener
Name: LISTENER
Port: 1521

Storage Locations
Database Files
Storage Type: 'File System'
Select: 'Use Database File Locations from Template'
Recovery Related Files
Storage Type: 'File System'
Select: 'Specify Fast Recovery Area'
Fast Recovery {ORACLE_BASE}/fast_recovery_area
Fast Recovery Area Size: 4800

Initialization Parameters
Memory - select: 'Typical Settings'
UN-check: 'Use Automatic Memory Management'
Sizing - accept default settings
Character Sets - accept default settings
Connection Mode - accept default settings

Creation Options
Select: 'Create Database'
Other Options:
Save as a Database Template
Generate Database Creation Scripts

Summary
Review database details
Select: 'Finish'

After database is created note the 'EM Database Express URL'
Use the 'EM Database Express URL' to manage the database using a web browser.


#################################################################################
#####  Remove Oracle Database Software
#################################################################################

/.runInstaller -deinstall -home /u01/app/oracle/product/12.1.0/dbhome



Tuesday, November 12, 2013

Tuesday, April 30, 2013

Another new job

Started 8 months ago.  Learning new things.  Went from Windows desktop support to Linux/Unix support.  Got a bit rusty on my Linux...  Have to learn quick.

New tool to keep handy = Gparted
      Created a bootable disk for use in partitioning hard drives.

Also learned that you can rename the .gconf and .gconfd directories from your Linux /home/username directory to get back the default Gnome environment.