I have been to Hong Kong several times and I am very much familiar with most of the places in Hong Kong. But this time I got some new experience when I forgot my one bag in bus A41 which was from Airport to Shatin Central Bus Stop.

I was very tired due to connecting flight and I was carrying 3 bags with me and I took a bus A41 from Airport for Shatin Central Bus Station and when I reached Shatin Central station I just took my Laptop bag and main luggage bag and I forgot my 3rd bag in which some other important items were there.

After getting off I realized with 1 minute that I forgot my one bag in bus but in the mean time bus was already left.

I got little upset and thought that it is impossible to get that bag now but I hope that may be I get because this is Hong Kong.

Next day I just Googled about the A41 bus to get any contact information and I get the information that this bus belongs to Long Win Bus Limited company and the customer service number is 22612791.

Then I just contacted to the above number and gave the details to them that how it happened and about my bag that what color of bag and what was the contents of bag. After getting information from me the customer service person told me that they will contact me when they found the bag.

And simply next day I got the call from Long Win Bus company that they found my bag and told me to pick up from the Long Win Bus Terminus Airport and I got really happy and appreciated them for their good and reliable services.
shek o beach hong kong

Follow these just 5 simple steps to change an application title in Oracle Apex (Oracle Application Express).

1. In your application builder of Oracle Apex, click on the Edit Application Properties as shown below:

edit application property in Oracle Apex
2. Then click on User Interface Tab as shown below:

how to change application title in oracle apex

3. After that click on Logo Tab, then change the application name in Logo field, here you can specify an image also for the application title and then click on Apply Changes button to save the changes.

Change application title and logo in Oracle Apex


In this post you will learn to install Oracle Apex 5 on Oracle Database 12c pluggable database. Below is the step by step guide to install Oracle Application Express on Oracle 12c pluggable database.

1. Download the latest version of Oracle Apex 5 from the Oracle.com. You can download with the following link Oracle Application Express 5

2. After downloading extract the zip file into some location, for e.g. on windows D:\Software\Apex5

3. Then open the MS-DOS prompt and changed the directory to the extract location, eg.

CD D:\Software\Apex5\Apex

4. Then run the sqlplus as following:

sqlplus /nolog 

It is better to run sqlplus from the Oracle Database 12c Server location, you can copy the path from the shortcut available in Start Menu for Oracle Sql Plus.

5. Now logon using Sys account as following:

Conn
Enter User Name: sys as sysdba
Enter Password: yourpassword

6. After logon change the session to pluggable database with the following command. Change the YOURPDB12C with your pluggable database name:

ALTER SESSION SET CONTAINER = YOURPDB12C;
Note: If your pluggable database is down then run the Alter Database Open; command to start it.
You can remove if any prior Oracle Apex installation exists. To remove the apex run the following script.
@apxremov.sql
7. Now run the main script (apexins.sql) to install Oracle Apex, it will take some time.

@apexins.sql SYSAUX SYSAUX TEMP /i/

8. After completion the above script, create Apex Admin User and Password with the following script. It will ask you to enter admin username and password information:

@apxchpwd.sql

9. Configure Apex using apex_epg_config.sql by passing the path of your apex directory, where you extracted the zip file.

@apex_epg_config.sql D:\Software\Apex\Apex5.3

10. Unlock the Anonymous User.

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

11. Set the HTTP Port, you can specify any depend on your system.

EXEC DBMS_XDB.SETHTTPPORT(8181);

12. Grant Connect priviledges, run all below scripts.

BEGIN
DBMS_EPG.set_dad_attribute (
dad_name => 'APEX',
attr_name => 'cgi-environment-list',
attr_value => 'REQUEST_PROTOCOL=https');
DBMS_EPG.set_dad_attribute (
dad_name => 'APEX',
attr_name => 'cgi-environment-list',
attr_value => 'HTTP_HOST=external-name:external-port');
commit;
END;
/

DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
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_050000',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_050000', TRUE, 'connect');
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml',
'ACL that lets power users to connect to everywhere',
'APEX_050000', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('power_users.xml','*');
END;
/
COMMIT;

DECLARE
ACL_PATH VARCHAR2(4000);
BEGIN
-- Look for the ACL currently assigned to 'localhost' and give APEX_050000
-- the "connect" privilege if APEX_050000 does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = 'localhost' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'APEX_050000',
'connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,
'APEX_050000', TRUE, 'connect');
END IF;
EXCEPTION
-- When no ACL has been assigned to 'localhost'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('local-access-users.xml',
'ACL that lets users to connect to localhost',
'APEX_050000', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('local-access-users.xml','localhost');
END;
/
COMMIT;

BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => '*',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'apex_050000',
principal_type => xs_acl.ptype_db));
END;
/
BEGIN
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
host => 'localhost',
ace => xs$ace_type(privilege_list => xs$name_list('connect'),
principal_name => 'apex_050000',
principal_type => xs_acl.ptype_db));
END;
/

Now your installation of Oracle Apex is complete, you can now open the Apex administration page with the following URL:

http://localhost:8181/apex/apex_admin


Note: Any time if you got disconnected from database during installation, just connect it again using sys account and give the following command to continue with the installation:

ALTER SESSION SET CONTAINER = YOURPDB12C;

How to install oracle apex on oracle 12c database

In windows if you list directory and files with DIR command in MS Dos prompt then you will get the list of files and directory with long names including spaces and when you want to change the directory with CD command to get into that directory then you may can get error.

Below is the screen shot if you give DIR command:

get short directory and file names in ms dos for windows

To get the short names for files and directories in 8.3 name format in windows give Dir command with X parameter e.g. Dir /x as shown below:

file and directory name in 8.3 format in windows

Like for directory Program Files (x86) the short name is Progra~2.

Below are the steps to add signature in Gmail account with logo or image.

1. Open your Gmail account and click on Settings as shown in image:
2. Then in General tab of Settings page scroll down and type the name and other information in Signature box and click on the image icon to add logo or an image to your signature as shown below:

How to add signature in gmail account with logo

3. Then the Add an image window will open and there you can upload an image from your computer or from Google Drive (My Drive) or from website URL, as shown below:

Upload logo or image in signature of gmail account

Your signature is now added with logo.

While browsing internet sometimes we make mistakes by downloading some software or ebooks from wrong websites and we not get for what we are looking for but we get something else.

Like trustedsurf.com auto homepage, whenever you try to open Mozilla Firefox, Google Chrome or Internet Explorer browsers then you will not get your default home page but instead of that trustedsurf.com opens or fame or some other websites which you have not been set as homepage.

So to get rid of this trustedsurf problem, below is the simple solution for this. Please follow the following instructions:

1. First unpinned the shortcuts for Chrome, Firefox and Internet Explorer browsers on task bar if it is already there as shown in below image:


2. Then open the start menu and right click on the Chrome shortcut and click on the Properties, as shown below:


3. Then the shortcut window will appear and you will see the something as shown below:


4. Actually the string you are seeing above in Target field is this the full string:

"http://trustedsurf.com/?ssid=1462355886&a=1003679&src=sh&uuid=dad9e843-c3b9-42b7-8bde-76bdde470eee"

This is causing the Chrome, Firefox or Internet Explorer browser to redirect to the trustedsurf.com page and randomly opens other websites as well.

The solution for the trustedsurf problem is to remove this whole string from all the shortcuts of Internet Explorer, Firefox and Google Chrome browsers then it will never open the trustedsurf.com.

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.