tag:blogger.com,1999:blog-68835105426583992692024-03-05T12:59:22.870-08:00Virtual Database SupportAnonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.comBlogger73125tag:blogger.com,1999:blog-6883510542658399269.post-22434149933686768362017-07-06T01:38:00.000-07:002017-07-06T01:38:01.587-07:00Setting server system variable 'old_alter_table' back to '0'.<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><b>Error :</b>-- MySQL Enterprise Backup version 4.1.0 Linux-2.6.39-400.215.10.el5uek-x86_64 [2017/03/01] Copyright (c) 2003, 2017, Oracle and/or its affiliates. All Rights Reserved.</span><br />
<div class="MsoPlainText">
<span style="color: purple;"><o:p></o:p></span></div>
<div class="MsoPlainText">
<br /></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:00:01 MAIN INFO: A thread created with Id '140533386585920'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:00:01 MAIN INFO: Starting with following command line ...<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">/arch03/MySQL_Backup/meb-4.1.0-linux-glibc2.5-x86-64bit/bin/mysqlbackup<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;"> -u root -pxxxxxxx --no-locking<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;"> --backup-dir=/backup/backup_full_3302/03hr_05_July_2017<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;"> backup-and-apply-log<o:p></o:p></span></div>
<div class="MsoPlainText">
<br /></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:00:01 MAIN INFO:<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:00:01 MAIN INFO: MySQL server version is '5.7.16-enterprise-commercial-advanced-log'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:00:01 MAIN INFO: MySQL server compile os version is 'linux-glibc2.5'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;"><o:p></o:p></span></div>
<span style="color: purple;">170705 03:00:01 MAIN INFO: Got some server configuration information from running server.</span><br />
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:19 RDR1 INFO: Copying the database directory 'mysql'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:19 RDR1 INFO: Copying the database directory 'performance_schema'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:19 RDR1 INFO: Copying the database directory 'routeFinderBuildCircuitTable'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:19 RDR1 INFO: Copying the database directory 'routeFinderRouteValidation'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:19 RDR1 INFO: Copying the database directory 'routeFinderStatusReports'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:20 RDR1 Progress in MB: 46400 46600 46800 47000<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:21 RDR1 INFO: Copying the database directory 'routeFinderTables'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:22 RDR1 Progress in MB: 47200 47400 47600 47800 48000 48200 48400 48600 48800 49000 49200 49400 49600 49800 50000 50200 50400 50600 50800 51000 51200 51400 51600 51800 52000 52200 52400 52600 52800<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:38 WTR1 ERROR: Disk full while writing '/backup/backup_full_3302/03hr_05_July_2017/datadir/routeFinderTables/DvGtestT_C.MYI'<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:38 WTR1 INFO: Requesting completion of redo log copy. Rapid: 1<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:38 RLR1 INFO: Signaled '1' to complete log copy.<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:38 RLR1 INFO: Signaled '1' to complete log copy.<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;">170705 03:06:38 RLR1 INFO: Redo log reader waited = 395270.00 ms for logs to generate.<o:p></o:p></span></div>
<div class="MsoPlainText">
<br /></div>
<div class="MsoPlainText">
<span style="color: purple;">mysqlbackup failed with errors!<o:p></o:p></span></div>
<div class="MsoPlainText">
<span style="color: purple;"><o:p></o:p></span></div>
<span style="color: purple;">170705 03:06:38 MAIN INFO: Setting server system variable 'old_alter_table' back to '0'. </span><br />
<span style="color: purple;"><br /></span><span style="color: purple;"><br /></span><span style="color: purple;"><br /></span><span style="color: purple;"><b>Issue :-- 170705 03:06:38 WTR1 ERROR: Disk full while writing </b>'/backup/backup_full_3302/03hr_05_July_2017/datadir/routeFinderTables/DvGrptestT_C.MYI'</span><br />
<span style="color: purple;"><br /></span><span style="color: purple;">Setting server system variable 'old_alter_table' back to '0'.</span><br />
<span style="color: purple;"><br /></span><span style="color: purple;"><b>Solution :-- </b> Check server disk space where backup files generated & remove old files & start backup again </span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com13tag:blogger.com,1999:blog-6883510542658399269.post-3937937658897761862017-03-01T02:41:00.001-08:002017-07-05T04:42:44.796-07:00ALTERNATE archival destination in Oracle <div dir="ltr" style="text-align: left;" trbidi="on">
<h2>
<span lang="EN" style="font-family: "tahoma" , sans-serif;">Understanding Archive
Destination Status<o:p></o:p></span></h2>
<a href="https://www.blogger.com/null" id="sthref1451" name="sthref1451"></a><a href="https://www.blogger.com/null" id="sthref1452" name="sthref1452"></a><span lang="EN" style="font-family: "tahoma" , sans-serif;">Each archive destination has the following variable characteristics that
determine its status:<o:p></o:p></span><br />
<div style="margin-left: .5in; mso-list: l1 level1 lfo1; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span class="bold1"><span lang="EN" style="font-family: "tahoma" , sans-serif;">Valid/Invalid</span></span><span lang="EN" style="font-family: "tahoma" , sans-serif;">: indicates whether the disk location or service name information is
specified and valid<o:p></o:p></span></div>
<div style="margin-left: .5in; mso-list: l1 level1 lfo1; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span class="bold1"><span lang="EN" style="font-family: "tahoma" , sans-serif;">Enabled/Disabled</span></span><span lang="EN" style="font-family: "tahoma" , sans-serif;">: indicates the availability state of the location and whether the database
can use the destination<o:p></o:p></span></div>
<div style="margin-left: .5in; mso-list: l1 level1 lfo1; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span class="bold1"><span lang="EN" style="font-family: "tahoma" , sans-serif;">Active/Inactive</span></span><span lang="EN" style="font-family: "tahoma" , sans-serif;">: indicates whether there was a problem accessing the destination<o:p></o:p></span></div>
<span lang="EN" style="font-family: "tahoma" , sans-serif;">Several combinations of these characteristics are
possible. To obtain the current status and other information about each
destination for an instance, query the </span><a href="https://www.blogger.com/null" id="sthref1453" name="sthref1453"></a><a href="https://www.blogger.com/null" id="sthref1454" name="sthref1454"></a><code><span lang="EN" style="font-size: 13pt;">V$ARCHIVE_DEST</span></code><span lang="EN" style="font-family: "tahoma" , sans-serif;">
view.<o:p></o:p></span><br />
<a href="https://www.blogger.com/null" id="sthref1455" name="sthref1455"></a><a href="https://www.blogger.com/null" id="sthref1456" name="sthref1456"></a><span lang="EN" style="font-family: "tahoma" , sans-serif;">The </span><a href="https://www.blogger.com/null" id="sthref1457" name="sthref1457"></a><a href="https://www.blogger.com/null" id="sthref1458" name="sthref1458"></a><code><span lang="EN" style="font-size: 13pt;">LOG_ARCHIVE_DEST_STATE_</span></code><span class="codeinlineitalic1"><span lang="EN" style="font-family: "courier new"; font-size: 13pt;">n</span></span><span lang="EN" style="font-family: "tahoma" , sans-serif;">
(where <span class="italic1">n</span> is an integer from 1 to 31) initialization
parameter lets you control the availability state of the specified destination
(<span class="italic1">n</span>).<o:p></o:p></span><br />
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><code><span lang="EN" style="font-size: 13pt;">ENABLE</span></code><span lang="EN" style="font-family: "tahoma" , sans-serif;">
indicates that the database can use the destination.<o:p></o:p></span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><code><span lang="EN" style="font-size: 13pt;">DEFER</span></code><span lang="EN" style="font-family: "tahoma" , sans-serif;">
indicates that the location is temporarily disabled.<o:p></o:p></span></div>
<div style="margin-left: .5in; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in;">
<!--[if !supportLists]--><span lang="EN" style="background: yellow; font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><code><span lang="EN" style="background: yellow; font-size: 13pt;">ALTERNATE</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;"> indicates that the destination is
an alternate. The availability state of an alternate destination is </span><code><span lang="EN" style="background: yellow; font-size: 13pt;">DEFER</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;">. If its parent destination fails, the availability state
of the alternate becomes </span><code><span lang="EN" style="background: yellow; font-size: 13pt;">ENABLE</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;">. </span><code><span lang="EN" style="background: yellow; font-size: 13pt;">ALTERNATE</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;"> cannot be specified for destinations </span><code><span lang="EN" style="background: yellow; font-size: 13pt;">LOG_ARCHIVE_DEST_11</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;"> to </span><code><span lang="EN" style="background: yellow; font-size: 13pt;">LOG_ARCHIVE_DEST_31</span></code><span lang="EN" style="background: yellow; font-family: "tahoma" , sans-serif;">.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span lang="EN" style="font-family: "tahoma" , sans-serif; font-size: 15.5pt;">Specifying Alternate Destinations<o:p></o:p></span></b></div>
<div class="MsoNormal">
<a href="https://www.blogger.com/null" name="sthref1459"></a><a href="https://www.blogger.com/null" name="sthref1460"></a><span lang="EN" style="font-family: "tahoma" , sans-serif; font-size: 12pt;">If you want
to specify that a location be an archive destination only in the event of a
failure of another destination, you can make it an alternate destination. Both
local and remote destinations can be alternates. The following example makes </span><span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_4</span><span lang="EN" style="font-family: "tahoma" , sans-serif; font-size: 12pt;"> an
alternate for </span><span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_3</span><span lang="EN" style="font-family: "tahoma" , sans-serif; font-size: 12pt;">:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;"><br /></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">ALTER SYSTEM SET LOG_ARCHIVE_DEST_4 =
'LOCATION=/disk4/arch';<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">ALTER SYSTEM SET LOG_ARCHIVE_DEST_3 =
'LOCATION=/disk3/arch <o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;"> ALTERNATE=LOG_ARCHIVE_DEST_4';<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">ALTER SYSTEM SET
LOG_ARCHIVE_DEST_STATE_4=ALTERNATE;<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;"><br /></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">SQL> SELECT dest_name, status, destination
FROM v$archive_dest;<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">DEST_NAME
STATUS DESTINATION<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">----------------------- --------- ----------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_1
VALID /disk1/arch<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_2
VALID +RECOVERY<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_3
VALID /disk3/arch<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<span lang="EN" style="font-family: "courier new"; font-size: 13pt;">LOG_ARCHIVE_DEST_4
ALTERNATE /disk4/arch<o:p></o:p></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.comtag:blogger.com,1999:blog-6883510542658399269.post-49098904820093682002017-03-01T01:01:00.003-08:002017-07-05T04:42:30.240-07:00doubt transactions in oracle<div dir="ltr" style="text-align: left;" trbidi="on">
Query to check in doubt transactions...<br />
=====================================<br />
<br />
SQL> SELECT LOCAL_TRAN_ID, GLOBAL_TRAN_ID,to_char(FAIL_TIME,'dd-mon-yyyy HH24:MI:SS'), STATE, MIXED FROM DBA_2PC_PENDING;<br />
<br />
LOCAL_TRAN_ID GLOBAL_TRAN_ID TO_CHAR(FAIL_TIME,'DD-MON-YYY STATE MIX<br />
---------------------- ---------------------------------------- ----------------------------- ---------------- ---<br />
88.33.88299 abc.a930e3e9.36.36.71299 24-jan-2017 07:56:31 collecting no<br />
44.77.88441 abc.a930e3e9.33.40.68441 24-jan-2017 09:27:49 collecting no<br />
99.99.99919 abc.a930e3e9.27.44.59919 24-jan-2017 15:39:21 collecting no<br />
<br />
SQL> SELECT LOCAL_TRAN_ID, IN_OUT,INTERFACE, DATABASE FROM DBA_2PC_NEIGHBORS;<br />
<br />
LOCAL_TRAN_ID IN_ I DATABASE<br />
---------------------- --- - ------------------------------<br />
01.01.11299 in N<br />
33.44.55441 in N<br />
22.44.55919 in N<br />
88.33.88299 out N REM2CRM_HZ_PARTIES_DBLINK<br />
44.77.88441 out N REM2CRM_HZ_PARTIES_DBLINK<br />
99.99.99919 out N REM2CRM_HZ_PARTIES_DBLINK<br />
<br />
6 rows selected.<br />
<br />
SQL><br />
<br />
To clear the in doubt transactions...<br />
=====================================<br />
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('88.33.88299');<br />
COMMIT;<br />
<br />
execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('44.77.88441');<br />
COMMIT;<br />
<div>
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com3tag:blogger.com,1999:blog-6883510542658399269.post-66954799612391078892017-02-28T23:18:00.000-08:002017-02-28T23:18:01.052-08:00Oracle External Table Error ORA-12801 ORA-29913<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><u><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">Error: <o:p></o:p></span></u></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">SQL> select * from abc.EXT_TAB_BILLRUN;<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">select * from abc.EXT_TAB_BILLRUN<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">*<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">ERROR at line 1:<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">ORA-12801: error signaled in parallel query server P000<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">ORA-29913: error in executing ODCIEXTTABLEFETCH callout<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><u><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">Cause:<o:p></o:p></span></u></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">External Table loading rejecting the Bad records & were unable to
append errors in bad log file due to permission issue<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">select dbms_metadata.get_ddl('TABLE','EXT_TAB_BILLRUN','abc')
from dual;<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">.<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> DEFAULT DIRECTORY "EXT_TABLES_DIR"<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> ACCESS PARAMETERS<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> ( RECORDS DELIMITED BY NEWLINE<o:p></o:p></span></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> BADFILE 'bad_ext_tab_billrun'<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> LOGFILE 'log_ext_tab_billrun'<o:p></o:p></span></b></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> FIELDS TERMINATED BY '^'<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">[oracle9i@:/home/oracle9i>]tail -f
log_ext_tab_billrun.log<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> Trim whitespace same as SQL Loader<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">
BILLING_METHOD
CHAR (255)<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> Terminated by "^"<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> Enclosed by """ and
"""<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> Trim whitespace same as SQL Loader<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">KUP-04021: field formatting error for field SERVICE_ADDRESS<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">KUP-04036: second enclosing delimiter not found<o:p></o:p></span></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">KUP-04101: record 3 rejected in file
/index01/collab/EXT_TAB_BILLRUN_DIR/RevenueRegister.csv<o:p></o:p></span></b></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">KUP-04001: error opening file
/index01/collab/EXT_TAB_BILLRUN_DIR/bad_ext_tab_billrun.bad<o:p></o:p></span></b></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">KUP-04017: OS message: Permission denied<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">-rwxr-xr-x 1 collab
oinstall 627 Sep 20 00:33
bad_ext_tab_billrun.bad<o:p></o:p></span></b></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">[oracle9i@:/home/oracle9i>]pwd<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">/index01/collab/EXT_TAB_BILLRUN_DIR<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><u><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">Solution:<o:p></o:p></span></u></b></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">Collab: oinstall</span></b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;"> changed to<b> oracle9i:oinstall<o:p></o:p></b></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">oracle9i@#sudo chown -R oracle9i:oinstall
bad_ext_tab_billrun.bad<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">oracle9i@#ls -lrt bad*<o:p></o:p></span></div>
<div class="MsoNormal">
<span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">-rwxr-xr-x 1 collab
oinstall 120 Aug 30 11:12
bad_tariff_input.bad<o:p></o:p></span></div>
<div class="MsoNormal">
<b><span lang="EN-IN" style="color: #002060; mso-ansi-language: EN-IN;">-rwxr-xr-x 1 oracle9i
oinstall 627 Sep 20 00:33
bad_ext_tab_billrun.bad<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">
1* select * from abc.EXT_TAB_BILLRUN<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">SQL>
/<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">SERVICE<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">--------------------------------------------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">CUSTOMER_REF_NUM<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #1f497d; mso-fareast-language: EN-IN;">-------------------------------<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.comtag:blogger.com,1999:blog-6883510542658399269.post-76184252626207929382016-10-04T04:18:00.000-07:002016-10-04T04:18:06.401-07:00ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<b><span style="color: #002060; font-size: 12.0pt;">Issue:-<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">ERROR 2049
(HY000): Connection using old (pre-4.1.1) authentication protocol ref used
(client option 'secure_auth' enabled)..<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<b><span style="color: #002060; font-size: 12.0pt;">Solution:-<o:p></o:p></span></b></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">On the command
line, use below ....<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">mysql
-uUSERNAME -pPASSWD DbName -h HostName --skip-secure-auth<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">OR<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">Login to mysql
DB with root user.<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">show variables
like 'old_passwords';<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">+-----------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">|
Variable_name | Value |<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">+-----------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">|
old_passwords | ON |<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">|-----------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">old_passwords is
ON is clearly the problem, <o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">So temporarily
changed it:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">set session
old_passwords = 'OFF';<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">show variables
like 'old_passwords';<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">+-----------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">|
Variable_name | Value |<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">+-----------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">|
old_passwords | OFF |<o:p></o:p></span></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">------------------+-------+<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">Created a new
user:<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">create user
'username' IDENTIFIED BY 'passwd';<o:p></o:p></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #002060; font-size: 12.0pt;">than try to
connect DB.<o:p></o:p></span></div>
<br />
<div class="MsoNormal">
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com7tag:blogger.com,1999:blog-6883510542658399269.post-80728622654225031122016-10-04T03:46:00.000-07:002017-07-05T06:56:04.160-07:00 mysqlbackup: WARNING: binlog file 'mysql-bin.000161' does not exist. It could have been purged. PITR will not be possible from this backup.<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"><b>Issue:-</b><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> Tape mysqlbackup failed because of below
WARNING msg. <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> mysqlbackup: WARNING: binlog file
'mysql-bin.000161' does not exist. It could have been purged. PITR will not be
possible from this backup.<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"><b> Solution:-</b><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> login to mysqlDB & check master status.<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <b> show master status;</b><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> if you see multiple Executed_Gtid_Set <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"><b> reset master;</b><o:p></o:p></span></span></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"><b> show master status;</b><o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> this time get single Executed_Gtid_Set<o:p></o:p></span></span></div>
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> <o:p></o:p></span></span></div>
<br />
<div class="MsoNormal">
<span style="font-size: 12pt;"><span style="color: purple;"> re-run Tape mysqlbackup & check error log.</span><span style="color: #002060;"><o:p></o:p></span></span></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.comtag:blogger.com,1999:blog-6883510542658399269.post-19874275411280282752016-04-21T00:40:00.001-07:002016-04-21T00:40:46.775-07:00send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">Issue :--</span><br />
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">send-mail: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol</span><br />
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">send-mail: warning: inet_protocols: configuring for IPv4 support only</span><br />
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">postdrop: warning: inet_protocols: IPv6 support is disabled: Address family not supported by protocol</span><br />
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">postdrop: warning: inet_protocols: configuring for IPv4 support only</span><br />
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">Solution :--</span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">Check below :- inet_protocols in /etc/postfix/main.cf file </span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"> more /etc/postfix/main.cf | grep inet_protocols</span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">inet_protocols = all</span></div>
</div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">To disable the messsage, go to /etc/postfix/main.cf and change from:</span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>inet_protocols = all</b></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">TO</span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>inet_protocols = ipv4</b></span></div>
</div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div>
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b># /etc/init.d/postfix restart</b></span></div>
<div>
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.comtag:blogger.com,1999:blog-6883510542658399269.post-58694742289269651242015-10-19T03:13:00.000-07:002015-10-19T03:13:35.198-07:001129 error connecting to master <div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">mysql> show slave status \G;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">*************************** 1. row ***************************</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Slave_IO_State: Connecting to master</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Host: 000.000.000.100</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_User: rep_user</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Port: 3300</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Connect_Retry: 60</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Log_File: mysql-bin.017008</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Read_Master_Log_Pos: 6004</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Relay_Log_File: relay-bin.000001</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Relay_Log_Pos: 4</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Relay_Master_Log_File: mysql-bin.017008</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Slave_IO_Running: Connecting</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Slave_SQL_Running: Yes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_SSL_Key:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Seconds_Behind_Master: NULL</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Master_SSL_Verify_Server_Cert: No</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Last_IO_Errno: 1129</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Last_IO_Error: error connecting to master 'rep_user@000.000.000.100:3300' - retry-time: 60 retries: 1074</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Last_SQL_Errno: 0</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Last_SQL_Error:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Replicate_Ignore_Server_Ids:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Server_Id: 0</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_UUID: de4-1fa393-90303b</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Info_File: /test01/master.info</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> SQL_Delay: 0</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> SQL_Remaining_Delay: NULL</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Retry_Count: 86400</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> Master_Bind:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">[testserver]$ telnet 000.000.000.100 3300 </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Trying 000.000.000.100... </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Connected to 000.000.000.100. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Escape character is '^]'. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">mHost '000.000.000.100' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>solution :--</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">>'</span><span style="color: purple; font-family: 'Courier New', Courier, monospace;">000.000.000.100</span><span style="color: purple; font-family: Courier New, Courier, monospace;">' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'Connection closed by foreign host. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">After more than max_connect_errors unsuccessful tries, the ip will be blocked by the master's instance. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">To solve this problem you could execute 'mysqladmin flush-host' to unblock all blocked ip or </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">execute FLUSH HOSTS on the master. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">The link below explains the issue in detail. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">https://dev.mysql.com/doc/refman/5.6/en/blocked-host.html </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Master server :-</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>mysqladmin -u username -ppasswd flush-hosts</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Slave server:-</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>stop slave;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>start slave;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>show slave status \G;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Once the blocked host is flush the slave should be able to connect to the master. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Try stopping the slave and starting the slave again after executing the FLUSH HOSTS </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">For more information on FLUSH HOST please refer the link below. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">https://dev.mysql.com/doc/refman/5.6/en/flush.html </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">To start or stop the slave you can use the START/STOP SLAVE command. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">https://dev.mysql.com/doc/refman/5.6/en/start-slave.html </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">https://dev.mysql.com/doc/refman/5.6/en/stop-slave.html </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Thank you.</span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-53148751039216440722015-04-23T02:31:00.000-07:002015-04-23T02:31:42.892-07:00ORA-00265: instance recovery required, cannot set ARCHIVELOG mode<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple; font-family: Courier New, Courier, monospace;">Today, I face below error while converting database into archive log mode. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORA-00265: instance recovery required, cannot set ARCHIVELOG mode</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">This error usually come when database crashed unfortunately or we shutdown database with the help of database shutdown command as: </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">shutdown abort, startup force mount or shutdown abort. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">These types of command will required instance recovery in next startup. </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">In short it need clean database startup.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">shutdown abort</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database closed.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database dismounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance shut down.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">startup mount</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance started.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Total System Global Area 1.0693E+10 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Fixed Size 2157504 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Variable Size 5972694080 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database Buffers 4664066048 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Redo Buffers 53747712 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database mounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">alter database archivelog;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">alter database archivelog</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">*</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ERROR at line 1:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORA-00265: instance recovery required, cannot set ARCHIVELOG mode</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>// Solution:--</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">shut immediate</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORA-01109: database not open</span><br />
<span style="color: purple; font-family: 'Courier New', Courier, monospace;">Database dismounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance shut down.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">startup mount;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance started.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Total System Global Area 1.0693E+10 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Fixed Size 2157504 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Variable Size 7113544768 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database Buffers 3523215360 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Redo Buffers 53747712 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database mounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>recover database;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Media recovery complete.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">alter database open;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database altered.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">shut immediate</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database closed.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database dismounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance shut down.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> startup mount</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ORACLE instance started.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Total System Global Area 1.0693E+10 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Fixed Size 2157504 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Variable Size 7147099200 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database Buffers 3489660928 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Redo Buffers 53747712 bytes</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database mounted.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> <b>alter database archivelog;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Database altered.</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>SQL> alter database open;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Database altered.</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>SQL> alter system switch logfile;</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>System altered.</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> alter system switch logfile;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">System altered.</span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-2980462400232120112015-03-13T05:47:00.000-07:002015-03-13T05:47:08.092-07:00MySQL Documentation: MySQL Reference Manuals<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><br /></span>
<span style="color: purple;">MySQL Documentation: MySQL Reference Manuals :-</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Please use below link for MySQL details.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>http://dev.mysql.com/doc/ </b></span><br />
<span style="color: purple;"><br /></span>
<br /></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-36166724930331348282015-03-02T06:45:00.000-08:002015-03-02T06:45:19.051-08:00ORA-27054: NFS file system where the file is created or resides is not mounted with correct options<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: purple;">I have been getting </span><br />
<span style="color: purple;">ORA-27054: NFS file system not mounted with correct options error when running an EXPDP backup to a NFS mount point. </span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">The system administrator has not been successful in identifying the cause as it shows that the correct mount point options are being used.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Error :--</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">ORA-39000: bad dump file specification</span><br />
<span style="color: purple;">ORA-31641: unable to create dump file "/expdir/expdp_backup/possit_fulldb_02032015.dmp"</span><br />
<span style="color: purple;"><b>ORA-27054: NFS file system where the file is created or resides is not mounted with correct options</b></span><br />
<span style="color: purple;"><b>Additional information: 6</b></span><br />
<span style="color: purple;"><br /></span>
<a href="https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=keye3gbc3_9&_afrLoop=813873391417584" style="-webkit-transition: all 0.1s ease-in-out; background: rgb(255, 255, 255); border-bottom-color: rgb(236, 28, 36); border-bottom-style: dotted; border-bottom-width: 1px; box-sizing: border-box; color: #ec1c24; font-family: Lato, sans-serif; font-size: 20px; line-height: 32.5px; text-decoration: none; transition: all 0.1s ease-in-out;" title="Doc ID 1518979.1">Metalink Doc ID 1518979.1</a><span style="color: purple;"> sets the event 10298, by-passing this check and allows writing to the mount point.</span><br />
<span style="color: purple;"><br /></span>
<b><span style="color: purple;">sqlplus / as sysdba</span></b><br />
<b><span style="color: purple;"><br /></span></b>
<b><span style="color: purple;">alter system set events '10298 trace name context forever, level 32';</span></b><br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-45438212587317765112015-02-18T00:35:00.002-08:002015-02-18T00:35:29.175-08:00parameter _TRACE_FILES_PUBLIC in Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><br /></span>
<span style="color: purple;">Generally all trace files have read and write permission for Oracle software owner and group of Oracle installation has permission of read only. Other users don’t have privilege of read.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">$cd /oradump/diag/rdbms/ABCPROD1/trace</span><br />
<span style="color: purple;">$ls -lrt</span><br />
<span style="color: purple;">-rw-r----- 1 ora11g dba 156 Feb 18 13:35 ABCPROD1_lmhb_37332.trm</span><br />
<span style="color: purple;">-rw-r----- 1 ora11g dba 1892 Feb 18 13:35 ABCPROD1_lmhb_37332.trc</span><br />
<span style="color: purple;">-rw-r----- 1 ora11g dba 72499 Feb 18 13:39 ABCPROD1_lms0_37322.trm</span><br />
<span style="color: purple;">-rw-r----- 1 ora11g dba 448097 Feb 18 13:39 ABCPROD1_lms0_37322.trc</span><br />
<span style="color: purple;">-rw-r----- 1 ora11g dba 71272 Feb 18 13:40 ABCPROD1_mmon_37350.trm</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Because trace files may have some important information about database security or may have some sensitive details of data. </span><br />
<span style="color: purple;">Oracle applies this permission using hidden parameter called _TRACE_FILES_PUBLIC. </span><br />
<span style="color: purple;">Default value of _TRACE_FILES_PUBLIC is FALSE. Due to this parameter trace files don’t have read permission to other users or public. It is not recommended to change value of this parameter because it is security risk. But in some scenario it has needed to change permission to make it readable trace files to other users or PUBLIC.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">We can change this parameter using parameter file or spfile and make it TRUE.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>select value from v$parameter where name = '_trace_files_public';</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>VALUE</b></span><br />
<span style="color: purple;"><b>----------</b></span><br />
<span style="color: purple;"><b>FALSE</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">For modifing this parameter login as SYSDBA and execute ALTER SYSTEM command as follows.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>SQL> ALTER SYSTEM SET “_trace_files_public” = TRUE SCOPE=SPFILE;</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">After changing _TRACE_FILES_PUBLIC parameter to TRUE. Newly generated trace has readable permission to other users and public too.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>select value from v$parameter where name = '_trace_files_public';</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>VALUE</b></span><br />
<span style="color: purple;"><b>----------</b></span><br />
<span style="color: purple;"><b>TRUE</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">$cd /oradump/diag/rdbms/ABCPROD1/trace</span><br />
<span style="color: purple;">$ls -lrt</span><br />
<span style="color: purple;">-rw-r--r-- 1 ora11g dba 2247 Feb 18 13:48 ABCPROD1_lmhb_1907.trc</span><br />
<span style="color: purple;">-rw-r--r-- 1 ora11g dba 156 Feb 18 13:48 ABCPROD1_dbrm_1885.trm</span><br />
<span style="color: purple;">-rw-r--r-- 1 ora11g dba 1496 Feb 18 13:48 ABCPROD1_dbrm_1885.trc</span><br />
<div>
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-33730568204647995662014-12-14T21:23:00.000-08:002014-12-23T05:44:56.851-08:00How to stop data pump jobs EXPDP<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>Export full DB backup :--</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">expdp \'/ as sysdba\' full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=Full_DB_bkp.log compression=all </span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Export: Release 11.2.0.2.0 - Production on Fri Dec 12 20:24:31 2014</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production</span><br />
<span style="color: purple;">With the Partitioning, Automatic Storage Management, OLAP, Data Mining</span><br />
<span style="color: purple;">and Real Application Testing options</span><br />
<span style="color: purple;">Starting "SYS"."<b>SYS_EXPORT_FULL_01</b>": "/******** AS SYSDBA" full=Y directory=TEST_DIR dumpfile=DB11G.dmp logfile=Full_DB_bkp.log compression=all </span><br />
<span style="color: purple;">Estimate in progress using BLOCKS method...</span><br />
<span style="color: purple;">Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA</span><br />
<span style="color: purple;">Total estimation using BLOCKS method: 27.60 GB</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>Stop Export Backup from DB level:--</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">SQL> set lines 1000 pages 1000</span><br />
<span style="color: purple;">SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE</span><br />
<span style="color: purple;">------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------</span><br />
<span style="color: purple;">SYS SYS_EXPORT_FULL_01 EXPORT FULL EXECUTING</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><br /></span>
<span style="color: purple;">oracle@Test-DB$expdp \'/ as sysdba\' attach=SYS_EXPORT_FULL_01</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Export: Release 11.2.0.2.0 - Production on Fri Dec 12 21:08:53 2014</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production</span><br />
<span style="color: purple;">With the Partitioning, Automatic Storage Management, OLAP, Data Mining</span><br />
<span style="color: purple;">and Real Application Testing options</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Job: <b>SYS_EXPORT_FULL_01</b></span><br />
<span style="color: purple;"> Owner: SYS</span><br />
<span style="color: purple;"> Operation: EXPORT</span><br />
<span style="color: purple;"> Creator Privs: TRUE</span><br />
<span style="color: purple;"> GUID: 0A076075C651060DE054002128D658F4</span><br />
<span style="color: purple;"> Start Time: Friday, 12 December, 2014 20:46:30</span><br />
<span style="color: purple;"> Mode: FULL</span><br />
<span style="color: purple;"> Instance: TestPRD</span><br />
<span style="color: purple;"> Max Parallelism: 1</span><br />
<span style="color: purple;"> EXPORT Job Parameters:</span><br />
<span style="color: purple;"> Parameter Name Parameter Value:</span><br />
<span style="color: purple;"> CLIENT_COMMAND "/******** AS SYSDBA" full=Y directory=CRAMERDATA_EXP dumpfile=Full_DB_bkp.dmp logfile=Full_DB_bkp.log</span><br />
<span style="color: purple;"> State: EXECUTING</span><br />
<span style="color: purple;"> Bytes Processed: 22,522,186,936</span><br />
<span style="color: purple;"> Percent Done: 98</span><br />
<span style="color: purple;"> Current Parallelism: 1</span><br />
<span style="color: purple;"> Job Error Count: 0</span><br />
<span style="color: purple;"> Dump File: /orabkp/exp_backup/Full_DB_bkp.dmp</span><br />
<span style="color: purple;"> bytes written: 22,569,902,080</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">Worker 1 Status:</span><br />
<span style="color: purple;"> Process Name: DW00</span><br />
<span style="color: purple;"> State: EXECUTING</span><br />
<span style="color: purple;"> Object Schema: Test</span><br />
<span style="color: purple;"> Object Name: CR_FR_RO</span><br />
<span style="color: purple;"> Object Type: DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA</span><br />
<span style="color: purple;"> Completed Objects: 313</span><br />
<span style="color: purple;"> Total Objects: 3,100</span><br />
<span style="color: purple;"> Worker Parallelism: 1</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>Export> STOP_JOB</b></span><br />
<span style="color: purple;"><b>Are you sure you wish to stop this job ([yes]/no): yes</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">oracle@Test-DB$</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;"><b>Export Check Status :--</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">SQL> set lines 1000 pages 1000</span><br />
<span style="color: purple;">SQL> SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;</span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE</span><br />
<span style="color: purple;">------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------</span><br />
<span style="color: purple;"><b>SYS SYS_EXPORT_FULL_01 EXPORT FULL NOT RUNNING</b></span><br />
<span style="color: purple;"><br /></span>
<span style="color: purple;">SQL> exit</span><br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-85700250843234130912014-12-10T04:19:00.001-08:002014-12-10T04:19:18.002-08:00Enable or Disable Hibernate in Windows <div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>To Enable Hibernate</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">NOTE: This step will restore the hiberfil.sys file, and the Allow hybrid sleep and Hibernate after Power Options under Sleep.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">You Need Administrator access for run below command </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">In the command prompt,Run below, and press Enter. & check START butten</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><span style="font-size: large;">powercfg -h on</span></b> </span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>To Disable Hibernate</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">NOTE: This step will disable hibernation, delete the hiberfil.sys file, and remove the Allow hybrid sleep and Hibernate after Power Options under Sleep..</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">In the command prompt, Run below, and press Enter. & check START butten</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: large;"><b>powercfg -h off</b></span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com2tag:blogger.com,1999:blog-6883510542658399269.post-29186989566601739652014-10-29T02:42:00.005-07:002014-12-07T23:38:20.481-08:00PRCN-2065 : Port(s) 1521 are not available on the nodes given<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Error:--</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">INFO: Problem in configuration: PRCN-2061 : Failed to add listener ora.LISTENER.lsnr<br />INFO: PRCN-2065 : Port(s) 1521 are not available on the nodes given<br />INFO: PRCN-2067 : Port 1521 is not available across node(s) "hww-poc1-VIP,hww-poc2-VIP"<br />INFO: Oracle Net Listener Startup:<br />INFO: Listener does not exists.<br />INFO: Check the trace file for details: /home/grid/app/grid/cfgtoollogs/netca/trace_Ora11g_gridinfrahome1-1410287PM2700.log<br />INFO: Oracle Net Services configuration failed. The exit code is 1</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span>
<br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br />I had a similar issue to this. It turned out the tns listener had already started on the VIP address on the both nodes.</span></span><br />
<br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">[root@test-poc1 ~]# ps -ef | grep tns<br />root 165 2 0 Oct27 ? 00:00:00 [netns]<br />grid 80554 1 0 19:23 ? 00:00:00 /home/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit<br />root 83352 62292 0 19:33 pts/2 00:00:00 grep tns</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br />[root@test-poc2 ~]# ps -ef | grep tns<br />root 165 2 0 Oct27 ? 00:00:00 [netns]<br />grid 80554 1 0 19:23 ? 00:00:00 /home/11.2.0/grid/bin/tnslsnr LISTENER_SCA2 -inherit<br />root 83352 62292 0 19:33 pts/2 00:00:00 grep tns<br /> </span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Check below command :--</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">if 1521 port assign to other ip like below show in bold. </span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">[root@test-poc1 ~]#<b> netstat -nltp</b><br />Active Internet connections (only servers)<br />Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name<br />tcp 0 0 0.0.0.0:000 0.0.0.0:* LISTEN 9774/rpcbind<br /><b>tcp 0 0 00.100.10.00:1521 0.0.0.0:* LISTEN 80554/tnslsnr</b><br />tcp 0 0 0.0.0.0:5522 0.0.0.0:* LISTEN 33613/sshd</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Kill the SCAN listner & stop/disable listner process in both node using below command :-<br /><br />[grid@test-poc1 ~]$ <b>/home/11.2.0/grid/bin/srvctl status scan_listener</b><br />SCAN Listener LISTENER_SCAN1 is enabled<br />SCAN listener LISTENER_SCAN1 is running on node hww-poc1<br />SCAN Listener LISTENER_SCAN2 is enabled<br />SCAN listener LISTENER_SCAN2 is running on node hww-poc2<br /><br />[grid@test-poc1 ~]$ <b>/home/11.2.0/grid/bin/srvctl stop scan_listener</b><br /><br />[grid@test-poc1 ~]$<b> /home/11.2.0/grid/bin/srvctl status scan_listener</b><br />SCAN Listener LISTENER_SCAN1 is enabled<br />SCAN listener LISTENER_SCAN1 is not running<br />SCAN Listener LISTENER_SCAN2 is enabled<br />SCAN listener LISTENER_SCAN2 is not running<br /><br />[grid@test-poc1 ~]$ <b>/home/11.2.0/grid/bin/srvctl disable scan_listener</b><br /><br />[grid@test-poc1 ~]$ <b> /home/11.2.0/grid/bin/srvctl status scan_listener</b><br />SCAN Listener LISTENER_SCAN1 is disabled<br />SCAN listener LISTENER_SCAN1 is not running<br />SCAN Listener LISTENER_SCAN2 is disabled<br />SCAN listener LISTENER_SCAN2 is not running</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">then re-try the Oracle Net Configuration Assistant step allowed me to continue.</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com6tag:blogger.com,1999:blog-6883510542658399269.post-43834431933981749432014-10-29T01:43:00.000-07:002014-12-07T23:38:40.550-08:00clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory<div dir="ltr" style="text-align: left;" trbidi="on">
<b><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Error:--</span></span></span></b><br />
<br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><b>Failed to create keys in the OLR, rc = 127, Message:<br /> /home/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory<br /><br />Failed to create keys in the OLR at /home/11.2.0/grid/crs/install/crsconfig_lib.pm line 7660.<br />/home/11.2.0/grid/perl/bin/perl -I/home/11.2.0/grid/perl/lib -I/home/11.2.0/grid/crs/install /home/11.2.0/grid/crs/install/rootcrs.pl execution failed</b><br /> </span></span></span><br />
<br />
<b><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Issue :--</span></span></span></b><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><br /></span></span></span>
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">[root@test-poc1 ~]# /home/11.2.0/grid/root.sh<br />Performing root user operation for Oracle 11g<br /><br />The following environment variables are set as:<br /> ORACLE_OWNER= grid<br /> ORACLE_HOME= /home/11.2.0/grid<br /><br />Enter the full pathname of the local bin directory: [/usr/local/bin]:<br />The contents of "dbhome" have not changed. No need to overwrite.<br />The contents of "oraenv" have not changed. No need to overwrite.<br />The contents of "coraenv" have not changed. No need to overwrite.<br /><br />Entries will be added to the /etc/oratab file as needed by<br />Database Configuration Assistant when a database is created<br />Finished running generic part of root script.<br />Now product-specific root actions will be performed.<br />Using configuration parameter file: /home/11.2.0/grid/crs/install/crsconfig_params<br />User ignored Prerequisites during installation<br />Installing Trace File Analyzer<br />Failed to create keys in the OLR, rc = 127, Message:<br /> /home/11.2.0/grid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory<br /><br />Failed to create keys in the OLR at /home/11.2.0/grid/crs/install/crsconfig_lib.pm line 7660.<br />/home/11.2.0/grid/perl/bin/perl -I/home/11.2.0/grid/perl/lib -I/home/11.2.0/grid/crs/install /home/11.2.0/grid/crs/install/rootcrs.pl execution failed<br />[root@test-poc1 ~]#</span></span></span><br />
<br />
<b><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Solution :--</span></span></span></b><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">check below command<br /><br /><b># yum list | grep libcap </b><br />compat-libcap1.i686 1.10-1 @ol6_ga_base <br />libcap.i686 2.16-5.2.el6 @ol6_ga_base <br />libcap.x86_64 2.16-5.2.el6 @anaconda-OracleLinuxServer-201102031546.x86_64/6.0 <br />libcap-devel.i686 2.16-5.2.el6 @ol6_ga_base <br />libcap-devel.x86_64 2.16-5.2.el6 @ol6_ga_base <br />libcap-ng.x86_64 0.6.4-3.el6_0.1 @ol6_u1_base <br />compat-libcap1.x86_64 1.10-1 ol6_ga_base <br />libcap-ng.i686 0.6.4-3.el6_0.1 ol6_u1_base <br />libcap-ng-devel.i686 0.6.4-3.el6_0.1 ol6_u1_base <br />libcap-ng-devel.x86_64 0.6.4-3.el6_0.1 ol6_u1_base <br />libcap-ng-python.x86_64 0.6.4-3.el6_0.1 ol6_u1_base <br />libcap-ng-utils.x86_64 0.6.4-3.el6_0.1 ol6_u1_base <br /><br /><br /><b>Install below 2 pkg & run root.sh again</b><br /> </span></span></span><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;">Installed... <br /><b># yum install libcap.x86_64 </b><br />Setting up Install Process <br />Package libcap-2.16-5.2.el6.x86_64 already installed and latest version <br />Nothing to do<br />libcap2 package installed, so install libcab1. <br /><b> </b></span></span></span><br />
<span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="color: purple;"><b># yum install compat-libcap1.x86_64 </b><br />Setting up Install Process <br />Resolving Dependencies <br />--> Running transaction check <br />---> Package compat-libcap1.x86_64 0:1.10-1 will be installed <br />--> Finished Dependency Resolution </span></span></span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-78638133320997500302014-10-29T01:31:00.001-07:002014-12-07T23:03:57.611-08:00ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">Issue :--</span></span></span><br />
<br />
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">oracle@test$<b>sqlplus<br />ld.so.1: sqlplus: fatal: libsqlplus.so: open failed: No such file or directory<br />Killed</b><br />oracle@test$ </span></span></span><br />
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><br /></span></span></span>
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><br /></span></span></span>
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">solution :--</span></span></span><br />
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><br /></span></span></span>
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">We could see from above result that some shared library dependencies for sqlplus is not found.<br />Following settings are applicable for Solaris.<br /><br /><b>LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/lib:/usr/lib:/usr/lib/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:<br />export LD_LIBRARY_PATH</b><br /> </span></span></span><br />
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">After setting correct value for LD_LIBRARY_PATH, issue got resolved and not getting any error.</span></span></span><br />
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><br /></span></span></span>
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;"><br /></span></span></span>
<span style="color: purple;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">oracle@test$sqlplus<br /><br />SQL*Plus: Release 10.2.0.5.0 - Production on Wed Oct 29 13:52:25 2014<br /><br />Copyright (c) 1982, 2010, Oracle. All Rights Reserved.<br /><br />Enter user-name: / as sysdba</span></span></span><br /></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-40754637561603250272014-06-26T04:12:00.000-07:002014-12-07T23:03:57.548-08:00Database shortcut command's in PostgreSQL<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"><strong>General:-</strong></span><br />
<span style="color: purple;"><strong></strong><br /> \c[onnect] [DBNAME|- [USER]]<br /> connect to new database (currently "pizzastore")<br /> \cd [DIR] change the current working directory<br /> \copyright show PostgreSQL usage and distribution terms<br /> \encoding [ENCODING]<br /> show or set client encoding<br /> \h [NAME] help on syntax of SQL commands, * for all commands<br /> \q quit psql<br /> \set [NAME [VALUE]]<br /> set internal variable, or list all if no parameters<br /> \timing toggle timing of commands (currently off)<br /> \unset NAME unset (delete) internal variable<br /> \! [COMMAND] execute command in shell or start interactive shell</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"><strong>Query Buffer:-</strong></span><br />
<span style="color: purple;"><strong></strong><br /> \e [FILE] edit the query buffer (or file) with external editor<br /> \g [FILE] send query buffer to server (and results to file or |pipe)<br /> \p show the contents of the query buffer<br /> \r reset (clear) the query buffer<br /> \s [FILE] display history or save it to file<br /> \w FILE write query buffer to file</span><br />
<span style="color: purple;">Input/Output<br /> \echo [STRING] write string to standard output<br /> <br /> \echo `date`<br />Thu Jun 26 21:40:57 IST 2014<br /> <br /> \i FILE execute commands from file<br /> \o [FILE] send all query results to file or |pipe<br /> \qecho [STRING]<br /> write string to query output stream (see \o)</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"><strong>Informational:-</strong></span><br />
<span style="color: purple;"><strong></strong><br /> \d [NAME] describe table, index, sequence, or view<br /> \d{t|i|s|v|S} [PATTERN] (add "+" for more detail)<br /> list tables/indexes/sequences/views/system tables<br /> \da [PATTERN] list aggregate functions<br /> \db [PATTERN] list tablespaces (add "+" for more detail)<br /> \dc [PATTERN] list conversions<br /> \dC list casts<br /> \dd [PATTERN] show comment for object<br /><br /> Shows the descriptions of objects matching the pattern, or of all visible objects if no argument is given. But in either case, only objects that have a description are listed. By default, only user-created objects are shown; supply a pattern or the S modifier to include system objects. "Object" covers aggregates, functions, operators, types, relations (tables, views, indexes, sequences), large objects, rules, and triggers. For example:<br /> \dd version<br /> Object descriptions<br /> Schema | Name | Object | Description<br /> ------------+---------+----------+---------------------------<br /> pg_catalog | version | function | PostgreSQL version string<br /> <br /> \dD [PATTERN] list domains<br /> \df [PATTERN] list functions (add "+" for more detail)<br /> \dg [PATTERN] list groups<br /> \dn [PATTERN] list schemas (add "+" for more detail)<br /> \do [NAME] list operators<br /> \dl list large objects, same as \lo_list<br /> \dp [PATTERN] list table, view, and sequence access privileges<br /> \dT [PATTERN] list data types (add "+" for more detail)<br /> \du [PATTERN] list users<br /> \l list all databases (add "+" for more detail)<br /> \z [PATTERN] list table, view, and sequence access privileges (same as \dp)</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"><strong>Formatting:-</strong></span><br />
<span style="color: purple;"><strong></strong><br /> \a toggle between unaligned and aligned output mode<br /> \C [STRING] set table title, or unset if none<br /> \f [STRING] show or set field separator for unaligned query output<br /> \H toggle HTML output mode (currently off)<br /> \pset NAME [VALUE]<br /> set table output option<br /> (NAME := {format|border|expanded|fieldsep|footer|null|<br /> recordsep|tuples_only|title|tableattr|pager})<br /> \t show only rows (currently off)<br /> \T [STRING] set HTML <table> tag attributes, or unset if none<br /> \x toggle expanded output (currently off)</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"><strong>Copy, Large Object:-</strong><br /> \copy ... perform SQL COPY with data stream to the client host<br /> \lo_export LOBOID FILE<br /> \lo_import FILE [COMMENT]<br /> \lo_list<br /> \lo_unlink LOBOID large object operations</span></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-66154616367482617472014-05-28T22:49:00.002-07:002014-12-07T23:03:57.591-08:00ORA-00001: unique constraint (PERFSTAT.STATS$MUTEX_SLEEP_PK) violated<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;"></span><br />
<span style="color: purple;"><strong>ORA-12012: error on auto execute of job 21<br />ORA-00001: unique constraint (PERFSTAT.STATS$MUTEX_SLEEP_PK) violated<br />ORA-06512: at "PERFSTAT.STATSPACK", line 5264<br />ORA-06512: at "PERFSTAT.STATSPACK", line 104<br />ORA-06512: at line 1</strong></span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">In this case unique constraint is violated because the job try to take a snapshot of same number which is already been taken or sometime it receives two same id number to process the snapshot which again violates the unique constraint.</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">NOTE: This is an oracle known bug.</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">View Metalink Note 382993.1 to get the low-down on this one, but the workaround is an easy implementation-</span><br />
<span style="color: purple;"><strong></strong></span><br />
<span style="color: purple;"><strong>###### workaround or solution#########</strong></span><br />
<span style="color: purple;">Disable the constraint which is avoiding the job to create a snapshot</span><br />
<br /><span style="color: purple;">1)ALTER TABLE perfstat.stats$mutex_sleep disable CONSTRAINT STATS$MUTEX_SLEEP_PK;</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">Then create an index on this:-</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">2)CREATE INDEX perfstat.STATS$MUTEX_SLEEP_PK ON STATS$MUTEX_SLEEP(SNAP_ID,DBID,INSTANCE_NUMBER,MUTEX_TYPE,LOCATION);</span><br />
<span style="color: purple;">after executing these two steps take an on demand snapshot just to make sure if the problem has been sorted out. If the the on demand snapshot completes successfully then it means the problem is sorted out</span><br />
<span style="color: purple;">NOTE: constantly monitor alert log file while doing all these steps.</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;">3) Exec statspack.snap;</span><br />
<span style="color: purple;"></span> </div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-2384303172818429692014-05-26T02:27:00.004-07:002014-12-07T23:03:57.518-08:00DROP DATABASE in Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: purple;">Since 10g, It is possible to drop a database in Oracle 10g with the new SQL statement drop database.</span><br />
<span style="color: purple;">The command gets rid of datafiles online redo log files, controlfiles and spfile.</span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp6JBfrMwKsYImC0h-Rs3hCaebN1w6-AwRO8-gEE1cVeXYwazEGUxe4XC8B7cngpadW8FXHT90YcOfBhWoZdZje6pd27-happL3TjuycrVYAaIW9ahXJYl3Mtf3a9rg44VWimaMQ6hDuw/s1600/Capture.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgp6JBfrMwKsYImC0h-Rs3hCaebN1w6-AwRO8-gEE1cVeXYwazEGUxe4XC8B7cngpadW8FXHT90YcOfBhWoZdZje6pd27-happL3TjuycrVYAaIW9ahXJYl3Mtf3a9rg44VWimaMQ6hDuw/s1600/Capture.GIF" /></a></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-29993356899690551072014-03-14T01:28:00.000-07:002014-12-07T23:03:57.530-08:00ORA-16014: log 1 sequence# not archived, no available destinations<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>Error :--</b></span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-16038: log 1 sequence# 93878 cannot be archived</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-19504: failed to create file ""</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-00312: online log 1 thread 1: '+DG_RED01/testprd/onlinelog/group_1.259.810739125'</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-00312: online log 1 thread 1: '+DG_RED02/testprd/onlinelog/group_1.259.810739127'</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">Fri Mar 14 10:55:10 2014</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ARCH: Archival stopped, error occurred. Will continue retrying</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORACLE Instance TESTPRD - Archival Error</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-16014: log 1 sequence# 93878 not archived, no available destinations</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-00312: online log 1 thread 1: '+DG_RED01/testprd/onlinelog/group_1.259.810739125'</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">ORA-00312: online log 1 thread 1: '+DG_RED02/testprd/onlinelog/group_1.259.810739127'</span></div>
<div style="text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">Fri Mar 14 11:00:10 2014</span></div>
<div style="text-align: left;">
<div style="line-height: 19.5px;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><br /><b>Solution :--</b></span></div>
<div style="line-height: 19.5px;">
<span style="color: purple;"><br /></span></div>
<span style="line-height: 19.5px;"><b><span style="color: purple;">Remove you old archive logs first. Reduce your mount point usage to below 90%, then check</span></b></span><br />
<div style="line-height: 19.5px;">
<b><span style="color: purple;"><br /></span></b></div>
<div style="line-height: 19.5px;">
<b><span style="color: purple;">Clean Archive from RMAN :-</span></b></div>
<div>
<div style="line-height: 19.5px;">
<b><span style="color: purple;"><br /></span></b></div>
</div>
<div>
<div>
<span style="line-height: 19.5px;"><b><span style="color: purple;">1> check current sequence number:-</span></b></span></div>
<div>
<div>
<span style="line-height: 19.5px;"><span style="color: purple;"><br /></span></span></div>
<div>
<span style="line-height: 19.5px;"><span style="color: purple;">SQL> select max(sequence#),thread# from v$backup_redolog group by thread#;</span></span></div>
<div style="line-height: 19.5px;">
<span style="color: purple;"><br /></span></div>
</div>
</div>
<div>
<div>
<span style="line-height: 19.5px;"><span style="color: purple;">MAX(SEQUENCE#) THREAD#</span></span></div>
<div>
<div>
<span style="line-height: 19.5px;"><span style="color: purple;">-------------- ----------</span></span></div>
<div>
<div>
<span style="line-height: 19.5px;"><span style="color: purple;"> 93875 1</span></span></div>
<div style="line-height: 19.5px;">
<br /></div>
</div>
</div>
</div>
</div>
<div style="line-height: 19.5px; text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>2>Connect with RMAN</b><br />oracle@testprd$rman TARGET /<br />Recovery Manager: Release 11.2.0.2.0 - Production on Fri Mar 14 11:06:53 2014<br />Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.<br />connected to target database:TESTPRD<br /><b><br /></b></span></div>
<div style="line-height: 19.5px; text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>3> Check backup & Delete archive sequence (less then 100 from current sequence no). </b></span></div>
<div style="text-align: left;">
<div style="line-height: 19.5px;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">RMAN> delete archivelog until sequence 93675;<br /><br /><b><span style="background-color: white; font-size: x-small; line-height: 19.5px;"><br /></span></b></span></div>
<div style="line-height: 19.5px;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b><span style="background-color: white; font-size: x-small; line-height: 19.5px;"></span></b></span></div>
<b style="color: purple; font-family: Georgia, 'Times New Roman', serif; font-size: small; line-height: 19.5px;">Clean Archive from System Disk :-</b><br />
<div>
<div>
<span style="line-height: 19.5px;"><b><span style="color: purple;"><br /></span></b></span>
<span style="line-height: 19.5px;"><b><span style="color: purple;">1>check archive location</span></b></span></div>
<div style="line-height: 19.5px;">
<br /></div>
</div>
</div>
<div style="line-height: 19.5px; text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;">SQL> archive log list<br />Database log mode Archive Mode<br />Automatic archival Enabled<br />Archive destination /disk1/archive<br />Oldest online log sequence 93885<br />Next log sequence to archive 93890<br />Current log sequence 93890<br /><b><br /></b></span></div>
<div style="line-height: 19.5px; text-align: left;">
<span style="color: purple; font-family: Georgia, Times New Roman, serif;"><b>2> go to archive path</b><br />cd /disk1/archive<br /><br /><b>3> Check backup & delete archive files</b></span></div>
<div style="text-align: left;">
<span style="color: purple;"><br /><span style="background-color: white; font-size: x-small; line-height: 19.5px;"></span></span>
<span style="color: purple;">rm -rf archive_files.arc</span><br />
<div>
<br /></div>
<span style="background-color: white; font-size: x-small; line-height: 19.5px;">
</span></div>
<div>
<br /></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-54553512578980435332014-02-23T23:59:00.001-08:002014-12-07T23:03:57.573-08:00ORA-09817: Write to audit file failed. ORA-09945: Unable to initialize the audit trail file<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple;">SQL> startup</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"> ---it show this error</span><br />
<span style="color: purple;"> ORA-09817: Write to audit file failed.<br /> Linux-x86_64 Error: 28: No space left on device<br /> ORA-09945: Unable to initialize the audit trail file</span><br />
<br />
<span style="color: purple;">Why :=<br /> ============</span><br />
<span style="color: purple;"> its because of full the Mount point where Oracle is installed .<br /> your audit_trail_dest or audit trail destination is full for generation of audit file.</span><br />
<span style="color: purple;"> you can do :-<br /> ==============</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"> 1) check the space of mount point. like below.....</span><br />
<span style="color: purple;"> $ df -k</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"> 2) move the audit_file_dest parameter to another mount point <br /> using below command:<br /> alter system set audit_file_dest='new mount point /u02 /u03' <br /> scope=spfile;</span><br />
<span style="color: purple;"> then restart the database but you need to make sure that there enough space on server before restart. </span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"> or</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"> 3) delete some unnecessary trace file or something from that fulled mount point.<br /> then try to start the oracle database.</span><br />
<span style="color: purple;"> it is advisable, backup the files before they are delete since they might be useful in future.</span><br />
<span style="color: purple;"></span><br />
<span style="color: purple;"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk3yZLkX6oD80kRdmHTErJ-GhsV3lSiLfBPk4ty7SPjLb9SocEzFNfwFL9yhX_5b4GOBLGawscR4IhP58Z-s9sLg5cj657pSso7vfXge5WxlfioatkUPdxXfYrd0Xp7BAHk7p-ALeOin0/s1600/Capture.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhk3yZLkX6oD80kRdmHTErJ-GhsV3lSiLfBPk4ty7SPjLb9SocEzFNfwFL9yhX_5b4GOBLGawscR4IhP58Z-s9sLg5cj657pSso7vfXge5WxlfioatkUPdxXfYrd0Xp7BAHk7p-ALeOin0/s1600/Capture.GIF" /></a></div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-45764978532452849922014-01-29T04:40:00.002-08:002014-12-07T23:03:57.562-08:00 fatal: librt.so.1: version `SUNW_1.2' not found <div dir="ltr" style="text-align: left;" trbidi="on">
<strong><span style="color: purple; font-family: "Courier New", Courier, monospace;">Answer:</span></strong><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;">You will need to set your environment variable, LD_NOVERSION=yes. For example, in bash:</span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;">/usr/local/> export LD_NOVERSION=yes</span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;">In csh:</span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;">/usr/local/> setenv LD_NOVERSION yes</span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;">The is is caused by an eventual incompatibility between the differing Java versions on the machine as well as the packages and patches that were applied to the machine. For now, <br />please use set the LD_NOVERSION environment variable to "yes".</span><br />
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-11268791222759849562014-01-28T05:18:00.002-08:002014-12-07T23:03:57.509-08:00SAN vs NAS - What Is the Difference?<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"><strong>Question: SAN vs NAS - What Is the Difference?</strong></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"> </span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: purple;"><strong>Answer:</strong> </span></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"> A NAS is a single storage device that operate on data files, while a SAN is a local network of multiple devices that operate on disk blocks.</span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"></span><br />
<span style="font-family: "Courier New", Courier, monospace;"><span style="color: purple;"> <strong>SAN vs NAS Technology:</strong></span></span><br />
<span style="color: purple; font-family: "Courier New", Courier, monospace;"> A SAN commonly utilizes Fibre Channel interconnects.<br /> A NAS typically makes Ethernet and TCP/IP connections.</span><br />
<span style="font-family: Courier New;"></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-6rJsBsUIJzDQyxL4aFTJoYzR-QORWlPnAU2fGb_76tneVyM_UHOB06Dcqb6TWlNk0at6TdG_Dknxd2bZ1qDbPEJnoZ7CWHkzQgBvrwNmNYs9-Io_XNAWiQALfbvReWIAydlmTDyB10A/s1600/Capture.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-6rJsBsUIJzDQyxL4aFTJoYzR-QORWlPnAU2fGb_76tneVyM_UHOB06Dcqb6TWlNk0at6TdG_Dknxd2bZ1qDbPEJnoZ7CWHkzQgBvrwNmNYs9-Io_XNAWiQALfbvReWIAydlmTDyB10A/s1600/Capture.GIF" /></a></div>
<br />
<br /></div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0tag:blogger.com,1999:blog-6883510542658399269.post-58093965586915168942014-01-02T00:34:00.001-08:002014-12-24T02:55:37.562-08:00Connect Oracle to MySQL Server through ODBC database link<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: purple; font-family: Courier New, Courier, monospace;">I will setup 11gR2 Oracle gateway for ODBC to connect between a version 11.2.0.3 Oracle database and a version 5.5 MySQL database on different machines.. The Oracle database is on a 64-bit SunOS , while MySQL database is on a 64-bit SunOS server. I will provide some tips and tricks along the way.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Unless specified, all the steps are performed on the Oracle gateway server.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Scope:- MySQL Connectors - Version 3.51 to 5.1 [Release 3.51 to 5.1]</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Information in this document applies to any platform.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ODBC, UnixODBC, DG4ODBC, MySQL, ODBCINI, Database Link</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Oracle database server uses DG4ODBC as the data gateway for connecting to non-Oracle RDBMS. This requires the proper setup for all components involved in transferring data from Oracle to MySQL and back. These components interact with each other in the following way:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+-----------------------------<ODBC Client Host>---------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| [ORACLE] <---> [DG4ODBC] <---> [ODBC Driver Manager] <---> [ODBC Driver] |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+--------------------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> /|\</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> NETWORK</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> \|/</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> +--<MySQL Server Host>--+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> | |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> | [MySQL Server] |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> | |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"> +-----------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">In this article we will configure each component and diagnose problems that are most likely to be encountered during the setup process. NOTE: There are few articles in the internet that skip [ODBC Driver Manager] and connect directly [DG4ODBC] <- - -> [ODBC Driver]. It might work for some</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">drivers such as DataDirect or specific configurations, but beware that MySQL [ODBC Driver] (versions 3.51.x and 5.1.x) is not supposed to be loaded directly. The recommended driver manager is UnixODBC v.2.2.14 or newer. Configuring ODBC connections in 32-bit OS might be slightly easier than in 64-bit OS. The latter can execute 32 and 64-bit code and more attention must be paid to the components versions. In other words, when configuring ODBC you cannot mix 32-bit and 64-bit components within the Client Host. This is so because 32-bit binaries code can only load 32-bit binaries and 64-bit binaries can only load 64-bit binaries. [MySQL Server] is always independent because all communication with the driver is done through the network protocol. You have the choice to place [MySQL Server] on <ODBC Client Host> or on another physical host in the network <MySQL Server Host>. In any case, the bit depth of [MySQL Server]</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 1:-</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>We shall start from determining if [Oracle] and [DG4ODBC] are 32/64-bits: </b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ file $ORACLE_HOME/bin/dg4odbc</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">/home/dbs/app/Ora/product/11.2.0/dbhome_1/bin/dg4odbc: ELF 64-bit LSB</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped</span><br />
<div>
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 12pt;">
<div class="separator" style="clear: both; color: #002060; font-family: Cambria, serif; font-size: 12pt; line-height: 115%; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYMpln9ehd_8OeBJVxzkF3gIiD2PHpwSaZmCcG3njzdqwBYuStsrrhUgcspUyfX0MvtAQNn05h_7kSHknyCmZJzhSfCI_qdQF31ahi3ZsJ7v2uqsB5gGCXLt-WNgsq6HUI8qFONnTeAxM/s1600/12.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYMpln9ehd_8OeBJVxzkF3gIiD2PHpwSaZmCcG3njzdqwBYuStsrrhUgcspUyfX0MvtAQNn05h_7kSHknyCmZJzhSfCI_qdQF31ahi3ZsJ7v2uqsB5gGCXLt-WNgsq6HUI8qFONnTeAxM/s1600/12.png" /></a><span lang="EN-US"></span></div>
<div style="color: #002060; font-family: Cambria, serif; font-size: 12pt; line-height: 115%;">
<span lang="EN-US"><span style="color: purple; font-family: "Courier New", Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0pt;">
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">The above command output says that we must use 64-bit [ODBC Driver Manager] and 64-bit [ODBC Driver]</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 2</b></span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: 'Courier New', Courier, monospace;"><b>Getting and installing [ODBC Driver Manager] UnixODBC 2.2.14.</b></span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">If your OS provides UnixODBC 2.2.14 or newer update package you have to install it. Otherwise, go to UnixODBC Downloads at sourceforge:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">http://sourceforge.net/projects/unixodbc/files/unixODBC/</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Choose the version (2.2.14 is recommended).</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">| NOTE: RPM packages are not offered, so the package has to be installed |</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">| from tar.gz. This is good for few reasons: |</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">| |</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">| - No root access is required to do so |</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">| - You can keep few different versions of UnixODBC at once |</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">+---------------------------------------------------------------------------+</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">If binary package for your OS is not available in the list, go to UnixODBC web site to find out how to build it from sources:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">http://www.unixodbc.org/download.html</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">In this example we will get unixODBC-2.2.14-linux-x86-64.tar.gz:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">http://sourceforge.net/projects/unixodbc/files/unixODBC/2.2.14/unixODBC-2.2.14-linux-x86-64.tar.gz/download</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">Download the package into the home directory (/home/dbs/).</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">Create a new directory for UnixODBC:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"> $ mkdir ~/app/unixodbc-2.2.14</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"> $ cd ~/app/unixodbc-2.2.14</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Unpack the package into the newly created directory:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"> $ gunzip -c ~/unixODBC-2.2.14-linux-x86-64.tar.gz | tar xvf -</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">Latest UnixODBC packages put lib and bin directories in /usr/local inside the</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">package, so we need to move them to the upper level for convenience</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"> $ mv ~/app/usr/local/* .</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"> $ rm -r usr</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">Check the directory contents:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">$ ls -l</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">drwxrwxr-x 2 dbs dbs 4096 Nov 20 2008 bin</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">drwxrwxr-x 2 dbs dbs 4096 Nov 20 2008 include</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">drwxrwxr-x 2 dbs dbs 4096 Nov 20 2008 lib</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">later we will have to set LD_LIBRARY_PATH to point to /home/dbs/app/unixodbc-2.2.14/lib</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 3</b></span></span><br />
<span lang="EN-US"><b style="color: purple; font-family: "Courier New", Courier, monospace;">Getting and installing [ODBC Driver].</b></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">Similar to UnixODBC, it is possible to have several different versions of MySQL Connector/ODBC driver. Installing the driver from tar.gz package does not require root privileges and allows installing the driver at custom locations, so we will do so.</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">More details about installing MySQL Connector/ODBC can be found here:</span></span><br />
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;">http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-installation-binary-unix.html</span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US"><span lang="EN-US"><b><span style="background-color: white; font-family: Cambria, serif;"><br /></span></b></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyEQMAR_i4yTEXl1ODCvzM-jj-oBCRT9WKq1EHqRWbF-1leGu5FsKSyi9wGP-fpV_vSOAIZgBCni-KlWCgrGbun5zcztibGKtYlnWdirMy4qeK1flv6ViLSJgutDkKskEdJHz5vrDghq0/s1600/13.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyEQMAR_i4yTEXl1ODCvzM-jj-oBCRT9WKq1EHqRWbF-1leGu5FsKSyi9wGP-fpV_vSOAIZgBCni-KlWCgrGbun5zcztibGKtYlnWdirMy4qeK1flv6ViLSJgutDkKskEdJHz5vrDghq0/s1600/13.png" /></a></div>
</div>
<div class="MsoNormal" style="margin: 0cm 0cm 12pt;">
<span lang="EN-US"><span lang="EN-US" style="background-color: white;">
</span></span>
<br />
<div class="separator" style="clear: both; text-align: left;">
<span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"><br /></span></span></span></span></div>
<span lang="EN-US"><span lang="EN-US" style="background-color: white;">
</span></span>
<div class="separator" style="clear: both;">
<span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">Download the tar.gz package from the following page: </span></span></span></span></div>
<span lang="EN-US"><span lang="EN-US" style="background-color: white;">
</span></span>
<div class="separator" style="clear: both;">
<span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">http://www.mysql.com/downloads/connector/odbc/5.1.htmlUnpack </span></span></span></span></div>
<span lang="EN-US"><span lang="EN-US" style="background-color: white;">
<div class="separator" style="clear: both;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">the driver into ~/app director</span></span></div>
<div class="separator" style="clear: both;">
<span style="line-height: 18px;"><span style="color: purple; font-family: Courier New, Courier, monospace;"></span></span><br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: 'Courier New', Courier, monospace; line-height: 18px;">$ cd ~/app$ gunzip -c mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit.tar.gz | tar xvf -</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">This command creates mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit directory and extracts all needed files in it. Create a symbolic link with a shorter name:</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">$ ln -s mysql-connector-odbc-5.1.8-linux-glibc2.3-x86-64bit myodbc-5.1.8</span></span></div>
<div class="separator" style="clear: both;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"><b>Step 4</b></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: 'Courier New', Courier, monospace; line-height: 18px;"><b>Configuring ODBC data source for MySQL Connector/ODBC driver is described here:</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-configuration-dsn-unix.html</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">So, we will create odbc.ini file in ~/etc:</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">[myodbc5]</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> Driver = /home/dbs/app/myodbc-5.1.8/lib/libmyodbc5.so</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> Description = Connector/ODBC 5.1 Driver DSN</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> SERVER = 10.0.0.1</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> PORT = 3306</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> USER = mysql_user</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> PASSWORD = *****</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> DATABASE = test</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> OPTION = 0</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"> TRACE = OFF</span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">Exp:--</span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">more /export/home/mysql-connector/odbc.ini</span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">[myodbc5]</span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">driver=</span></span><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">/export/home/mysql-connector/</span></span></span></span><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">mysql-connector-odbc-5.2.5-solaris10-sparc-64bit/lib/libmyodbc5w.so</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">server=10.0.0.0</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">port=3306</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">user=abcd</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">password=adbc123</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">database=test</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: blue;"><b><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;">option=0</span></span></span></span></span></span></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span lang="EN-US"><span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><span style="line-height: 18px;"><span style="color: blue;"><b>trace=OFF</b></span> </span></span></span></span></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; line-height: 115%; text-align: center;">
</div>
<div class="MsoListParagraphCxSpLast" style="color: #002060; font-family: Cambria, serif; font-size: 11pt; line-height: normal; margin-bottom: 0pt;">
<span lang="EN-US" style="font-family: Cambria, serif;"><br /></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0cm;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 5 (Optional)</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Verifying the ODBC connection using isql command line.</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ export ODBCINI=/home/dbs/etc/odbc.ini</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ export LD_LIBRARY_PATH=/home/dbs/app/unixodbc-2.2.14/lib:$LD_LIBRARY_PATH</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ cd ~/app/unixodbc-2.2.14/bin/</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ ./isql myodbc5 -v</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| Connected! |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| sql-statement |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| help [tablename] |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| quit |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The above output will display if connection has been established successfully. Next, trying to send a simple query to list tables in the database:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> show tables;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+-----------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| Tables_in_test |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+-----------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| tab1 |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| tab2 |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+-----------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQLRowCount returns 2</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">2 rows fetched</span><br />
<div style="line-height: normal;">
<br /></div>
</div>
<div class="separator" style="clear: both; line-height: 115%; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIAjy_rRTniZbWhSqKxo4uPJw2gJ6Z5ikPvh6al2LHOou2U2cfs0hviWXjBAj2MhLcSqnd3TwMpbREniXRPr-nq8c6ZIiZRi8iAA4b3JSNc_IP9-y2JVNB2EB3IaUH7MZ3bxdLhfxWDEg/s1600/15.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIAjy_rRTniZbWhSqKxo4uPJw2gJ6Z5ikPvh6al2LHOou2U2cfs0hviWXjBAj2MhLcSqnd3TwMpbREniXRPr-nq8c6ZIiZRi8iAA4b3JSNc_IP9-y2JVNB2EB3IaUH7MZ3bxdLhfxWDEg/s1600/15.png" /></a></div>
<div class="MsoListParagraphCxSpLast" style="line-height: normal; margin-bottom: 0cm;">
<span lang="EN-US"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
</span><br />
<div style="line-height: 115%;">
</div>
</span></div>
<span lang="EN-US">
</span>
<br />
<div class="MsoNormal" style="color: #002060; font-family: Cambria, serif; font-size: 12pt; line-height: 115%; margin: 0cm 0cm 12pt;">
<span lang="EN-US"><span style="color: purple; font-family: Times New Roman;">
</span></span></div>
<span lang="EN-US">
</span>
<div class="MsoNormal" style="margin: 0cm 0cm 12pt;">
<br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">That was the good scenario when everything went smoothly. However, you might get the following errors:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Error 1:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">[IM002][unixODBC][Driver Manager]Data source name not found,</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">no default driver specified</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">ISQL]ERROR: Could not SQLConnect</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">error usually comes if ODBCINI variable is not pointing to the correct</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">odbc.ini file. To fix this error try:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ cat $ODBCINI</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The command should display the contents of odbc.ini file with all settings we have configured on Step 4. If the file is there and the same error comes again, check the data source name. The parameter name for isql must be exactly the same as the section name in odbc.ini file.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Error 2:</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>./isql: error while loading shared libraries: libodbc.so.1: </b>cannot open shared object file: No such file or directory This error means that LD_LIBRARY_PATH is set wrong and the linker cannot find the main UnixODBC [Driver Manager] library libodbc.so. The solution is to export the directory containing libodbc.so ito LD_LIBRARY_PATH env variable</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">as shown at the beginning of Step 5.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The following command must not show failing dependencies:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ ldd isql</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">linux-vdso.so.1 => (0x00007fffe4ffc000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libodbc.so.1 => /home/dbs/app/unixodbc-2.2.14/lib/libodbc.so.1</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(0x00002ae5263e8000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libdl.so.2 => /lib64/libdl.so.2 (0x00000036b1c00000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libreadline.so.5 => /usr/lib64/libreadline.so.5 (0x00000036b1000000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libncurses.so.5 => /usr/lib64/libncurses.so.5 (0x00000036c4400000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libpthread.so.0 => /lib64/libpthread.so.0 (0x00000036b2000000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">libc.so.6 => /lib64/libc.so.6 (0x00000036b1400000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">/lib64/ld-linux-x86-64.so.2 (0x00000036b0c00000)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Error 3:</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>[S1000][unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user 'dbs'@'%' (using password: YES)</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>[ISQL]ERROR: Could not SQLConnect</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">In some cases this error message is not obvious. The user name and password might be correct and mysql command line might work perfectly with the user name and password specified in odbc.ini file. Check the database name in odbc.ini file (DATABASE parameter). As explained in the note on Step 4, the database names are case sensitive in MySQL and the connection might be rejected because the database does not exist or user has no privileges to access a database with this name.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Checking the connectivity from mysql command line is a good idea too.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| NOTE: mysql command line does not use ODBC, so it might work even if ODBC |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| fails. The idea of this check is to make sure we provided the correct |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| connection credentials to ODBC driver. |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">mysql command line should use EXACTLY the same user name, host, password, port and be executed on the same host with [Oracle] and [DG4ODBC]:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ mysql "user=mysql_user "password=****** --host=10.0.0.1 --port=3306</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Welcome to the MySQL monitor. Commands end with ; or \g.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Your MySQL connection id is 1</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Server version: 5.1.52-community-log MySQL Community Server (GPL)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL v2 license</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">mysql> show databases;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">+------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| Database |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">+------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| information_schema |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| entitytest |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| mysql |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| test |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| test2 |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">| test_db |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">+------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">6 rows in set (0.07 sec)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 6:</b></span><br />
<b style="color: purple; font-family: "Courier New", Courier, monospace;">Configuring tnsnames.ora.</b><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Add the following lines to $ORACLE_HOME/network/admin/tnsnames.ora</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">myodbc5 =</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(DESCRIPTION=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(ADDRESS=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(PROTOCOL=TCP) (HOST=localhost) (PORT=1521)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(CONNECT_DATA=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(SID=myodbc5))</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(HS=OK)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">)</span><br />
<br />
<b><span style="color: blue;"><span style="font-family: Courier New, Courier, monospace;">Exp:-- </span></span></b><br />
<b><span style="color: blue;"><span style="font-family: Courier New, Courier, monospace;">myodbc5=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test)(PORT=1521))(CONNECT_DATA=(SID=myodbc5))(HS=OK))</span></span></b><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"> </span><br />
<span style="clear: left; color: purple; float: left; font-family: Courier New, Courier, monospace; margin-bottom: 1em; margin-right: 1em;"></span></div>
<div class="MsoNormal" style="margin: 0cm 0cm 12pt;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<br />
<div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0pt;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 7:</b></span><br />
<span style="color: purple; font-family: 'Courier New', Courier, monospace;"><b>Configuring listener.ora</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Open $ORACLE_HOME/network/admin/listener.ora in a text editor, find</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SID_LIST_LISTENER definition and add a new entry for myodbc5:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SID_LIST_LISTENER=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(SID_LIST=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># Another entry in the list</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># (SID_DESC=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># (SID_NAME=sampleDSN)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># (ORACLE_HOME=/home/dbs/app/Ora/product/11.2.0/dbhome_1)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># (PROGRAM=dg4odbc)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># (ENVS=LD_LIBRARY_PATH=/home/dbs/app/unixodbc-2.2.14)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"># )</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(SID_DESC=</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(SID_NAME=myodbc5)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(ORACLE_HOME=/home/dbs/app/Ora/product/11.2.0/dbhome_1)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(PROGRAM=dg4odbc)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(ENVS=LD_LIBRARY_PATH=/home/dbs/app/unixodbc-2.2.14/lib:/home/dbs/app/Ora/product/11.2.0/dbhome_1/lib)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">We strongly recommend to add the LD_LIBRARY_PATH to the listener.ora file to avoid any conflicts with already existing ODBC driver managers.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The LD_LIBRARY_PATH must contain the fully qualified path to the $ORACLE_HOME/lib and also the library paths of the ODBC driver manager and the ODBC driver itself.</span></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 8:</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Configuring gateway init<sid>.ora file.</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">This file does not exist and you have to create it.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">In listener.ora, tnsnames.ora we use the name myodbc5 just for convenience,</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">but it can be literally anything. The init file (initmyodbc5.ora) is a</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">different story because HS_FDS_CONNECT_INFO is the DSN name in odbc.ini.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ vi $ORACLE_HOME/hs/admin/initmyodbc5.ora</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">HS_FDS_CONNECT_INFO=myodbc5 # Data source name in odbc.ini</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"># HS_FDS_TRACE_LEVEL=user</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">HS_FDS_SHAREABLE_NAME=/home/dbs/app/unixodbc-2.2.14/lib/libodbc.so</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">HS_FDS_SUPPORT_STATISTICS=FALSE</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">#</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"># ODBC env variables</span></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">set ODBCINI=/home/dbs/etc/odbc.ini</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">NOTE: HS_FDS_SHAREABLE_NAME must point to the [ODBC Driver Manager] library. It is an error to put there the [ODBC Driver] library. The [ODBC Driver] DSN is referenced in HS_FDS_CONNECT_INFO=myodbc5.</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| NOTE: UnixODBC [ODBC Driver Manager] might not support any character set |</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| used in Oracle, so the connection string will be corrupted. |</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| To avoid the connection string corruption it is recommended to set |</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| HS_LANGUAGE parameter. I the present case AMERICAN_AMERICA.WE8ISO8859P15 |</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">| worked ok |</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLsJmZRryBq8cqZZmjl6E0_VFfWOZgp09Ih4XAbOh_8dB_oimRB0nLACy45z8e-wkMsaRr-8Sd45iYaprgmU-_aGxO30UKmrr0jNsLbpc-DlDEcFE3nBcGBbMJQBSxhl7kFaBvyBtdn-w/s1600/18.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLsJmZRryBq8cqZZmjl6E0_VFfWOZgp09Ih4XAbOh_8dB_oimRB0nLACy45z8e-wkMsaRr-8Sd45iYaprgmU-_aGxO30UKmrr0jNsLbpc-DlDEcFE3nBcGBbMJQBSxhl7kFaBvyBtdn-w/s1600/18.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b><br /></b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 9</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Applying the settings in the configuration files.</b></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"> The listeners must be restarted in order to pick up the changes we just made into tnsnames.ora, listener.ora and initmyodbc5.ora:</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ lsnrctl stop</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ lsnrctl start</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">NOTE: The start status has to contain information about the service:</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">Services Summary...</span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">Service "myodbc5" has 1 instance(s).</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">Instance "myodbc5", status UNKNOWN, has 1 handler(s) for this service...</span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">The command completed successfully</span> </div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"><b><span style="color: blue;">EXP:- lsnrctl start listener_test</span></b></span></span><br />
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0pt;">
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 10 (Optional)</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Checking the service status:</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ lsnrctl status</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-MAY-2011 19:42:10</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Copyright (c) 1991, 2009, Oracle. All rights reserved.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">STATUS of the LISTENER</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">------------------------</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Alias LISTENER</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Start Date 06-MAY-2011 19:41:39</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Uptime 0 days 0 hr. 0 min. 30 sec</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Trace Level off</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Security ON: Local OS Authentication</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SNMP OFF</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Listener Parameter File /home/dbs/app/Ora/product/11.2.0/dbhome_1/network/admin/listener.ora</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Listener Log File /home/dbs/app/Ora/diag/tnslsnr/dbs-pc/listener/alert/log.xml</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Listening Endpoints Summary...</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Services Summary...</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Service "myodbc5" has 1 instance(s).</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Instance "myodbc5", status UNKNOWN, has 1 handler(s) for this service...</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The command completed successfully</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">The command prints the status of "myodbc5" service. UNKNOWN is not a problem</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">in this case because we have not tried using the service yet.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Pinging:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">$ tnsping myodbc5</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">06-MAY-2011 19:42:22</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Copyright (c) 1997, 2009, Oracle. All rights reserved.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Used parameter files:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Used TNSNAMES adapter to resolve the alias</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Attempting to contact (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=localhost)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">(PORT=1521)) (CONNECT_DATA= (SID=myodbc5)) (HS=OK))</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">OK (10 msec)</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">If the above commands report errors check thsnames.ora and listener.ora and set them as shown on Step 6-7.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Step 11:</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><b>Creating the database link and getting the data.</b></span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace;">Start sqlplus and type the following command (user and password are the same as in odbc.ini):</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> create public database link myodbc5 connect to "mysql_user" identified by</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">"********" using 'myodbc5';</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">Database link created.</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">SQL> select * from "tab1"@myodbc5;</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">id</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">----------</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">txt1</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">1</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">some text</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">2</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">some more text</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace;">DONE!</span><br />
<br />
<b><span style="color: blue;"><span style="font-family: Courier New, Courier, monospace;">Exp:-- </span><br /><span style="font-family: Courier New, Courier, monospace;">create public database link myodbc5 connect to "mysql_user" identified by "********" using 'myodbc5';</span></span></b><br />
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfOnAv6y4z6a8WX0f57JqDx8l8pu8t56cpEw4JI-FNK6cwRc46uQkE-bMrfn8ElcI0uY5NPoNngZmKy0baA641X6LqVKqano0GQ3cbdBDvlmdw4SKZZRHUYLEcCV0VCxg3jF51wNF_gOQ/s1600/21.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfOnAv6y4z6a8WX0f57JqDx8l8pu8t56cpEw4JI-FNK6cwRc46uQkE-bMrfn8ElcI0uY5NPoNngZmKy0baA641X6LqVKqano0GQ3cbdBDvlmdw4SKZZRHUYLEcCV0VCxg3jF51wNF_gOQ/s1600/21.png" /></a></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpLast" style="margin-bottom: 0pt;">
<span lang="EN-US" style="background-color: white;"><span style="color: purple; font-family: Courier New, Courier, monospace;"><br /></span></span></div>
<div class="MsoListParagraphCxSpFirst" style="margin-bottom: 0pt;">
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">NOTE: When selecting data from MySQL linked table it is recommended to enclose the table name into double quotes as "tab1" unless MySQL Server is set to ANSI_QUOTES |</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">+---------------------------------------------------------------------------+</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">Note: because MySQL is case sensitive, make sure to use double quotes on username and password. Otherwise, you may get following error:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span>
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">ERROR at line 1:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">ORA-28500: connection from ORACLE to a non-Oracle system returned this message:</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">[unixODBC][MySQL][ODBC 5.1 Driver]Access denied for user</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">'USER1'@'XXXX' (using password: YES) {HY000,NativeErr = 1045}</span><br />
<span style="color: purple; font-family: Courier New, Courier, monospace; font-size: x-small;">ORA-02063: preceding 2 lines from MYSQLMYDB</span><br />
<div>
<br /></div>
</div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/14172444781495120976noreply@blogger.com0