Discussion List

• Access tables within a stored procedure from another schema. Error: table or view does not exist

  Answered ✓ 111 views 16 comments 0 points Most recent by SureshMuddaveerappa Apr 5, 2024 9:07PMDatabase - RAC/Scalability (MOSC)
• CLONE Remote NON-CDB to PDB in READ-WRITE

  Answered ✓ 52 views 6 comments 0 points Most recent by T1DSoldier Mar 28, 2024 2:22PMDatabase Administration (MOSC)
• Sanity check, looking for clarification on use_dedicated_broker parameter.

  Answered ✓ 21 views 3 comments 0 points Most recent by Masiuddin Ahmed-Oracle Mar 21, 2024 11:53AMDatabase Administration (MOSC)
• SELECT_CATALOG_ROLE or SELECT ANY DICTIONARY

  Answered ✓ 453 views 1 comment 0 points Most recent by Arsalan Dehghanisariyarghan Mar 14, 2024 9:20PMDatabase Administration (MOSC)
• Startup time/Shutdown time - CDB/PDB history

  522 views 3 comments 1 point Most recent by SureshMuddaveerappa Mar 8, 2024 4:39PMDatabase - RAC/Scalability (MOSC)
• crsctl status res -t --- Output formatting issue

  Answered ✓ 323 views 4 comments 0 points Most recent by Kuljeet Singh - Oracle-Oracle Feb 29, 2024 1:06PMDatabase - RAC/Scalability (MOSC)
• Can we Create Policies in Traditional audit

  Answered 21 views 2 comments 0 points Most recent by Masiuddin Ahmed-Oracle Feb 29, 2024 6:04AMDatabase Administration (MOSC)
• Unable to access USB on and ODA

  Answered 1 view 4 comments 0 points Most recent by Asanka Jan 1, 2024 7:24AMOracle Database Appliance (ODA) (MOSC)
• Exadata - VIP stat is Intermediate

  Question 1 view 0 comments 0 points Most recent by Asanka Dec 19, 2023 5:42PMExadata General (MOSC)
• Find SYS default objects

  Answered ✓ 41 views 5 comments 0 points Most recent by SureshMuddaveerappa Dec 10, 2023 4:49PMDatabase Administration (MOSC)
• join dba_sys_privs, dba_roles, dba_tab_privs - for each user create roles

  Answered 21 views 2 comments 0 points Most recent by Balamurugan Sivalingam Oct 20, 2023 8:22PMDatabase - RAC/Scalability (MOSC)
• Kerberos authentication to connect to database using SQL Developer fails/TOAD connection works

  Question 671 views 0 comments 0 points Most recent by JackR Aug 31, 2023 4:55PMDatabase Administration (MOSC)
• Privileges cannot assigned to a global role

  Answered 31 views 13 comments 0 points Most recent by SureshMuddaveerappa Aug 25, 2023 10:21PMDatabase - RAC/Scalability (MOSC)
• rdbms trace file - filling up with 10046

  Answered 1 view 1 comment 0 points Most recent by SureshMuddaveerappa Aug 25, 2023 9:02PMDatabase - RAC/Scalability (MOSC)
• Issue with client not finding the credential in the cache(CC file) - Kerberos authentication

  11 views 3 comments 0 points Most recent by MG1 Aug 19, 2023 9:15PMDatabase Security Products (MOSC)
• Finding objects referenced in SQL query

  Answered 41 views 4 comments 0 points Most recent by Justin Bleistein Aug 17, 2023 12:21PMDatabase Tuning (MOSC)
• Audit data copy from sys.dba_audit_trail - UTC time issue

  Answered 11 views 2 comments 0 points Most recent by SureshMuddaveerappa Aug 16, 2023 10:58PMDatabase Administration (MOSC)
• Best method to migrate/moving Data from NoSQL Databases(Apache Cassandra) to Oracle Datbase 19c

  Answered 154 views 1 comment 0 points Most recent by SureshMuddaveerappa Aug 14, 2023 2:38PMDatabase Administration (MOSC)
• create and assign audit policy to capture, create, alter, drop, enable or disable job

  Answered 71 views 2 comments 0 points Most recent by JohnWatson2 Aug 14, 2023 8:10AMDatabase Administration (MOSC)
• IMPDP - without data - running out of space

  Answered 21 views 3 comments 0 points Most recent by SureshMuddaveerappa Aug 13, 2023 11:39PMDatabase - RAC/Scalability (MOSC)
• User last logged in time / user login audit

  Answered ✓ 51 views 2 comments 1 point Most recent by JackR Jul 21, 2023 2:49AMDatabase - RAC/Scalability (MOSC)
• Query using wrong execution plan - Took long time to finish

  191 views 7 comments 0 points Most recent by SureshMuddaveerappa Jul 14, 2023 7:32PMDatabase Administration (MOSC)
• proxy_users - column FLAGS

  Answered ✓ 21 views 3 comments 0 points Most recent by SureshMuddaveerappa Jul 5, 2023 8:54PMDatabase Administration (MOSC)
• Compare AWR between different instances

  Answered ✓ 161 views 11 comments 0 points Most recent by T1DSoldier Apr 27, 2023 2:12PMDatabase Tuning (MOSC)
• Excerpt the DB-config to use in a VM /or: clone a DB-configuration

  Answered ✓ 11 views 5 comments 0 points Most recent by SureshMuddaveerappa Apr 12, 2023 2:14PMDatabase Administration (MOSC)
• ORA-12801 + ORA-08005: specified row does not exist

  Answered 171 views 6 comments 0 points Most recent by JackR Apr 10, 2023 3:30PMDatabase - RAC/Scalability (MOSC)
• relocate service to multiple nodes 19c

  Answered 31 views 5 comments 0 points Most recent by JackR Apr 7, 2023 9:38PMDatabase - RAC/Scalability (MOSC)
• ORA-12850: Could not allocate slaves on all specified instances:

  Answered ✓ 122 views 3 comments 0 points Most recent by JackR Mar 21, 2023 9:09PMDatabase - RAC/Scalability (MOSC)
• remote_dependencies_mode in pluggable database

  Answered ✓ 21 views 7 comments 0 points Most recent by SureshMuddaveerappa Mar 17, 2023 12:41PMDatabase Administration (MOSC)
• using Oracle client 21c to connect to 19c database.

  Answered 1K views 2 comments 0 points Most recent by Helmut -Oracle Mar 6, 2023 7:12AMDatabase - RAC/Scalability (MOSC)