Backup IBM AIX Server

Hello,

The following steps helped me to backup AIX 5.3 and AIX 6.1 servers.

1st of all, we need to remove the system limits to allow us to create a large file, our backup.

Click here for more information here on IBM website

 

Edit the limits file:

vi /etc/security/limits

Allow root user to create unlimited file size by adding “fsize = -1” in its own section:

root:
    fsize = -1

We can now run our backup using smitty:

smitty mksysb

Fill in the path in the first field and change next options if needed. Press Enter to start the backup.

Advertisements

The connection cannot be completed because the remote computer that was reached is not the one you specified. This could be caused by an outdated entry in the DNS cache. Try using the IP address of the computer instead of the name.

Hi,

If you are facing this error message when trying to RDP to a Domain-joined Server :

The connection cannot be completed because the remote computer that was reached is not the one you specified. This could be caused by an outdated entry in the DNS cache. Try using the IP address of the computer instead of the name.

 

1st to check is as told by the message; DNS configuration. Client-side and Server-side.

If that’s fine, the problem is elsewhere.

You should be able to connect using the IP address

OR

using the Hostname but login with a Local Account instead of a Domain Account.

 

If I’m correct, your Server CLOCK is not Synchronized with your Domain. Simply Sync it using w32tm or modify it manually and try to connect.

 

Hope this helps.

The operation could not be completed, because the server that you specified requires a restart

Hi,

When trying to install a Role which require to install WID (Windows Internal Database), you could face an issue where it won’t install and throw this error message:

The operation could not be completed, because the server that you specified requires a restart

If we look at the Event viewer, we can find the following error:

MSSQL$MICROSOFT##WID service was unable to log on as NT SERVICE\MSSQL$MICROSOFT##WID

 

The solution is to add “NT SERVICE\MSSQL$MICROSOFT##WID” the permission to  “log on as a service”.

It can be done by editing the “Default Domain Controller” GPO:

Computer Configuration –> Policies –> Windows Settings –> Security Settings –> Local Policies –> User Rights Assignment branch and then double click the ‘Log on as a service’ setting.

Finally, run a “gpupdate /force”, restart and the Role installation should now work!

Note: In my case when the Role installation failed, it created the WID user. I was then able to add it my GPO. But after a restart, it has been removed and therefor showing as an missing SID. But anyway, it solved the problem too. Maybe the SID is kept as it is.

 

Hope this help!

 

Rename and/or move Tablespaces Datafiles

Hi everyone,

 

This article will describe how to rename and/or move Tablespaces Datafiles.

 

Put desired Tablespaces offline

SQL> alter tablespace tb1 offline normal;
SQL> alter tablespace tb2 offline normal;
SQL> alter tablespace tb3 offline normal;

 

OS side, move and rename Datafiles

# mv /previous_path/tb1.dbf /new_path/tb1_newname.dbf
# mv /previous_path/tb2.dbf /new_path/tb2_newname.dbf
# mv /previous_path/tb3.dbf /new_path/tb3_newname.dbf

 

Update file pointers in the Database control file

The following is done if you are acting on multiple Tablespaces

SQL> alter database rename file '/previous_path/tb1.dbf', '/previous_path/tb2.dbf', '/previous_path/tb3.dbf' to '/new_path/tb1_newname.dbf', '/new_path/tb2_newname.dbf', '/new_path/tb3_newname.dbf';

If only acting on one Tablespace, you can use this syntax

SQL> alter tablespace rename datafile '/previous_path/tb1.dbf', '/previous_path/tb2.dbf', '/previous_path/tb3.dbf' to '/new_path/tb1_newname.dbf', '/new_path/tb2_newname.dbf', '/new_path/tb3_newname.dbf';

 

Get Tablespaces back online

SQL> alter tablespace tb1 online;
SQL> alter tablespace tb2 online;
SQL> alter tablespace tb3 online;

 

Done.

Source : Oracle DBA Guide

 

 

 

Cannot connect remotely – ORA-01017: invalid username/password; logon denied

Hi everyone,

 

When trying to connect to my Oracle instance 12.1, I faced an issue where i was able to log in locally with SYS as SYSDBA but not remotely.

ORA-01017: invalid username/password; logon denied

In fact, for remote connection, Oracle is using a password file named “orapwSID” located in your “$ORACLE_HOME/dbs“.

Anyway, to solve this, you simply need to set your SYS password again. This will update the password file used over the network.

SQL> alter user sys identified by password;

You should now be able to connect remotely.

 

Some useful queries used during troubleshooting :

SQL> show parameter remote_login_passwordfile;
SQL> select * from v$pwfile_users;

Another way to solve this would be to delete the password file or set the parameter below to “none“.

remote_login_passwordfile Oracle doc link : https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams198.htm#REFRN10184

 

Install Oracle Database 12.1 and PostgreSQL 9.4 + PostGIS on Oracle Linux 7.4

Hey everyone,

I had to install an Oracle Linux 7.4 Server with a running Oracle Database 12.1 and PostgreSQL 9.4 + PostGIS. I will share my steps below.

 

Install Oracle Linux 7.4

  • Select “Agent for Hypervisor” during installation

 

[Optional if previous step is done] Install VMWareTools

  • From vSphere client mount source
  • From VM
# mount /dev/cdrom /mnt 
# cp /mnt/VMwareTools-8.6.17-3814316.tar.gz /tmp 
# tar -xvzf /mnt/VMwareTools-8.6.17-3814316.tar.gz 
# cd /tmp/vmware-tools-distrib/ 
# ./vmware-install.pl

 

Configure Network settings

# ip addr add 192.168.100.43/17 dev ens160 
# route add default gw 192.168.100.160 ens160 
# vi /etc/resolv.conf add  "nameserver 192.168.100.125 nameserver 192.168.100.128" 
# vi /etc/hosts add "192.168.100.43   servername.localdomain"

 

Update Yum and install Oracle Prerequisites

# yum update 
# yum install oracle-rdbms-server-12cR1-preinstall.x86_64

For Oracle Database 18c

yum install oracle-database-preinstall-18c

Set “oracle” account password

# passwd oracle

 

Set secure Linux to permissive

By editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows “SELINUX=permissive

Once the change is complete, restart the server or run the following command

# setenforce permissive

 

Disable (or configure) firewall

# systemctl stop firewalld 
# systemctl disable firewalld

 

Add new Disk for Oracle Data from vSphere client

Reboot the VM or rescan SCSI bus manually

# echo "- - -" > /sys/class/scsi_host/host#/scan

Replace “#” by “0”,”1″, … Can be found by running

# ls /sys/class/scsi_host

Then check if the new Disk is visible

# fdisk -l

 

Create a new partition and format it or follow this link to create an LVM first.

# fdisk /dev/sdb

Select option “n” select “w” to write changes and exit

# mkfs.ext4 /dev/sdb1

 

Edit fstab

# vi /etc/fstab

Add “/dev/sdb1       /u01    ext4    defaults        1 2

 

Create “u01” directory, mount the new partition, create sub-folders structure and modify permissions and ownership

# mkdir u01 
# mount -a 
# mkdir -p /u01/app/oracle/product/12.1.0.2/db_1 
# chown -R oracle:oinstall /u01 
# chmod -R 775 /u01

 

Edit “/home/oracle/.bash_profile” file

# vi /home/oracle/.bash_profile

Add the following at the end of the file

# Oracle Settings

export TMP=/tmp 
export TMPDIR=$TMP
export ORACLE_HOSTNAME=servername.localdomain 
export ORACLE_UNQNAME=orcl 
export ORACLE_BASE=/u01/app/oracle 
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1 
export ORACLE_SID=orcl
export PATH=/usr/sbin:$PATH 
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib 
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Note : For the following steps to work, Xming should be installed and running. Putty should be configured to “Enable X11 Forwarding” and you have to login with oracle user directly from Putty
Upload “linuxamd64_12102_database_1of2.zip” and  linuxamd64_12102_database_2of2.zip” to /tmp

 

Unzip the files

# cd /tmp 
# unzip linuxamd64_12102_database_1of2.zip 
# unzip linuxamd64_12102_database_2of2.zip

 

Install Oracle Database 12.1.02

# cd database
# ./runInstaller

 

Note : EM Url become https://servername.localdomain:5500/em

 

Set automatic DB startup for ORCL instance  

# vi /etc/oratab

Switch the “N” value to “Y” “orcl:/u01/app/oracle/product/12.1.0.2/db_1:Y

 

 

PostgreSQL install will come later.

Temp source: gokhanatil.com

 

 

 

 

HP-UX – File System full, stuck at boot

Hi,

I faced an issue where one of my HP-UX server’s partition became full and won’t let it fully boot. I’ll describe the steps I did the resolve the issue.

  • Reboot the server and cancel the HP-UX boot when you get the 10 seconds cool down by pressing any key. On Itanium server, you’ll face the “HPUX >” prompt.
  • Boot into single user mode by typing :
HPUX > boot vmunix -is
  • The system will boot without any problem this time. Try to mount all File System by typing :
mount -a

Note : If you get an error saying the File System is corrupted, run “fsck /dev/vg00/lvolX” on the listed partitions. One done, you can mount them again without any problem.

  • Once mounted, you gain access to all System commands like “bdf”, “sam”, “ls”, … In my case, using “bdf” showed my /var folder was 100% full.
  • I used “sam”, went to “Routine Tasks” menu to clean up/trim old Logs. (mail.log was logging to much errors and consumed too many space, in my case).
  • Finally, just issue the “reboot” command and let the server boot normally.

 

Hope this help.