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.
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
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
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”
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/188.8.131.52/grid/bin/oracle have a good day.
Hello, to get awr report : connect to oracle db as sysdba percula40: / home / oracle # sqlplus / as sysdba SQL * Plus: Release 184.108.40.206.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 220.127.116.11.0 - 64bit Production With … Continue reading AWR Report on the Oracle Database
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