EXP-00091 Exporting Questionable Statistics

EXP-00091 Exporting Questionable Statistics

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11.2.0.4

Description:

After upgrade Oracle Database from 11.2.0.1.0 to 11.2.0.4.0, when export database user dump face the following error:

“EXP-00091 Exporting questionable statistics”

Solution:

            I have found that the error occur when try to export table data with its related optimizer statistics. To fix the error run export with parameter “statistics=none”:

exp scott/tiger file=exp_scott.dmp statistics=none

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

Unable to Connect Oracle Database Server from Oracle Client - Change Oracle Database Character Set

Unable to Connect Oracle Database Server from Oracle Client - Change Oracle Database Character Set

Applies to:

            Oracle Enterprise Linux – Version: 5

            Oracle EBS R12

           

Description:

I have installed a new VISION instance on Oracle Linux 5. All is going well, all configuration and setup completed successfully. All services of Database and Application started successfully. Application is also working fine from client side.

I have a problem to connect database from client side. TNSNAMES.ORA file also configured on client side but unable to connect SQLPLUS.

SQLPLUS session going to hang/close when trying to connect:

CMD> Sqlplus apps/apps@VIS

Solution:

After some research I found that the character set of Database is default to “AL16UTF16” which create the problem to connect the database from a windows client.

So that to fix the problem, change the character set from “AL16UTF16” to “WE8MSWIN1252”

To fix the problem do the following steps:

1.    Check the current Character Set of Database execute the following query from sysdba

SQL> select value$ from sys.props$ where name = ‘NLS_CHARACTERSET’;

In my case above query return “AL16UTF16”

2.    To change the Database character set do the following queries:

SQL> shutdown immediate;

SQL> startup mount;

SQL> alter system enable restricted session;

SQL> alter system set JOB_QUEUE_PROCESSES=0;

SQL> alter system set AQ_TM_PROCESSES=0;

SQL> alter database open;

SQL> alter database CHARACTER SET INTERNAL_USE WE8MSWIN1252;

SQL> shutdown;

SQL> startup restrict;

SQL> shutdown;

SQL> startup;

SQL> alter system set JOB_QUEUE_PROCESSES=1000;

SQL> alter system set AQ_TM_PROCESSES=1;

3.    Re-start the Database and Listener

4.    Now able to connect Oracle Database from Windows Client

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

Late Charges Report Print Wrong Date - Less Than 1 Day of the Original Date

Late Charges Report Print Wrong Date - Less Than 1 Day of the Original Date

Applies to:

            Oracle Receivables R12 12.1.3

            Oracle Database 11.1.0.7.0

Description:

We have noted that the “Late Charges Report” print the wrong date less than 1 day of the original date.

Responsibility: Receivables Manager

Navigation: Late Charges à Generate Late Charges à Late Charges Generate

Solution:

After some research work I found the solution to apply the following patch:

Patch 26500596

           

·         You should take backup of your system before applying the patch

·         First apply patch in a TEST environment

·         Re-test the issue

I have fixed my issue by applying the above patch, now the date print accurately.

           

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

How to Configure Automounter AUTOFS to access Windows Share Folder

How to Configure Automounter AUTOFS

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11.2.0.4

Description:

I need to access Windows Shared Folder from Oracle Enterprise Linux 7 through AUTOFS.

Solution:

To configure AUTOFS follow the simple steps:

           

Following two rpm’s required:

yum install autofs -y

yum install cifs-utils -y

mkdir /sep

Edit /etc/auto.master file and add the following line under /misc:

/sep    /etc/auto.sep

Save and exit

Now create or edit /etc/auto.sep file and add the following line:

Backups -fstype=cifs,rw,noperm,user=<username>, pass=<password>://192.168.1.2/<winshare>

Save and exit

<username> = windows user name

<password> = windows password

<winshare> = windows share folder

Service autofs restart

Now try to access your share:

Cd /sep/Backups/

df -h

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

Error in invoking target agent nmhs of makefile

Error in invoking target agent nmhs of makefile

Applies to:

            Oracle Enterprise Linux – Version: 7

            Oracle Database 11.2.0.4

Description:

After successful installation of Oracle Linux 7, when I start the installation of Oracle Database 11.2.0.4 it is going to hang on 70%, installation log file show the following error:

Exception Name: MakefileException

Exception String: Error in invoking target ‘agent nmhs’ of makefile

Solution:

To fix the above problem follow the simple steps:

           

Edit this file:

-       /d01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk

-       Change the following:

OLD: $(MK_EMAGENT_NMECTL)

NEW: $(MK_EMAGENT_NMECTL) –lnnz11

Restart the Database installation, now it is completed successfully.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

How to Change the Boot Sequence of Oracle Linux 7

How to Change the Boot Sequence of Oracle Linux 7

Applies to:

            Oracle Enterprise Linux – Version: 7

Description:

After successful installation of Oracle Linux 7, when I restart the Linux I should select the second option from boot sequence within 3 second to start up the Oracle Linux.

Solution:

            To change the boot sequence in Oracle Linux 7 follow the simple steps:

           

GRUB2 count the menu entries in the configuration file starting at 0 for the first entry.

To display the menu entries that are defined in the configuration file:

[root@khi]# cd /boot/grub2

[root@khi grub2]# grep '^menuentry' /boot/grub2/grub.cfg

menuentry 'Oracle Linux Server (4.1.12-61.1.18.el7uek.x86_64 with Unbreakable Enterprise Kernel) 7.3' --class oracle --class gnu-linux --class gnu --class os --unrestricted $menuentry_id_option 'gnulinux-4.1.12-61.1.18.el7uek.x86_64-advanced-8898f753-92f7-4919-9b33-a389fbeceae9' {

menuentry 'Oracle Linux Server (3.10.0-514.el7.x86_64 with Linux) 7.3' --class oracle --class gnu-linux --class gnu --class os --unrestricted $menuentry_id_option 'gnulinux-3.10.0-514.el7.x86_64-advanced-8898f753-92f7-4919-9b33-a389fbeceae9' {

menuentry 'Oracle Linux Server (0-rescue-6cd2d0dcb059426f838f676d4963ff2d with Linux) 7.3' --class oracle --class gnu-linux --class gnu --class os --unrestricted $menuentry_id_option 'gnulinux-0-rescue-6cd2d0dcb059426f838f676d4963ff2d-advanced-8898f753-92f7-4919-9b33-a389fbeceae9' {

I need to boot Oracle Linux from second menuentry, to set the second menuentry for default boot execute the following command:

[root@khi grub2]# grub2-set-default 1

You must run the grub2-mkconfig command to re-generate the /boot/grub2/grub.cfg file:

[root@khi grub2]# grub2-mkconfig -o /boot/grub2/grub.cfg

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

How to Configure Tiger VNC Server on Linux 7

How to Configure Tiger VNC Server on Linux 7

Applies to:

            Oracle Enterprise Linux – Version: 7

Description:

            After successful installation of Oracle Linux 7, I need to configure VNC for remote access.

Solution:

            To configure Tiger VNC server on Oracle Linux 7 follow the simple steps:

           

To check the required rpm’s:

[root@testora ~]# rpm –qa |grep tigervnc

Install tigervnc-server

[root@testora ~]# yum install tigervnc-server –y

             

To create a user for VNC:

[root@testora ~]# adduser vncuser

[root@testora ~]# passwd vncuser

[root@testora ~]# su - vncuser

[vncuser@testora ~]$ vncpasswd

Password:

Verify:

[vncuser@testora ~]$ exit

[root@testora ~]#

Copy the following file:

[root@testora ~]# cp /lib/systemd/system/vncserver@.service /etc/systemd/system/vncserver@\:1.service

Edit the copied file.

[root@testora ~]# vi /etc/systemd/system/vncserver@\:1.service

At the end of the file, you will find the lines like below.

[Unit]

Description=Remote desktop service (VNC)

After=syslog.target network.target

[Service]

Type=forking

# Clean any existing files in /tmp/.X11-unix environment

ExecStartPre=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'

ExecStart=/sbin/runuser -l <USER> -c "/usr/bin/vncserver %i"

PIDFile=/home/<USER>/.vnc/%H%i.pid

ExecStop=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'

[Install]

WantedBy=multi-user.target

Replace <USER> with your real user, in my case, i replaced with a user called “vncuser”

[Unit]

Description=Remote desktop service (VNC)

After=syslog.target network.target

[Service]

Type=forking

# Clean any existing files in /tmp/.X11-unix environment

ExecStartPre=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'

ExecStart=/sbin/runuser -l vncuser -c "/usr/bin/vncserver %i"

PIDFile=/home/vncuser/.vnc/%H%i.pid

ExecStop=/bin/sh -c '/usr/bin/vncserver -kill %i > /dev/null 2>&1 || :'

[Install]

WantedBy=multi-user.target

Add TCP Port in Firewall config:

[root@testora ~]# firewall-cmd --permanent --zone=public --add-port=5901/tcp

[root@testora ~]# firewall-cmd --reload

Reload the systemctl daemon as root

[root@testora ~]# systemctl daemon-reload

Start the VNC service as root.

[root@testora ~]# systemctl start vncserver@\:1.service

To check the status of vncserver:

[root@testora ~]# systemctl status vncserver@\:1.service

â vncserver@:1.service - Remote desktop service (VNC)

   Loaded: loaded (/etc/systemd/system/vncserver@:1.service; enabled; vendor preset: disabled)

   Active: active (running) since Tue 2018-12-11 10:58:07 PKT; 6s ago

  Process: 9681 ExecStart=/usr/sbin/runuser -l vncuser -c /usr/bin/vncserver %i (code=exited, status=0/SUCCESS)

  Process: 9673 ExecStartPre=/bin/sh -c /usr/bin/vncserver -kill %i > /dev/null 2>&1 || : (code=exited, status=0/SUCCESS)

 Main PID: 9723 (Xvnc)

   CGroup: /system.slice/system-vncserver.slice/vncserver@:1.service

           ⣠9723 /usr/bin/Xvnc :1 -desktop testora.test.org:1 (vncuser)...

Dec 11 10:58:04 testora.test.org systemd[1]: Starting Remote desktop ser...

Dec 11 10:58:07 testora.test.org systemd[1]: Started Remote desktop serv...

Hint: Some lines were ellipsized, use -l to show in full.

Enable it on system startup as root.

[root@testora ~]# systemctl enable vncserver@\:1.service

If the above procedure did not work, do the following:

[root@testora ~]# rm –rf /tmp/.X*-lock

[root@testora ~]# rm –rf /tmp/.X11-unix/X*

[root@testora ~]# systemctl restart vncserver@\:1.service

OR do the following:

[root@testora ~]# vncserver

You will require a password to access your desktops.

Password:

Verify:

xauth:  file /root/.Xauthority does not exist

New 'testora.test.org:1 (root)' desktop is testora.test.org:1

Creating default startup script /root/.vnc/xstartup

Starting applications specified in /root/.vnc/xstartup

Log file is /root/.vnc/testora.testt.org:1.log

Now you can access your Linux server from any client using VNC Viewer.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ