Skip to Main Content

Ask The Oracle Mentors

Recently Answered

Recently Answered 2.0

  • #SELECTION#
    Chris Saxon

    ORA-01034: ORACLE NOT AVAILABLE

    connect system password : password. i got following errors ORA-01034: ORACLE NOT AVAILABLE ORA-27101: shared memory realm does not exist
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    SQL-profile

    SQL-Profile fundamentally are additional optimizer statistics at the SQL statement level generated by SQL-Tuning-Advisor to fill the gaps of Oracle Optimizer. My question is, can these additional finer optimizer-statistics within profiles, be shared/used by other similar SQL stat...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Large table and small table behave differently when defining cursors

    Hi, Tom, I do two tests about cursor in ORACLE 19.3C. In test1 why print "x" is normal but print "y" is abnormal ? In test2 why print "y" run half of the way ? I get information from: https://asktom.oracle.com/pls/apex/asktom.search?tag=ora-08103object-no-longer-exists [Test1] S
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    Configuring TLS for connections from Oracle database to another server

    Hello, How to configure TLS for connections from Oracle database to another server (e.g mailing server)? We have an on premises SMTP email sever to which the database pushes the emails to be sent out. All internal emails are working perfectly but external emails (e.g to Gmail) ar...
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Connor McDonald

    ETL and replication

    We have a system in which reference data (about 100 tables) is created and maintained by a set SMEs in a specific database for this purpose. On frequent (by not regular) occasions, the schema is cloned to another schema which acts as a source for distribution to other databases. ...
    #MISC#
    #ACTIONS#

Upcoming Office Hours

Upcoming Office Hours Cards

Free training, how-tos and Q&A with Oracle experts, every month! Learn more