Month: April 2010

Setting up rsync on Solaris 10 Sparc

Down the following packages from
http://www.sunfreeware.com/indexsparc10.html

rsync-3.0.7-sol10-sparc-local.gz

Dependencies

popt-1.14-sol10-sparc-local.gz
libiconv-1.13.1-sol10-sparc-local.gz
libgcc-3.4.6-sol10-sparc-local.gz
libintl-3.4.0-sol10-sparc-local.gz

Install the packages using

Pkgadd -d

To check the packages installed

pkginfo -l SMCliconv

pkginfo -l SMCrsync

To remove packages

pkgrm SMCrsync

once the packages are installed

Create a  rsyncd.conf  and  rsync.passwd file in /etc


#rsyncd.conf

gid = users
read only = true
use chroot = true
transfer logging = true
log format = %h %o %f %l %b
log file = /var/log/rsyncd.log
hosts allow = 10.2.0.0/24
auth users = root,suroot
motd file = /etc/rsyncd.motd
secrets file = /etc/rsyncd.secrets

[control]
path = /opt/sysman/control
comment = sysman control
read only = false
uid = 0
gid = 0

 

#rsync.passwd 

sync

Start the rsync daemon


# rsync --daemon

crash or media recovery needed ?

--crash recovery needed
SELECT
a.thread#, b.open_mode, a.status,
CASE
WHEN ((b.open_mode='MOUNTED') AND (a.status='OPEN')) THEN 'Crash Recovery req.'
WHEN ((b.open_mode='MOUNTED') AND (a.status='CLOSED')) THEN 'No Crash Rec. req.'
WHEN ((b.open_mode='READ WRITE') AND (a.status='OPEN')) THEN 'Inst. already open'
ELSE 'huh?'
END STATUS
FROM v$thread a,
v$database b,
v$instance c
WHERE a.thread# = c.thread#;

--Media recovery needed
SELECT
a.name,
a.checkpoint_change#,
b.checkpoint_change#,
CASE
WHEN ((a.checkpoint_change# - b.checkpoint_change#) = 0) THEN 'Startup Normal'
WHEN ((a.checkpoint_change# - b.checkpoint_change#) > 0) THEN 'Media Recovery'
WHEN ((a.checkpoint_change# - b.checkpoint_change#) < 0) THEN 'Old Control File'
ELSE 'what the ?'
END STATUS
FROM v$datafile a, -- control file SCN for datafile
v$datafile_header b -- datafile header SCN
WHERE a.file# = b.file#;

How to delete IWR reports from queue in cancelled state

Open Configuration Manager
Click Cognos Impromptu Web Reports
From the toolbar stop the service
Open Windows Explorer
Locate your \Cognos\cerx\iwr\database directory
Rename the files iwr73Job.db and iwr73Msg.db too iwr73Job.old and
iwr73Msg.old
Locate your :\Program Files\Cognos\cerx\Logs
Delete
– iwr.log
– iwrmessage.log
– iwrmessage*.uld

Open Configuration Manager
Expand Cognos Impromptu Web Reports
Expand Data Store
Click Create Data Store
From the Actions menu, Click Apply Selection
Verify that iwr73Job.db and iwr73Msg.db have been recreated
(\Cognos\cerx\iwr\database)
Expand Cognos Impromptu Web Reports
Expand Server
Click Register Services
From the Actions menu, Click Apply Selection
Restart the Cognos Impromptu Web Reports service

These steps recreate the database where the job processes are stored. This
should remove the cancelling job from the queue.

MOUNT A WINDOWS FILE SYSTEM

#mkdir -p /mnt/win

#mount -t cifs //winserveradd/c$ -o username=mdesouza,password=Starbust /mnt/win
#cd /mnt/win
# ls -l

For the share //windowsserver/sharename to be automatically mounted at every system start (after reboot), insert an option in the file /etc/fstab:
# vi /etc/fstab

Append following line (written in a single line):
//windowserver/share /mnt/win smbfs
auto,gid=users,fmask=0664,dmask=0775,iocharset=iso8859-15, credentials=/etc/sambapasswords 0 0

Next create the password file /etc/sambapasswords
# vi /etc/sambapasswords

Now add following content:
username = mdesouza
password = Starbust

Save and close the file. Make sure only root can access your file:
# chown 0.0 /etc/sambapasswords
# chmod 600 /etc/sambapasswords