Monday, February 22, 2016

Missing pdksh-5.2.14 package during Oracle database installation prerequisite

=====================Missing pdksh-5.2.14===============================

Missing pdksh-5.2.14 package during Oracle database 11.2.0.4 install on Oracle Linux 6.5 (Doc ID 1962046.1)

its Bug 19947777

Install ksh package then ignore the waring and proceed with installation

[root@test ~]# yum install ksh



Missing pdksh-5.2.14 package during Oracle database install (Doc ID 1962046.1)

Delete / Remove User Account : Error : Creating mailbox file: File exists

[root@test ~]# /usr/sbin/useradd -g oinstall -G dba,oper oracle
Creating mailbox file: File exists
[root@test ~]#

[root@test mail]# pwd
/var/spool/mail

delete oracle file

[root@test mail]# ls -lrt
total 0
-rw-rw----. 1 rpc   mail 0 Feb 21 22:12 rpc
-rw-rw----. 1 54321 mail 0 Feb 22 00:26 oracle
[root@test mail]#
[root@test mail]# cat oracle
[root@test mail]#
[root@test mail]# rm -rf oracle
[root@test mail]#
[root@test mail]# userdel -r oracle
[root@test mail]# /usr/sbin/useradd -g oinstall -G dba,oper oracle
[root@test mail]#

Starting httpd: httpd: apr_sockaddr_info_get() failed for test.dba.com

[root@test repo]# service httpd start
Starting httpd: httpd: apr_sockaddr_info_get() failed for test.dba.com
httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
                                                           [  OK  ]
[root@test repo]#
[root@test repo]#
[root@test repo]#
[root@test repo]# cd /etc/httpd/
conf/    conf.d/  logs/    modules/ run/
[root@test repo]# cd /etc/httpd/conf.d/
mod_dnssd.conf  php.conf        README          welcome.conf
[root@test repo]# cd /etc/httpd/conf/
httpd.conf  magic
[root@test repo]# cd /etc/httpd/conf/
[root@test conf]# ls
httpd.conf  magic
[root@test conf]#
[root@test conf]# cp httpd.conf httpd.conf_org
[root@test conf]#
[root@test conf]#
[root@test conf]# vi httpd.conf
[root@test conf]#

Changes
# ServerName gives the name and port that the server uses to identify itself.
# This can often be determined automatically, but we recommend you specify
# it explicitly to prevent problems during startup.
#
# If this is not set to valid DNS name for your host, server-generated
# redirections will not work.  See also the UseCanonicalName directive.
#
# If your host doesn't have a registered DNS name, enter its IP address here.
# You will have to access it by its address anyway, and this will make
# redirections work in a sensible way.
#
#ServerName www.example.com:80
ServerName 192.168.0.61(your system ip)



#


[root@test conf]#
[root@test conf]# service httpd stop
Stopping httpd:                                            [  OK  ]
[root@test conf]#
[root@test conf]# service httpd start
Starting httpd:                                            [  OK  ]
[root@test conf]#
[root@test conf]#

[root@test conf]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
[root@test conf]#
[root@test conf]#
[root@test conf]#


Then check from browser 

192.168.0.61

Enjoy!!!!

Complex Oracle 19c to PostgreSQL 15 Database Migration

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...