Source: SQL Tuning by Example
Author: Peter Sliwinski-Clausner
Analyzing the Listener.log
Source: Analyzing the Listener.log
studieren-master-of-disaster
DBA role for anyone?
DBA role grant to myselft (tested in 12.2) thanks to Pete Finnigan for explanation "this is not an exploit, this is due to the privileges granted" CREATE USER "TUSER" IDENTIFIED BY VALUES 'S:B368AC805D18763B7ABB524F49E264B5FB86C3A33574D41EEEEBCF96E08A;T:E1F2507A6EB276AF7C7C43FF1BBF5E BB31C5518EAA2E4F1EB1BB639D9B5A14C8D7AD4CF476D1C147C8869FE628963D2BA0C4808257D81DC81D5373CA2C3CAE739288D97C97F2D87E39069DB2E1F629DA' DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"; -- Note: No TS Quotas found! GRANT "CONNECT" TO "TUSER" GRANT "RESOURCE" TO "TUSER" GRANT … Continue reading DBA role for anyone?
Arik’s Recipes
Source: Recipes
Oracle 12.2 COLLATE BINARY_CI
1st db went online a week ago sofar so good Issues PL/SQL compile 0/0 PL/SQL: Compilation unit analysis terminated 0/0 PLS-00761: Programmeinheitsortierung darf nur USING_NLS_COMP sein SQL> alter session set default_collation=USING_NLS_COMP; Triggers An error in trigger PLS-00049: bad bind variable after converting tables to COLLATE BINARY_CI; SR will be created CREATE TABLE "CI"."TESTTAB" ( "ID" … Continue reading Oracle 12.2 COLLATE BINARY_CI
ORA-43915: unable to determine collation: arguments have conflicting collations
schema B with default collation = BINARY_CI schema B with default collation = USING_NLS_COMP join tables from both schemas produces error ORA-43915: unable to determine collation: arguments have conflicting collations Solution recreate table in B schema with BINARY_CI R/
ORA-1246 TNS:permission denied
set permission on Oracle binary: cd $ORACLE_HOME/bin chmod 6755 oracle permissions on /oracle/xxxxxxxxxxx/dbms122/bin/oracle not correct /xxxi/hbai>ls -altr $ORACLE_HOME/bin/oracle -rwsrws--- 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle These are correct -rwsr-s--x 1 hsxxx dba 408095920 9. Aug 13:41 /oracle/xxxxxxxxxxx/dbms122/bin/oracle