Thursday, 14 January 2016

ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [1844674407370955160



Facing :  ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [1844674407370955160
==============================================================================================

Situation
============

SQL>create public database link Pub_DB_user
  connect to Pub_DB_user identified by values '1A1BB86FA3C47631'
  using 'PROD_DB';



SQL> set pages 1000 lines 180
column DB_LINK format a30
column HOST format a50
select * from dba_db_links;

OWNER                          DB_LINK                        USERNAME                       HOST                                               CREATED
------------------------------ ------------------------------ ------------------------------ -------------------------------------- ---------
PUBLIC                         Pub_DB_user                  Pub_DB_user                  PROD_DB                                             15-JAN-16



SQL> select count(*) from dual@Pub_DB_user;
select count(*) from dual@Pub_DB_user
                          *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kzdlk_zt2 err], [1844674407370955160


Solution :- (Recreate the database link using valid syntax. )
================================================================


SQL > Drop public database link "Pub_DB_user";

SQL > create public database link Pub_DB_user
      connect to Pub_DB_user identified by allow123
      using 'PROD_DB';


     
Note :-

There is MOS note related to this error: [ID 1309705.1]


 The error suggests that when the database link was created, using the syntax IDENTIFIED BY VALUES.
 this clause IDENTIFIED BY VALUES is reserved for internal Oracle use only.
 While earlier Oracle releases allowed the use of IDENTIFIED BY VALUES, this is not documented as being valid syntax.
 From Oracle release 10gR2, database links must be created using the documented syntax.

Although you could create database link using this syntax but it's not have documented as being valid syntax. So use valid when we would be create DBLINK.

  

Step–by-Step 12c oracle database installation on Linux platform (RHEL 6)


Steps 1 Pre-Installation Checks:-

Minimum Space:
Enterprise Edition: 6.4 GB
RAM: 1 GB
Swap: 2GB

Check Memory:-
   [root@12Cmachine] grep MemTotal /proc/meminfo

Check Swap space:-
       [root@12Cmachine] grep SwapTotal /proc/meminfo

Check server bit:-
      [root@12Cmachine] uname -m

Check Linux version:-
      [root@12Cmachine] cat /etc/redhat-release

Check free memory:-
     [root@12Cmachine] free –m

Check Current kernel version:-
    [root@12Cmachine] uname -a
   Linux 2.6.18-238.el5 #1 SMP Sun Dec 19 14:22:44 EST 2010 x86_64x86_64 x86_6 4 GNU/Linux

Download 12c database software:-

Minimum kernel version:-
·Red Hat Enterprise Linux 5 Update 6: 2.6.18-238.0.0.0.1.el5 or later
·Red Hat Enterprise Linux 5 Update 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.0.19 or later

Steps 2 Hostname entry:-
[root@12Cmachine]# Cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.0.31 12Cmachine.localdomain 12Cmachine

Kernel Parameters:-
[root@12Cmachine]# cat /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax= 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
[root@12Cmachine]# /sbin/sysctl – p

Security limit parameters:-
[root@12Cmachine]# cat /etc/security/limits.conf
#Oracle user limit
oracle soft nproc  16384
oracle hard nproc  16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack  10240
oracle hard stack  32768

Packages
Note: -Install all below listed packages, which are recommend by Oracle support for oracle 12c(mandate)

[root@12Cmachine]#cd /media/RHEL_6.4 x86_64 Disc 1/Packages
[root@12Cmachine]# rpm –Uvh packges_name  ( upgrade package) or
[root@12Cmachine]# rpm –ivh packages_name  ( Install fresh package)
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)

Selinux
 [root@12Cmachine]# cat /etc/selinux/config
SELINUX= enforcing  ( default)
[root@12Cmachine]# setenforce Permissive
setenforce: SELinux is disabled
 [root@12Cmachine]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=permissive
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

Create user and group:-
[root@12Cmachine]# groupadd –g 501 orainstall
[root@12Cmachine]# groupadd –g 601 dba
[root@12Cmachine]# useradd –g orainstall –G dba oracle
[root@12Cmachine]# egroup ‘orainstall|dba’   /etc/group
orainstall:x:501:
dba:x:601:oracle
[root@12Cmachine]# id oracle
uid=500(oracle) gid=501(orainstall) groups=501(orainstall),502(dba)
Change file system ownership:-
Note: - here we have given File System (/u002) ownership to ORACLE user.
[root@12Cmachine]# chown –R oracle:oinstall oracle
Create directory structure and login profile:-
[root@12Cmachine]# su - oracle
Password: ----password------
Directory:-
[oracle@12Cmachine]# mkdir –p /u002/app/oracle
[oracle@12Cmachine]# mkdir –p /u002/app/oraInventory

Profile:-
[oracle@12Cmachine]# vi .bash_profile
# Oracle env Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=12Cmachine.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=db12c; export ORACLE_UNQNAME
ORACLE_BASE=/u002/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u002/app/oracle/product/12.1.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=db12c; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[oracle@12Cmachine]#. .bash_profile
[oracle@12Cmachine]# echo $ORACLE_SID
db12c

Unzipping oracle software patches:-
[oracle@12Cmachine]# cd /media
-rwxrwxrwx. 1 oracle orainstall 1673544724 Nov 5 22:39 linuxamd64_12102_database_1of2.zip
-rwxrwxrwx. 1 oracle orainstall 1014530602 Nov 5 23:02 linuxamd64_12102_database_2of2.zip
[oracle@12Cmachine]# unzip linuxamd64_12102_database_1of2.zip –d /u002
[oracle@12Cmachine]# unzip linuxamd64_12102_database_2of2.zip -d /u002



Steps 3 Install oracle 12.1.0.2:-
[oracle@12Cmachine]# /u002/database
[oracle@12Cmachine]# ./runIntaller


























=========================      Thank You    =================================



Wednesday, 6 January 2016

Steps to change hostname




                            Step- by-step to change host name
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Command line method
=====================
1.#hostname
localhost.localdomain

2. login to root user

#su - root

3.#hostname  rac_node_1

4. Modify the host file /etc/hosts file

#vi /etc/hosts
127.0.0.1 rac_node_1 localhost.localdomain localhost4 localhost4.localdomain4

5. Modify the /etc/sysconfig/network file

# vi /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=rac_node_1
GATEWAY=192.168.1.254

6. Restart network service.

# Service network restart

Own interface eth0:  Device state: 3 (disconnected)   [OK]
Shutting down interface eth1:  Device state: 3 (disconnected) [OK]
Shutting down loopback interface:                          [  OK  ]
Bringing up loopback interface:                            [  OK  ]
Bringing up interface eth0:                                [  OK  ]
Bringing up interface eth1:  Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/2 [  OK  ]
[root@rac_node_1 Packages]# service  network status
Configured devices:
lo eth0 eth1
Currently active devices:
lo eth0 eth1


6. [root@rac_node_1 tmp]# hostname
 rac_node_1









GUI   method
================

1. Login root user
 #su – root

2. Launch GUI interface

#system-config-network

i)



ii)

iii)


4. Restart service network

 #Service network restart

Own interface eth0:  Device state: 3 (disconnected)   [OK]
Shutting down interface eth1:  Device state: 3 (disconnected) [OK]
Shutting down loopback interface:                          [  OK  ]
Bringing up loopback interface:                            [  OK  ]
Bringing up interface eth0:                                [  OK  ]
Bringing up interface eth1:  Active connection state: activated
Active connection path: /org/freedesktop/NetworkManager/ActiveConnection/2 [  OK  ]
[root@rac_node_1 Packages]# service  network status
Configured devices:
lo eth0 eth1
Currently active devices:
lo eth0 eth1


5. [root@rac_node_1 tmp]# hostname
 rac_node_1