Oracle: Resolve ORA-00257 – Connect AS SYSDBA only until resolved

Recently, one of the Oracle users complained that the database was unusable and received the error below I looked at the space situation and it looked good (PowerShell command is from the dbatools module¬†and allows you to get this server space info. from your own host) Next, I looked at the alert log and saw … Continue reading Oracle: Resolve ORA-00257 – Connect AS SYSDBA only until resolved

Advertisements

Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables

Today I received a request from an application owner who wanted to know the size of all the CLOB and BLOB columns in all the non-system tables so that they have a good idea of the size involved for a migration. Tables with BLOB/CLOB columns The SQL to find the tables with the BLOB/CLOB columns … Continue reading Oracle: Find The Total Size Of All Of Your CLOB & BLOB Columns In All Tables

Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

This is one of those obscure errors that has no answer on the Web. I ran into this error trying to migrate an Oracle table to SQL Server (one of many). The issue seemed to be only with certain rows of this table as it migrated majority of the data without issues. Below is the … Continue reading Oracle & .NET: Resolve – Exception calling “Fill” with “1” argument(s): ‘count’ must be non-negative.

Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive

I wanted to do a small post on using the DOS command line tool ADRCI to quickly locate problems from the alert log and acting on them to fix the issue(s) when using Oracle on Windows. It should not be much different on Linux.¬†This is a 100 level post. The call: Timeouts Another normal day … Continue reading Oracle On Windows – Simple Timeout To Crisis To Moving Data Files to Another Drive