Connect to remote Oracle database server from RedHat Linux 7 using Oracle InstaClient

Hi friends,

I have come across a situation, where I need to connect to remote Oracle database server from RedHat Enterprise Linux (RHEL) 7. I found a way of using the Oracle InstaClient instead of installing the full Oracle DB which internally consists of Client.

Pre-requesites

1. Linux mahcine (I tried with RHEL 7) with following softwares
• Java (JAVA_HOME should be available)
• Development Tools (RHEL 7 tools like gcc etc.)
2. Another machine where Oracle server is installed with the following config
• Database schema should be available
• Users should be available instead of system/sysdba users
3. Both machines shall be reachable to each other via ping.

Note: You should know the database server SID/service name.

Procedure

Download

1. Download the insta client from Oracle Official Page
2. In my case, I have downloaded the "Instant Client for Linux x86-64"
3. Accept the license agreement
4. Click "oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm" to download
5. Optionally, you can download the "oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm" to have sqlplus command line utility for testing
6. Alternatively, you can download the zip files and download the same to install.
7. In my case, I am going with RPMs.

Install

• Install the downloaded RPMs
• #> yum install oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm
• #> yum install oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm
• While installing, it asks for locations, accept the defaults by pressing the "Enter" button

Note: If any dependencies are there, please install those.

Environment Variables

• Create a oracle_env.sh file and setup your variables
• #> gedit /etc/profile.d/oracle_env.sh

export ORACLE_HOME=/usr/lib/oracle//client/
export TNS_ADMIN=/usr/lib/oracle//client/
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

• Save your file
• Source your file with following command
• #> source /etc/profile.d/oracle_env.sh

tnsnames.ora

• Create tnsnames.ora file in your $ORACLE_HOME with following syntax

localsid = (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
    (CONNECT_DATA =
      (SID = )
    )
  )

• Instead of SID, you can use SERVICE_NAME also.

Connect

• You can test the connection
• #> sqlplus @

You should be able to connect to your remote database.

Hope, it is useful for you.

Please send your comments and feedback to psrdotcom@gmail.com

Tomcat issue "windows could not start apache tomcat on local computer" after java update issue with resolution

Hi friends,

Today I have faced an issue with Tomcat service starting. I would like to share with you the resolution as well. Please find the details below.

Root cause

Updated java version

Resolution

• Navigate to you apache installed folder
• Go bin folder
• Double click on "Tomcat(X)w.exe" where X the version of tomcat.
• In my case it is "Tomcat8w.exe" because the version is 8
• 
• Select "Use Default". So that, it uses the JAVA_HOME version by default.
• Click on OK
• Start the Tomcat service and enjoy deploying

Please send your comments and feedback to psrdotcom@gmail.com

Consolidate / Merge all your PF accounts

Hi friends,

Today, I have come across one useful website which consolidates all your PF accounts under one roof.

Pre-requisite

1. You should have one active and current PF account
2. You should have UAN created and activated
3. You should have your old PF account numbers

Important Information

If you have changed organization, then wait till the previous employer update your "Date of Exit (DoE)"
After that your current employer details should be available
To verify that, please login to your UAN services account
https://unifiedportal-mem.epfindia.gov.in/memberinterface/
Go to "View" -> "Service History"
You should be able to see your present and previous employers
Note: You wait for atleast 3 months, after you exit from your previous organization

Procedure

1. Visit http://oeoea.epfoservices.com/UANDEDUP/index.jsp site
2. Enter your registered mobile number
3. Enter your UAN number
4. Enter your current active PF account
5. Once you login, you should be able to view your all registered and linked PF accounts
6. Consolidate all PF accounts by selecting and further processing

Please send your comments and feedback to psrdotcom@gmail.com

Andhra Pradesh Public Service Commision (APPSC) Government Jobs Apllication Challan and Submit Application Online for various posts using APOnline Services

Dear friends,

Very useful information for those who wants to apply various posts in the Andhra Pradesh Public Service Commision (APPSC).

Procedure:

1. Visit the APPSC website http://apspsc.gov.in/
2. Browse the "Online Application Submission" section
3. For any post, you need to fill the challan by clicking "Get Challan"
4. Upon successfully filling the challan form, you will get the challan in PDF format.
5. According to instructions, either you need to visit near SBI branch or APOnline center.
6. But, you can pay the challan online using APOnline services.
7. Just click on the link http://aponline.gov.in/apportal/index.asp
8. Click on the "Citizen Login" on left side of the page
9. Register/Sign in with your details.
10. Click on "Adhoc Services"
11. In the section of "Challan payments", choose "APPSC Challan Payment"
12. Enter your challan number
13. Your details gets appeared; Your name and other details.
14. Click on "Submit"
15. Now it will ask you to pay using any one of the bankers (SBI, HDFC, AXIS, IndianBank)
16. After the payment, you will get the transaction acknowledgement along with your "Journal" number.
17. Make a note of "Journal Number"
18. The next day after 2:00 PM, visit APPSC website http://apspsc.gov.in/
19. Click on the "Submit Application"
20. Before you submitting the application, you need to have your scanned photograph and scanned signature.
21. The dimensions of the photograph should be 3.5cm(Width) x 4.5cm(Height) [Around 276px * 354px]
22. The dimensions of the signature should be 3.5cm(Width) x 1.5cm(Height) [Around 276px * 118px]
23. Using any of the photo editors you can combine both the photograph and signature into one .jpeg image with the dimensions 3.5cm(Width) x 6cm(Height) [276cm * 472px]
24. The image size must be less than 50KB
25. Upload the image by clicking on browse option
26. Click on "Preview" button
27. Verify the photograph and signature in the page
28. Click on "Submit" button
29. You can download the submitted application form

All the very best for you exam.

For any queries, mail to psrdotcom@gmail.com

Airtel service messages

Hi everyone,
Today I came with Airtel service messages, which can be used by post-paid customers.

1.      To start ebill SMS:             STOP PAPER  <(email id)> to 121
2.      To Update your email id SMS:            UPDATE EMAIL <(email id)> to 121
3.      View last 6 months ebills by simply sending SMS:
             EBILL <(email id)> <(first 3 letters of the month)> to 121
4.      To get your ebill password SMS:         EBILL PASSWORD to 121
5.      To stop ebill SMS:              STOP EBILL to 121

Hope it will be useful.

Vodafone Services Messages which saves lot of things for us

Hi everyone,

Please pay attention, if you have a vodafone post-paid connection.

Please do this things, once you get a new post-paid connection.

Send these below messages to 111 and save lot of things.

1. Get Bills to your e-mail address: ACT LIFEGREEN to 111 (Save Trees)
2. CAN VL to 111 (De-Activate data plan which is defaultly activated by vodafone, Save Money)
3. BILL to 111(Get the Un-Billed Amount, Save Calls)

Do update your account properly, fill the details and choose the corresponding services in vodafone.

Have you tried these Google Labs features? I liked these features.

Hi everyone,
I tried these Google labs features and its very useful for every e-mail user. Hope you will also like it.

There are features which will

1. Insert images in mail
2. Cancel the mail within 30 seconds, if you forgot attachment, signature, address, etc.
3. Nested folders
4. Choosing the correct name suggestion.
5. Displaying the unread messages count in the title of the page. 

If you want to use or like anyone of the above you can continue reading the blog.

• To see the Google labs, click on Settings, select Labs tab.
• Select the Enable option button for the concerned lab feature.
• Click on Save Changes at top or bottom of the page, to use these features.

Google Labs Features: 

1) Inserting Images:
    This feature provides you to select the pictures from the harddisk or from URL and display in the mail instead of attachment. Lot of my friends asked how to display an image in the mail. By using this feature you can do that.
2) Nested Labels
    Instead of having long list of labels for every simple things, you can group them and make nested labels.
3) Title Tweaks
    It will display the current label with unread message count. If you get any new mail, just by seeing the title in the taskbar, you can identify that you got an e-mail.

4) Got the Wrong Bob?
    This feature will you recommend the user with the similar name. When you are selecting some name, it will list the similar names to choose the correct one. 

5) Undo Send
    Sometimes we will be thinking something and click on send button. After just clicking, we will be thinking like, I shouldn't have click on send button. By using "Undo Send" feature, within 30 seconds we can cancel the sending mail. After finishing everything in the mail, you can send again.
Example: We want to send resume to someone, We will be concentrating on writing some good content and once we are happy with content, we will just press send button without attaching the resume. Just after clicking on send we will identify that, we forgot the attachment. At that point, we can cancel the sending mail and attach the resume and send. I think it happened with lot of you people. It happened with me too.

--------------------------------------
Please send your feedback and comments
PSR.COM