Skip to main content

Click

DB Link to Oracle 11g:

Written by Paweł Barut

As you know in Oracle 11g passwords are case sensitive by default. This applies to connecting via SQL*Plus or other client tools. And it also applies to database links between databases. So when you link from Oracle 10g to Oracle 11g create database link like this:



CREATE DATABASE LINK my_link

CONNECT TO remote_user IDENTIFIED BY "CaSe_SeNsItIvE_PaSsWoRd"

USING 'TNS_ID_11G';



Do not forget to enclose password by double-quote marks!

When you do not set password this way, you will be getting:



ORA-01017: invalid username/password; logon denied.



Hope this small tip will be useful for someone.

Comments

Popular posts from this blog

How To Change the Apps Password

The passwords of APPS and APPLSYS must be identical. So you just need to change APPLSYS password not APPS , by changing APPLSYS password , APPS password assumes the same value (i) Shutdown the Applications Tier services on each of the Nodes Database Tier Services must be up and running Any node where APPL_TOP , 8.0.6 and iAS ORACLE_HOME are present is part of the Application tier Any node where RDBMS ORACLE_HOME is present is part of the Database tier (ii) Then . issue the commands at the Unix command line similar to the following on any Node of Oracle Applications where the executable FNDCPASS is present in $FND_TOP/bin To change the APPLSYS password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password SYSTEM APPLSYS new_password Ex: FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS CITRIX123 To change an Oracle user password: FNDCPASS apps/apps_schema_password 0 Y system/system_schema_password ORACLE apps_database_user new_password Example FNDCPASS app...

Oracle Fusion: Next-Generation Enterprise Applications

Oracle Fusion: Next-Generation Enterprise Applications Applications Unlimited is Oracle's commitment to continue providing enhancements to current JD Edwards EnterpriseOne, JD Edwards World, Oracle E-Business Suite, PeopleSoft, and Siebel product lines beyond the delivery of Oracle Fusion Applications. At the same time, with Oracle's extensive development resources, we are building Oracle Fusion Applications. These are being designed to unify best-of-business capabilities from all Oracle Applications in a complete suite delivered on Oracle's open technology. Only Oracle can offer you the scale of resources needed to extend the solutions you own today, while simultaneously evolving to the next generation of Oracle Fusion Applications. With Oracle's unique Applications Unlimited and Lifetime Support policy – customers will not be forced to upgrade to Fusion Applications, but can decide when and if they choose to upgrade. Application integration has never been easier. Le...

Canceling Requisition Lines Using a Spreadsheet

Please Click the Link below to access the document. Canceling Requisition Lines Using a Spreadsheet Cancel Requisition Lines Canceling Requisition Lines Using a Spreadsheet: Procedure As an authorized procurement user you can cancel requisition lines in batches using a spreadsheet. For example, you can review requisition lines that have been inactive for a long period of time. If they are overdue for cancellation, you can update their status to free up reserved funds. Follow these steps to cancel requisition lines using a spreadsheet: Select and download requisition lines to a spreadsheet. Review the lines in the spreadsheet and update their status to canceled. Upload the spreadsheet to update the application. Prerequisite Before you can cancel requisition lines using a spreadsheet, you must install the Oracle ADF Desktop Integration client software on your computer. The add-in enables desktop integration with Microsoft Excel workbooks. Downlo...