Oracle Sql output format

I am using the following form for regular sql output SET LINESIZE 32000; SET PAGESIZE 40000; SET LONG 50000;  for example show Oracle Asm disks status : SQL> select GROUP_NUMBER,MOUNT_STATUS,STATE,REDUNDANCY,NAME,PATH from v$asm_disk; output like this.

Advertisements

PL/SQL: could not find program unit being called– Errors

hello, if you are executing Plsql scripts sometimes you can see this errors. PL/SQL: could not find program unit being called. Solutions : Check that all packages, procedure, Functions,programs, including their package bodies is invalid.  You must change status all invalid object to valid.  plsql> EXEC PCOMFLX_PR.MIGRATION.FULL_MIGRATION(2121); Error : ORA-04063: package body "PCOMFLX_PR.MIGRATION" has errors ORA-06508: … Continue reading PL/SQL: could not find program unit being called– Errors

Oracle Database File System Layout

File System Layout When a database deployment is created using the Oracle Database Cloud Service service level, Oracle Cloud Service storage volumes are created and allocated as follows. File System Mount Description swap Swap space; 4 GB allocated from the boot Compute Cloud storage volume. / (root) Operating system files; 25.5 GB allocated from the … Continue reading Oracle Database File System Layout

XSHELL – “No matching outgoing encryption algorithm found”

Hello,  I use xshell 5 connect to oracle database (open sshd) , but  while connecting oracle db i saw  message show "No matching outgoing encryption algorithm found" errors. So basic this problem solutions. please step by step follow this slayt abstract : Go to the session properties > SSH > Security and click on the … Continue reading XSHELL – “No matching outgoing encryption algorithm found”

UDI-27140: operation generated ORACLE error 27140 Error Solutions

Hello,  UDI-27140: operation generated ORACLE error 27140 error solutions: connect to root  ( Oracle home and Grid home ) chmod 6751 /$ORACLE_HOME/bin/oracle chmod 6751  /oracle/product/11.2.0.4/grid/bin/oracle   have a good day.  

AWR Report on the Oracle Database

Hello, to get awr report : connect to oracle db as sysdba percula40: / home / oracle # sqlplus / as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Tue Mar 27 13:44:46 2018 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With … Continue reading AWR Report on the Oracle Database

Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded

hello, I am getting an ORA-01000 SQL exception. problem description: Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.driver.T4CTTIoer.processError (T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError (T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError (T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive (T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC (T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall .__ AW_doOALL (T4C8Oall.java:531) at oracle.jdbc.driver.T4C8Oall.doOALL (T4C8Oall.java) at oracle.jdbc.driver.T4CCallableStatement .__ AW_doOall8 (T4CCallableStatement.java:204) at oracle.jdbc.driver.T4CCallableStatement.doOall8 (T4CCallableStatement.java) solution:  connect to db as sysdba than … Continue reading Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded