Change Apex Deployment Port

-
conn sys/manager1@cispdb as sysdba 

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

EXEC DBMS_XDB.SETHTTPPORT(8080);

SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

Comments

Post a Comment

Popular posts from this blog

DBMS_CLOUD.COPY (Upload Excel/CSV Data into Table on cloud)

-
  1) Create Credential on Cloud  2) Login with sql developer 3) Create table in my case TVEH 4) Perform the below  procedure  begin DBMS_CLOUD.COPY_DATA(     table_name =>‘TVEH’,     credential_name =>‘DEV’,     file_uri_list =>‘ https://objectstorage.us-ashburn-1.oraclecloud.com/n/<name space name >/b/BigData/o/file_name.csv ’,     format => json_object(‘type’ value ‘CSV’,‘ignoremissingcolumns’ value ‘true’,‘rejectlimit’ value ‘100’)  );
Read more

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) ...
Read more

Configure ACL DB12c

-
ACL Error 1) Granting Connect Privileges Prior to Oracle Database 12c Demonstrates how to grant connect privileges to any host for the APEX_200100 database user. The following example demonstrates how to grant connect privileges to any host for the APEX_200100 database user. This example assumes you connected to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. DECLARE   ACL_PATH  VARCHAR2(4000); BEGIN   -- Look for the ACL currently assigned to '*' and give APEX_200100   -- the "connect" privilege if APEX_200100 does not have the privilege yet.     SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS    WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;     IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_200100',      'connect') IS NULL THEN       DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,     ...
Read more