Posts

Authenticating UNIX/Linux to Windows 2008R2. Part 2 : Solaris 10

Background Continuation of setting up LDAP/Kerberos clients to use Windows 2008R2 Server as the "source of truth". See the previous  blog  , for the steps for how Windows was set up. Installation of Solaris Create a Solaris 10 x64 VM, with the following configuration: Custom Config, VMware Workstation 6.5 compatible I will install the operating system later. Guest OS : Sun Solaris, Solaris 10 64-bit VM Name: "sol10host1″ 1 Processor, 1 Core per Processor 1024MB Memory Use Host-Only Networking IDE Controller type: ATAPI SCSI Controller type: LSI Logic Disk: Create a new virtual disk, SCSI, Maximum Disk size, 10GB, Store as Single File, sol10host1.vmdk (on an NTFS filesystem). Insert the Solaris installer CD (Solaris 10 Update 9), Power on and Boot from CD. Install Solaris 10 with the following options: Select Option 4,  Solaris Interactive Text (Console Session) Keyboard :  US-English Language : English Networked : Yes Use DHCP : No Hostname : sol10host1. example.com IPv4...

Authenticating UNIX/Linux to Windows 2008R2. Part 1

Background Prior to using Windows, UNIX (eg Solaris) managed users and groups using /etc/passwd, /etc/group files, or using NIS or NIS+. Since Solaris 8, NIS+ was deprecated, with LDAP being the preferred authentication method. However, whilst Windows 2008R2 Active Directory does act as a LDAP server, it doesn't provide any authentication. Authentication is done via Kerberos/V5. This blog will document the steps required to set up Windows 2008R2 to act as a Kerberos and LDAP server to support both Linux and Solaris. VMware Workstation will be used to do the Proof-of-concept. It is expected that the SPARC version of Solaris 10 would act the same as the Intel version of Solaris 10. The following Guest UNIX Operating systems will be tested: Solaris 10 Update 9, (x86_64) Red Hat Enterprise Linux 5 Update 6 (x86_64) Red Hat Enterprise Linux 6 (x86_64) Windows 2008R2 (x64) Standard Edition will be used. Requirements VMware Workstation 7.1.4 used as the proof-of-concept hosting platform. ...

ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Issue: RMAN> backup database; Starting backup at 05-MAR-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/05/2012 12:25:05 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode continuing other job steps, job failed will not be re-run channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 05-MAR-12 channel ORA_DISK_1: finished piece 1 at 05-MAR-12 piece handle=E:\APP\NISHA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2012_03_05\O1_MF_NCSNF_TAG20120305T122505_7O8RTBXJ_.BKP tag=TAG20120305T122505 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 RMAN-00571: =====================================================...

Datastage useful shortcuts

​add this in .bash_profile ​ . /opt/IBM/InformationServer/Server/DSEngine/dsenv source ~/profile ​Create profile file in home director and below mentioned line​ ​alias ds="cd /opt/IBM/InformationServer/Server/DSEngine" alias px="cd /opt/IBM/InformationServer/Server/PXEngine" alias is="cd /opt/IBM/InformationServer" alias EDW="cd /opt/IBMProjects/EDW/" alias edw="cd /opt/IBMProjects/EDW/" alias c="clear" alias ll="ls -ltr" alias la="ls -ltra" alias l="ls" ####PS1="[$USER@$HOSTNAME \w]" hostName=`echo $HOSTNAME | cut -d . -f1 ` PS1="[$USER@$hostName \w]" ​

Undo checkout or lock by another user

Scenario: Another user has locked a file for checkout, but is no longer available to check the file back in and now you need that file.   Unlocking the file   First you will need to get a list of the workspaces for that user. This can be done with administrative rights from the command line as follows:   tf workspaces /owner:DOMAIN\TheirUserAccount /computer:*   The command will retrieve a list of all workspaces on all computers for that user.   You can now use the output information to undo the checkouts on the files you want:   tf undo /workspace:TheirWorkspace;DOMAIN\TheirUserAccount $/path/to/file   In the event the developer is no longer with the company or on the project, you can also delete the workspace which will also undo any pending changes using the following command:   tf workspace /delete TheirWorkspace;DOMAIN\TheirUserAccount /s: http://TFSSERVER:8080

How to Restore Oracle Database using RMAN (with Examples)

As a Linux sysadmin, you might recover a system from backup, which may include Oracle Database. So, it is essential for all admins to understand how to restore oracle database from backup. Typically, DBAs will use Oracle RMAN utility to take a hot backup of the database. This tutorial provides an introduction on how to restore an Oracle database from the RMAN backup. If you are new to RMAN, you should first understand how to  backup oracle database  using RMAN. For the impatient, here is a quick snippet of one particular rman restore scenario. Change this accordingly for your scenario. Read below to understand more details about these commands. RMAN> SET DBID 12345; RMAN> STARTUP NOMOUNT; RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03"; RMAN> RESTORE DATABASE; RMAN> RECOVER DATABASE; RMAN> ALTER DATABASE OPEN RESETLOGS; Verify Backup Location Before the restore, verify the current RMAN configuration on the server where ...