Posts

Showing posts from August, 2020

Telegram Integration with Oracle

 How to Integrate Telegram with Oracle Apex 1) create Telegram Account in your Mobile like whatsapp 2) Ones you register in telegram apps serach for BotFather 3) To Create New Bot u need to enter below command  /newbot  Alright, a new bot. How are we going to call it? Please choose a name for your bot. Macsbot Good. Now let's choose a username for your bot. It must end in `bot`. Like this, for example: TetrisBot or tetris_bot. MacsOmanBot Done! Congratulations on your new bot. You will find it at t.me/MacsOmanBot. You can now add a description, about section and profile picture for your bot, see /help for a list of commands. By the way, when you've finished creating your cool bot, ping our Bot Support if you want a better username for it. Just make sure the bot is fully operational before you do this. Use this token to access the HTTP API:<Here you will prompt with your api> 4) /mybots (this command will return the list of bots which you have created) ...

A) How to connect SQL Developer Tools with Oracle Autonomous Cloud DB and how to Export Dump from local Db and import to Oracle Autonomous Cloud DB

Image
  A)     How to connect SQL Developer Tools with Oracle Autonomous Cloud DB   and how to Export Dump from local Db and import to Oracle Autonomous Cloud DB   Useful Link   https://blogs.oracle.com/apex/how-to-move-your-apex-applications-to-autonomous-database   https://blogs.perficient.com/2019/12/17/how-to-import-oracle-db-dumps-into-adw-using-sql-developer/   https://oracle-base.com/articles/vm/oracle-cloud-autonomous-data-warehouse-adw-import-data-from-object-store   1)     Connect Sql Developer with Oracle Autonomous Cloud DB   è Go to Oracle Cloud Infrastructure and login with your credential     Go to  Autonomous Transaction Processing     Click on Autonomous Database which you have created     Click on Service Console     go to Administration and Download the client Credential (Wallet) key             Enter the Password and click on dow...

Email Configuration in Oracle Apex

Image
 1) In Apex go to apex_admin--> Manage Instance --> Instance Settings --> Email  SMTP Host Address: localhost SMTP Host Port: 25 ========= ========= ========= ========= ========= 2) Email Configuration  ========= ========= ========= ========= ========= Smtp Server Configuration In Window Server  https://www.vionblog.com/windows-smtp-server-relay-gmail/ ========= ========= ========= ========= ========= 3) Oracle SQL ========= ========= ========= ========= conn sys/password as sysdba @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb @$ORACLE_HOME/rdbms/admin/utlsmtp.sql grant execute on utl_mail TO public; grant execute on utl_smtp to public; alter system set smtp_out_server='localhost' or 'ipaddress' select * from V$PARAMETER where name=‘smtp_out_server' alter system set job_queue_processes = 10;   ========= ========= ========= ========= 4)ACL Acess ...