We often get “Network Error: Software Caused Connection Abort” when the connection is idle for some time to the server. This happens because some network firewall terminate the connection if no data is send through the network through either direction after some time This issue can be very irritating as you have to login to […]
How to convert private key to ppk
Many times , you get the private key from the cloud provider to connect to the Virtual machine. If you directly try to use that key with Putty to connect to VM machine , you will get failure. we need to convert the private key into ppk format which is supported by Putty Tool. Here […]
how to import schema in oracle using impdp
we often have a situation where we need to move the schema from Prod to DEV or from test to another. We will discuss how to import schemas in Oracle database using impdp in these situation How to import schema in Oracle 1. First of all we should take the dump of the schema or […]
how to check PSU patch version in oracle
What is a PSU patch for Oracle Home? Patch Set Updates (PSU) are the same cumulative patches that include both the security fixes and priority fixes. The key with PSUs is they are minor version upgrades (e.g., 11.2.0.1.1 to 11.2.0.1.2). Once a PSU is applied, only PSUs can be applied in future quarters until the […]
How to migrate the schema from one database to another database using exp/imp
Here ,I will give u Detailed steps for Schema Migration using exp/imp,pipe,gz between two databases How to migrate the schema from one database to another database The below steps need to be done on the Source Database Metadata about schema SQL> select owner,sum(bytes)/1024/1024 from dba_segments where owner in (‘EXAMPLE_SCH’) group by owner; SQL> select tablespace_name,sum(bytes)/1024/1024 […]
Multi Language Support in 11i/R12
Introduction to NLS/MLS NLS : National language support. Being able to run an application in 1 language. This language can be any supported language.It basically means the ability to run an Applications instance in any one of the supported languages (other than American English), including certain region/territory specific numeric and date formats. Only the customer-facing […]
