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

Post a Comment

Popular posts from this blog

Activate Jinitiator With Microsoft Windows 7 &Vista

Using Microsoft Windows 7 & Vista may introduce the problem of activating Jinitiator while running Oracle forms via oracle application server. The basic solution for this is listed as following. 1. Download latest Java JDK (such as jdk1.6.0) 2. Install JDK and copy the file X:\Program Files\Java\jre1.6.0_01\bin\client\jvm.dll to folder X:\Program Files\Oracle\JInitiator 1.3.1.21\bin\hotspot. To overwrite the existing jvm.dll. 3. Solve OS compatible issue under folder X:\Program Files\Oracle\JInitiator 1.3.1.21\lib change font.properties.zh.5 to font.properties.zh.6，and font.properties.zh.5.1 to font.properties.zh.6.1 4. Languages compatible issue (if you use multiple languages) in file X:\Program Files\Oracle\JInitiator 1.3.1.21\lib\font.properties, change filename.\u5b8b\u4f53=SIMSUN.TTF to filename.\u5b8b\u4f53=SIMSUN.TTC
3 comments
Read more

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...
Post a Comment
Read more

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...
2 comments
Read more