Autonomous Transaction Processing

Get Involved. Join the Conversation.

Topic

    Ranveer Tiwari
    How to deploy DB Code in ATP, as we dont have OS Access...
    Topic posted June 26, 2019 by Ranveer TiwariRed Ribbon: 250+ Points, tagged DBCS, Transaction Processing 
    60 Views, 2 Comments
    Title:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Summary:
    How to deploy DB Code in ATP, as we dont have OS Access where we can use Shell Script?
    Content:

    How to deploy DB Code in ATP, as we don't have OS Access where we can deploy bulk code using a Shell Script?

    Version:
    Code Deployment, ATP, OS Access, DBCS

    Comment

     

    • dominic giles

      You will need to run the scripts with a remote connection (i.e. client server). This is not any different than what would have happened if you'd run the scripts locally. Ideally you should have compute resource in OCI to run the scripts. It's not a requirement but it might help if you need to run a large number of "chatty" scripts. Oracle makes the installation of client scripts simple via a yum install for Oracle Instant client.

      Dom

    • enrique ortiz

      hi 

      we have moved some databases to the cloud using ATP 

      we have installed a ubuntu vm in a free instance ( VM.Standard.E2.1.Micro ) and installed the oracle 18.5 instant client , configured the instant client with the wallet and test all script from these machine.

      the only problem was some scripts using sqlplus / as sysdba . we need to run it manually from sqldeveloper using the admin user 

      Best