When you see the above error , first thing come
into mind is
Is our tnsnames.ora file
is exist , if its there used connection string is
there
If you have it correctly and still
issue is persist .. Then whats happens everything is
good
1.First thing you have to check if
tnsnames is fine
sqlldr
scott/HD@y45Hhds@orcl control=E:\test\table.ctl
log=E:\test\table.log
Check if
you have password having '@' symbol
2.Then change it as below , you will be able to
load the millions of files into oracle
table
sqlldr scott/\"HD@y45Hhds\"@orcl
control=E:\test\table.ctl
log=E:\test\table.log
Make it useful
..
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!
In this Percona Live featured session, we’ll meet Luís Soares, Principal Software Engineer at Oracle. His session is The New MySQL Replication Features in MySQL 8 (with fellow presenter Lars Thalmann, Development Director at Oracle). The most popular high availability …
[Read more]This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.
Oracle:
Provisioning EBS on Oracle Cloud: Latest Enhancements
ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2
Business rules, common sense and query performance
Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed
Updated …
[Read more]MySQL Enterprise Backup Team is pleased to announce major improvements in incremental backup performance starting with release 4.1.
Introduction
The current incremental backup algorithm scans all the tables to gather changed pages even if very few tables are modified since the previous backup and thus results in a 'full-scan' incremental backup. This may result in increment backups requiring the same amount of time as full backup because it scans all the tables. The new algorithm aims to eliminate this extra time.
The new algorithm scans only those tables that have been modified since the previous backup. This algorithm relies on modification time, which is similar to an earlier improvement made for full backup. That full backup algorithm is known as optimistic full backup, hence new improvement is named …
[Read more]This Log Buffer Edition searches through various blogs of Oracle, SQL Server and MySQL and picks a few contemporary ones.
Oracle:
Comma separated search and search with check-boxes in Oracle APEX
Once you have defined your users for your Express Cloud Service, all users with the role of Database Developer or higher can access the database Service Console.
Big Data Lite 4.7.0 is now available on OTN!
Install and configure Oracle HTTP Server Standalone
Can I …
[Read more]This blog post is my overview of Group Replication technology.
With Oracle clearly entering the “open source high availability solutions” arena with the release of their brand new Group Replication solution, I believe it is time to review the quality of the first GA (production ready) release.
TL;DR: Having examined the technology, it is my conclusion that Oracle seems to have released the GA version of Group Replication too early. While the product is definitely “working prototype” quality, the release seems rushed and unfinished. I found a significant number of issues, and I would personally not recommend it for production use.
It is obvious that Oracle is trying hard to ship technology to compete with …
[Read more]This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.
Oracle:
Data Pump or Data Pain Part02 – tablespace/user
Monday Spotlight: It’s About Security – Oracle Exadata SL6
0001_specify_date_format_mask.md copy
OGG Custom Adapters: How to include a unique identifier for …
[Read more]Introduction While doing my High-Performance Java Persistence training, I came to realize that it’s worth explaining how a relational database works, as otherwise, it is very difficult to grasp many transaction-related concepts like atomicity, durability, and checkpoints. In this post, I’m going to give a high-level explanation of how a relational database works internally while … Continue reading How does a relational database work →
In my previous post, we saw the usage of MySQL Group Replication (MGR) in single-primary mode. We know that Oracle does not recommends using MGR in multi-primary mode, but there is so much in the documentation and in presentations about MGR behavior in multi-primary, that I feel I should really give it a try, and especially compare this technology with the already existing multiple master solution introduced in 5.7: multi-source replication.
Installation
To this extent, I will set up two clusters using MySQL-Sandbox. The instructions for MGR in …
[Read more]Welcome to another post in the series of Percona Live featured tutorial speakers blogs! In these blogs, we’ll highlight some of the tutorial speakers that will be at this year’s Percona Live conference. We’ll also discuss how these tutorials can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!
In this Percona Live featured tutorial, we’ll meet Øystein Grøvlen, Senior Principal Software Engineer at Oracle. His tutorial is on How to Analyze and Tune MySQL Queries for Better Performance. SQL query …
[Read more]