Troubleshooting

A colleague faced this while running FMW installer on a Linux machine. The display appeared like this This thread gave a clue that it could have something to do with fonts. So I checked what all fonts related stuff was installed. [bash][root@someserver ~]# rpm -aq |grep -i font stix-fonts-1.1.0-5.el7.noarch xorg-x11-font-utils-7.5-20.el7.x86_64 xorg-x11-fonts-cyrillic-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-1-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-9-100dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-9-75dpi-7.5-9.el7.noarch libXfont-1.5.2-1.el7.x86_64 xorg-x11-fonts-ISO8859-14-100dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-1-100dpi-7.5-9.el7.noarch xorg-x11-fonts-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-2-100dpi-7.5-9.el7.noarch libfontenc-1.1.3-3.el7.x86_64 xorg-x11-fonts-ethiopic-7.5-9.el7.noarch xorg-x11-fonts-100dpi-7.5-9.el7.noarch xorg-x11-fonts-misc-7.5-9.el7.noarch fontpackages-filesystem-1.44-8.el7.noarch fontconfig-2.10.95-11.el7.x86_64 xorg-x11-fonts-ISO8859-2-75dpi-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-14-75dpi-7.5-9.el7.noarch xorg-x11-fonts-Type1-7.5-9.el7.noarch xorg-x11-fonts-ISO8859-15-75dpi-7.5-9.el7.noarch [root@someserver ~]#[/bash] ...

Got this while trying to install 11.2.0.4 RAC on Redhat Linux 7.2. root.sh fails with a message like [sql]ohasd failed to start Failed to start the Clusterware. Last 20 lines of the alert log follow: 2017-11-09 15:43:37.883: [client(37246)]CRS-2101:The OLR was formatted using version 3.[/sql] This is bug 18370031. Need to apply the patch before running root.sh.

There was an interesting issue at one of the customer sites. Few tables in the database were altered and the dependent objects became invalid. But the attempts to compile the objects using utlrp.sql or manually were failing. In all the cases it was giving the same error: SQL> alter function SCOTT.SOME_FUNCTION compile; alter function SCOTT.SOME_FUNCTION compile * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 27 SQL> At first look it sounded like some issue with the dictionary as the error in case of every object (be it a view, function or package) was the same. ...

Today I was running export of an Oracle 9.2.0.1 database. The export completed but with an ORA-600 error: [sourcecode language=‘css’] EXP-00008: ORACLE error 600 encountered ORA-00600: internal error code, arguments: [xsoptloc2], [4], [4], [0], [], [], [], [] ORA-06512: in “SYS.DBMS_AW”, line 347 ORA-06512: in “SYS.DBMS_AW”, line 470 ORA-06512: in “SYS.DBMS_AW_EXP”, line 270 ORA-06512: in line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp[/sourcecode] I googled a bit and found that the problem is with applying some patchset. Then metalink confirmed the same. Somebody tried applying a patch to upgrade it to 9.2.0.5 but didn’t perform all the steps (missed post installation steps, to be precise). Metalink Note 300849.1 covers the issue and also gives the solution. In nutshell startup the database with startup migrate and run catpatch.sql. ...

Today one of my colleague was working on a simple PL/SQL procedure. Based on some logic it was returning count(*) from all_tab_columns for few tables. It gave count incorrectly for one table out of around fifty in total. He just hard coded the table name and ran it but again it showed count as zero. Then he took the code out of procedure and wrote it in DECLARE, BEGIN, END and after running it showed the correct count. But ran as database procedure it always shows incorrectly. ...

At my workplace we were facing a problem with refresh of a mview. Say it was created in schema of user1 but when I tried to refresh it from user2 it would give ORA-03113: end-of-file on communication channel. Then we raised a SR and have been following up with Oracle support for long but it was not getting anywhere. Yesterday that guy seemed to have reached some point. The mviews that we have created and are having problem with refresh are created on top of both local & remote objects and he said that up to 11gr2 there is no possibility of creating mviews on both local and remote objects. I did validate this thing. All the mviews failing to refresh are created on top of both local & remote objects. But again from the owner the refresh is fine but from another user it gives problem. By the way that guy hinted at bug 4084125 and also suggested a work around. I haven’t tried that yet. Will try and update about the results. ...