Wednesday, November 20, 2013

Drop datafile of temp tablespace

ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata3/temp_5/temp.data5';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_6/temp.data6';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_7/temp.data7';

cd /oracle/PIP/sapdata3/
rmdir temp_5


cd /oracle/PIP/sapdata6/
rmdir temp_6

cd /oracle/PIP/sapdata6/
rmdir temp_7

Tuesday, November 19, 2013

Switching oracle database archive to non archive mode and vice versa.

switching off archive mode.
    shutdown immediate;
    startup mount;
    alter database noarchivelog;
    alter database open;
switching on archive mode.
    shutdown immediate;
    startup mount;
    alter database archivelog;
    alter database open;

Tuesday, May 14, 2013

Mount windows share into HP-UX

Create mount point
mkdir winshare

Mount H drive of windows server 10.32.0.164 where nikunj is local user of that server and having rights on shared drive H

# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
The CIFS Client is not running.
#

Start CIFS Client

# cifsclient
CIFS Client started; process id: 14102

Mount H drive of windows server 10.32.0.164
# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
LOC: Netbios session refused
LOC: Netbios session refused


To resolve LOC: Netbios session refused error do the entry into /etc/hosts
10.32.0.164     BACKUPSRV.domain.com


Mount H drive of windows server 10.32.0.164
# cifsmount //BACKUPSRV.domain.com/h /winshare -U nikunj -P testing


Check file system mounted
# bdf
Filesystem          kbytes    used   avail %used Mounted on
backupsrv.domain.com:/h
                   2711840 2711840       0  100% /winshare
#


Unmount mounted windows shared
cifsumount /winshare


Stop CIFS Client
# cifsclient stop
No CIFS filesystems to unmount.
The CIFS Client has been shut down.
#