Re: Connection to Oracle 12c failing using cx_Oracle
Venky <[email protected]> Wed, 21 Jun 2017 22:05:35 +0530
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAFm3R6=m3pLU5GKYyUd6r+0Bn=FDB2wPqd8d_WgEWhGchM8QPg@mail.gmail.com> |
--===============7123674069563467158== Content-Type: multipart/alternative; boundary="001a1144cd1a33c84605527af534" --001a1144cd1a33c84605527af534 Content-Type: text/plain; charset="UTF-8" Thanks Anthony, Chris for the solution. On Wed, Jun 21, 2017 at 10:03 PM, Venky <[email protected]> wrote: > Hi Jakob, > > Tried but getting as invalid keyword. > > >>> import cx_Oracle > > >>> db = cx_Oracle.connect('sys','apporbit','67.220.186.115:15210/standby', > sysdba=True) > > Traceback (most recent call last): > > File "<stdin>", line 1, in <module> > > TypeError: 'sysdba' is an invalid keyword argument for this function > > > > Then tried as shown below with mode = cx_Oracle.SYSDBA and it worked. > > Thanks Jakob for giving the pointer. > > db = cx_Oracle.connect('sys','apporbit','67.220.186.115:15210/standby', > mode = cx_Oracle.SYSDBA) > > >>> db = cx_Oracle.connect('sys','apporbit','67.220.186.115:15210/standby', > mode = cx_Oracle.SYSDBA) > > >>> cursor = db.cursor() > > >>> cursor.execute('select sequence# from v$archived_log order by rownum > desc') > > <cx_Oracle.Cursor on <cx_Oracle.Connection to [email protected]:15210/ > standby>> > > > > ~ Venky > > On Wed, Jun 21, 2017 at 1:54 PM, Jakob Gurnhofer <[email protected]> wrote: > >> Hi Venky, >> >> >> have you tried connecting "as sysdba"? >> >> like: >> >> db = cx_Oracle.connect('sys','apporbit','67.220.186.115:15210/standby' >> <http://67.220.186.115:15210/standby%27>, *sysdba=True*) >> >> Jakob >> >> >> >> Am 21.06.2017 um 09:36 schrieb Venky: >> >> Hi Folks, >> >> I need your help wrt below issue faced while connecting to SQL*Plus: >> Release 12.1.0.2.0 Production on Wed Jun 21 06:50:43 2017 >> using the below cx_Oracle python module. >> >> pip show cx_Oracle >> >> Name: cx-Oracle >> >> Version: 5.3 >> >> Summary: Python interface to Oracle >> >> Home-page: https://oracle.github.io/python-cx_Oracle >> >> Author: Anthony Tuininga >> >> Author-email: [email protected] >> >> License: BSD License >> >> Location: /usr/lib64/python2.7/site-packages >> >> Requires: >> >> Below are the oracle instant client files used. >> >> 1. oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm >> 2. oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm >> 3. oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm >> >> >> >>> import cx_Oracle >> >> >>> db = cx_Oracle.connect('sys','apporbit','67.220.186.115:15210/ >> standby' <http://67.220.186.115:15210/standby%27>); >> >> Traceback (most recent call last): >> >> File "<stdin>", line 1, in <module> >> >> cx_Oracle.OperationalError: ORA-01033: ORACLE initialization or shutdown >> in progress >> >> Process ID: 0 >> >> Session ID: 0 Serial number: 0 >> >> >> >> - Master Oracle 12c is on the host 67.220.182.210 at port 1521 >> - Below is the Oracle 12c instance running on host 67.220.186.115 at >> port 15210 >> - This instance will always be in mounted mode since this instance is >> the result of the replication from master. >> - I can connect to it using below manual steps but can't using >> cx_Oracle as shown above. >> >> >> ps -aef| grep pmon >> >> oracle 106 1 0 06:47 ? 00:00:00 ora_pmon_standby >> >> root 334 231 0 07:34 ? 00:00:00 grep --color=auto pmon >> >> >> >> cat $ORACLE_HOME/network/admin/listener.ora >> >> LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)( >> HOST=0.0.0.0)(PORT=1521)))) >> >> SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=standby >> )(ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)(SID_ >> NAME=standby))) >> >> >> >> cat $ORACLE_HOME/network/admin/tnsnames.ora >> >> TESTDB=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HO >> ST=67.220.182.210)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TESTDB))) >> >> standby=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(H >> OST=0.0.0.0)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=standby))) >> >> >> >> lsnrctl status >> >> >> LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 21-JUN-2017 07:28:49 >> >> >> Copyright (c) 1991, 2014, Oracle. All rights reserved. >> >> >> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT= >> 1521))) >> >> STATUS of the LISTENER >> >> ------------------------ >> >> Alias LISTENER >> >> Version TNSLSNR for Linux: Version 12.1.0.2.0 - >> Production >> >> Start Date 21-JUN-2017 06:47:09 >> >> Uptime 0 days 0 hr. 41 min. 40 sec >> >> Trace Level off >> >> Security ON: Local OS Authentication >> >> SNMP OFF >> >> Listener Parameter File /u01/app/oracle/product/12.1.0 >> /dbhome_1/network/admin/listener.ora >> >> Listener Log File /u01/app/oracle/diag/tnslsnr/o >> racle-ldt1/listener/alert/log.xml >> >> Listening Endpoints Summary... >> >> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) >> >> Services Summary... >> >> Service "standby" has 2 instance(s). >> >> Instance "standby", status UNKNOWN, has 1 handler(s) for this service... >> >> Instance "standby", status READY, has 1 handler(s) for this service... >> >> The command completed successfully >> >> >> >> $export ORACLE_SID=standby; sqlplus sys/apporbit as sysdba >> >> >> SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 21 07:26:55 2017 >> >> >> Copyright (c) 1982, 2014, Oracle. All rights reserved. >> >> >> >> Connected to: >> >> Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit >> Production >> >> With the Partitioning, OLAP, Advanced Analytics and Real Application >> Testing options >> >> >> SQL> select status, database_status from v$instance; >> >> >> STATUS DATABASE_STATUS >> >> ------------ ----------------- >> >> MOUNTED ACTIVE >> >> >> SQL> select open_mode, database_role from v$database; >> >> >> OPEN_MODE DATABASE_ROLE >> >> -------------------- ---------------- >> >> MOUNTED PHYSICAL STANDBY >> >> >> >> ~Venky >> >> >> ------------------------------------------------------------------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> >> >> >> _______________________________________________ >> cx-oracle-users mailing listcx-oracle-users-5NWGOfrQmneRv+LV9MX5ugtCRVl27V+i0wdF1cv0I5s@public.gmane.org://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> >> -- >> Ing. Jakob Gurnhofer, [email protected]://gurn.at >> >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> cx-oracle-users mailing list >> cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org >> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users >> >> > > -- Hi ~Venky --001a1144cd1a33c84605527af534 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr">Thanks Anthony, Chris for the solution.<br><div class=3D"g= mail_extra"><br><div class=3D"gmail_quote">On Wed, Jun 21, 2017 at 10:03 PM= , Venky <span dir=3D"ltr"><<a href=3D"mailto:[email protected]" ta= rget=3D"_blank">[email protected]</a>></span> wrote:<br><blockquot= e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol= id;padding-left:1ex"><div dir=3D"ltr">Hi Jakob,<div><br></div><div>Tried bu= t getting as invalid keyword.=C2=A0</div><div><br></div><div><p style=3D"ma= rgin:0px;font-size:14px;line-height:normal;font-family:Courier;color:rgb(25= 5,240,165);background-color:rgb(19,119,62)"><span style=3D"font-variant-lig= atures:no-common-ligatures">>>> import cx_Oracle</span></p><p styl= e=3D"margin:0px;font-size:14px;line-height:normal;font-family:Courier;color= :rgb(255,240,165);background-color:rgb(19,119,62)"><span style=3D"font-vari= ant-ligatures:no-common-ligatures">>>> db =3D cx_Oracle.connect(&#= 39;sys','<wbr>apporbit','<a href=3D"http://67.220.186.115:1= 5210/standby" target=3D"_blank">67.220.186.115:<wbr>15210/standby</a>',= sysdba=3DTrue)</span></p><span class=3D""><p style=3D"margin:0px;font-size= :14px;line-height:normal;font-family:Courier;color:rgb(255,240,165);backgro= und-color:rgb(19,119,62)"><span style=3D"font-variant-ligatures:no-common-l= igatures">Traceback (most recent call last):</span></p><p style=3D"margin:0= px;font-size:14px;line-height:normal;font-family:Courier;color:rgb(255,240,= 165);background-color:rgb(19,119,62)"><span style=3D"font-variant-ligatures= :no-common-ligatures">=C2=A0 File "<stdin>", line 1, in <= ;module></span></p></span><p style=3D"margin:0px;font-size:14px;line-hei= ght:normal;font-family:Courier;color:rgb(255,240,165);background-color:rgb(= 19,119,62)"><span style=3D"font-variant-ligatures:no-common-ligatures">Type= Error: 'sysdba' is an invalid keyword argument for this function</s= pan></p><p style=3D"margin:0px;font-size:14px;line-height:normal;font-famil= y:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span sty= le=3D"font-variant-ligatures:no-common-ligatures"><br></span></p></div><div= ><br></div><div>Then tried as shown below with mode =3D cx_Oracle.SYSDBA an= d it worked.<span style=3D"font-family:NimbusMonL"><br></span></div><div><b= r></div><div>Thanks Jakob for giving the pointer.</div> =09 =09 =09 <div><br></div><div><p style=3D"margin:0px;font-size:14px;line-height:nor= mal;font-family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,= 62)"><span style=3D"font-variant-ligatures:no-common-ligatures">db =3D cx_O= racle.connect('sys','<wbr>apporbit','<a href=3D"http://= 67.220.186.115:15210/standby" target=3D"_blank">67.220.186.115:<wbr>15210/s= tandby</a>', mode =3D cx_Oracle.SYSDBA)</span></p><p style=3D"margin:0p= x;font-size:14px;line-height:normal;font-family:Courier;color:rgb(255,240,1= 65);background-color:rgb(19,119,62)"><span style=3D"font-variant-ligatures:= no-common-ligatures">>>> db =3D cx_Oracle.connect('sys',&#= 39;<wbr>apporbit','<a href=3D"http://67.220.186.115:15210/standby" = target=3D"_blank">67.220.186.115:<wbr>15210/standby</a>', mode =3D cx_O= racle.SYSDBA)</span></p><p style=3D"margin:0px;font-size:14px;line-height:n= ormal;font-family:Courier;color:rgb(255,240,165);background-color:rgb(19,11= 9,62)"><span style=3D"font-variant-ligatures:no-common-ligatures">>>&= gt; cursor =3D db.cursor()</span></p><p style=3D"margin:0px;font-size:14px;= line-height:normal;font-family:Courier;color:rgb(255,240,165);background-co= lor:rgb(19,119,62)"><span style=3D"font-variant-ligatures:no-common-ligatur= es">>>> cursor.execute('select sequence# from v$archived_log o= rder by rownum desc')</span></p><p style=3D"margin:0px;font-size:14px;l= ine-height:normal;font-family:Courier;color:rgb(255,240,165);background-col= or:rgb(19,119,62)"><span style=3D"font-variant-ligatures:no-common-ligature= s"> </span></p><p style=3D"margin:0px;font-size:14px;line-height:normal;font-fa= mily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span = style=3D"font-variant-ligatures:no-common-ligatures"><cx_Oracle.Cursor o= n <cx_Oracle.Connection to <a href=3D"http://[email protected]:15210/st= andby" target=3D"_blank">[email protected]:15210/<wbr>standby</a>>><= /span></p></div><span class=3D"HOEnZb"><font color=3D"#888888"><div><br></d= iv><div><br></div><div><br></div><div>~ Venky</div></font></span><div><div = class=3D"h5"><div><div><div class=3D"gmail_extra"><div class=3D"gmail_quote= "><br></div><div class=3D"gmail_quote">On Wed, Jun 21, 2017 at 1:54 PM, Jak= ob Gurnhofer <span dir=3D"ltr"><<a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a>></span> wrote:<br><blockquote class=3D"gma= il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-le= ft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"> =20 =20 =20 <div bgcolor=3D"#FFFFFF"> <p>Hi Venky,</p> <p><br> </p> <p>have you tried connecting "as sysdba"?</p> <p>like: <span style=3D"font-variant-ligatures:no-common-ligatures"><br= > </span></p> <p><tt><span style=3D"font-variant-ligatures:no-common-ligatures">db = =3D cx_Oracle.connect('sys','appor<wbr>bit','<a h= ref=3D"http://67.220.186.115:15210/standby%27" target=3D"_blank">67.220.186= .115:15210/<wbr>standby'</a>, <b>sysdba=3DTrue</b>)</span></tt></p> <br> Jakob<div><div class=3D"m_5763386960038510141gmail-h5"><br> <br> <br> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-cite-= prefix">Am 21.06.2017 um 09:36 schrieb Venky:<br> </div> </div></div><blockquote type=3D"cite"><div><div class=3D"m_576338696003= 8510141gmail-h5"> <div dir=3D"ltr"> <div>Hi Folks,<br> </div> <div><br> </div> <div>I need your help wrt below issue faced while connecting to=C2= =A0<span style=3D"color:rgb(255,240,165);font-family:Courier;font-size:14px= ;background-color:rgb(19,119,62)">SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 21 06:50:43 2017</span= ></div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature">using the below cx_Oracle python module.</div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">pip show cx_Oracle</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Name: cx-Oracle</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Version: 5.3</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Summary: Python interface to Oracle</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Home-page: <a href=3D"https://oracle.github.io/python-cx_Oracle" target= =3D"_blank">https://oracle.github.io/pytho<wbr>n-cx_Oracle</a></span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Author: Anthony Tuininga</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Author-email: <a href=3D"mailto:[email protected]" target=3D"_blan= k">[email protected]</a></span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">License: BSD License</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Location: /usr/lib64/python2.7/site-pack<wbr>ages</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Requires:=C2=A0</span><= /p> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures">B= elow are the oracle instant client files used.</span></div> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <ol> <li>oracle-instantclient12.2-basic<wbr>-12.2.0.1.0-1.x86_64.rpm= <br> </li> <li>oracle-instantclient12.2-devel<wbr>-12.2.0.1.0-1.x86_64.rpm= <br> </li> <li>oracle-instantclient12.2-sqlpl<wbr>us-12.2.0.1.0-1.x86_64.r= pm<br> </li> </ol> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">>>> import cx_Oracle</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">>>> db =3D cx_Oracle.connect('sys','appor<wbr>bit'= ;,'<a href=3D"http://67.220.186.115:15210/standby%27" target=3D"_blank"= >67.220.186.115:15210/<wbr>standby'</a>);</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Traceback (most recent call last):</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">=C2=A0 File "<stdin>", line 1, in <module></span></= p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">cx_Oracle.OperationalEr= ror: ORA-01033: ORACLE initialization or shutdown in progress</spa= n></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Process ID: 0</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Session ID: 0 Serial number: 0</span></p> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><br> </div> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <ul> <li>Master Oracle 12c is on the host 67.220.182.210 at port 1521<br> </li> <li>Below is the Oracle 12c instance running on host=C2=A067.220.186.115 at port 15210</li> <li>This instance will always be in mounted mode since this instance is the result of the replication from master.=C2=A0<= /li> <li>I can connect to it using below manual steps but can't using cx_Oracle as shown above.</li> </ul> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">ps -aef| grep pmon</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">oracle =C2=A0 =C2=A0 106 =C2=A0 =C2=A0 1=C2=A0 0 06:47 ?=C2=A0 =C2= =A0 =C2=A0 =C2=A0 00:00:00 ora_pmon_standby</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">root =C2=A0 =C2=A0 =C2=A0 334 =C2=A0 231=C2=A0 0 07:34 ?=C2=A0 =C2=A0 =C2= =A0 =C2=A0 00:00:00 grep --color=3Dauto pmon</span></p> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <div><span style=3D"font-variant-ligatures:no-common-ligatures"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">cat $ORACLE_HOME/network/admin/lis<wbr>tener.ora=C2=A0</span>= </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">LISTENER=3D(DESCRIP= TION=3D(ADDRESS<wbr>_LIST=3D(ADDRESS=3D(PROTOCOL=3Dtcp)(<wbr>HOST=3D0.0.0.0= )(PORT=3D1521))))</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">SID_LIST_LISTENER= =3D(SID_LIST=3D(S<wbr>ID_DESC=3D(GLOBAL_DBNAME=3Dstandby<wbr>)(ORACLE_HOME= =3D/u01/app/oracle/<wbr>product/12.1.0/dbhome_1)(SID_<wbr>NAME=3Dstandby)))= </span></p> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">cat $ORACLE_HOME/network/admin/tns<wbr>names.ora=C2=A0</span>= </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">TESTDB=3D(DESCRIPTI= ON=3D(ADDRESS_L<wbr>IST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HO<wbr>ST=3D67.220.18= 2.210)(PORT=3D1521))<wbr>)(CONNECT_DATA=3D(SERVICE_NAME=3D<wbr>TESTDB)))</s= pan></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">standby=3D(DESCRIPT= ION=3D(ADDRESS_<wbr>LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(H<wbr>OST=3D0.0.0.0)= (PORT=3D1521)))(CONN<wbr>ECT_DATA=3D(SERVICE_NAME=3Dstandby<wbr>)))</span><= /p> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> <div><span style=3D"font-variant-ligatures:no-common-ligatures"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">lsnrctl status=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-= height:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></s= pan><br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 21-JUN-2017 07:28:49</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-= height:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></s= pan><br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Copyright (c) 1991, 2014, Oracle.=C2=A0 All rights reserved.</span>= </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-= height:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></s= pan><br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCO<wbr>L=3Dtcp)(HOST=3D0.= 0.0.0)(PORT=3D<wbr>1521)))</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">STATUS of the LISTENER</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">-------------------= -----</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Alias =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 LISTENER</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Version =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 TNSLSNR for Linux: Version 12.1.0.2.0 - Production</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Start Date=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 21-JUN-2017 06:47:09</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Uptime=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 0 days 0 hr. 41 min. 40 sec</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Trace Level =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 of= f</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Security=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 O= N: Local OS Authentication</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">SNMP=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 OFF</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Listener Parameter File =C2=A0 /u01/app/oracle/product/12.1.0<wbr>/dbhome_1/network/admi= n/listen<wbr>er.ora</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Listener Log File =C2=A0 =C2=A0 =C2=A0 =C2=A0 /u01/app/oracle/diag/tnslsnr/o<wbr>racle-ldt1/listener/al= ert/log.<wbr>xml</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Listening Endpoints Summary...</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">=C2=A0 (DESCRIPTION=3D(ADDRESS=3D(PROTOCO<wbr>L=3Dtcp)(HOST=3D0.= 0.0.0)(PORT=3D<wbr>1521)))</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Services Summary...</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">Service "standby" has 2 instance(s).</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">=C2=A0 Instance "standby", status UNKNOWN, has 1 handl= er(s) for this service...</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">=C2=A0 Instance "standby", status READY, has 1 handler= (s) for this service...</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font= -family:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><sp= an style=3D"font-variant-ligatures:no-common-ligatures">The command completed successfully</span></p> <div><span style=3D"font-variant-ligatures:no-common-ligature= s"><br> </span></div> </span></div> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">$export ORACLE_SID=3Dstandby; sqlplus sys/apporbit as sysdba</span></= p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">SQL*Plus: Release 12.1.0.2.0 Production on Wed Jun 21 07:26:55 2017</sp= an></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Copyright (c) 1982, 2014, Oracle.=C2=A0 All rights reserved.</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Connected to:</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">SQL> select status, database_status from v$instance;</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">STATUS<span class=3D"m_= 5763386960038510141gmail-m_4539705022141292638gmail-Apple-tab-span" style= =3D"white-space:pre-wrap"> </span> =C2=A0 =C2=A0 DATABASE_STATUS</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">------------ -----------------</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">MOUNTED=C2=A0 =C2=A0 =C2=A0 ACTIVE</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">SQL> select open_mode, database_role from v$database;</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62);min-heig= ht:17px"><span style=3D"font-variant-ligatures:no-common-ligatures"></span>= <br> </p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">OPEN_MODE<span class=3D= "m_5763386960038510141gmail-m_4539705022141292638gmail-Apple-tab-span" styl= e=3D"white-space:pre-wrap"> </span> =C2=A0 =C2=A0 DATABASE_ROLE</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">-------------------- ----------------</span></p> <p style=3D"margin:0px;font-size:14px;line-height:normal;font-fam= ily:Courier;color:rgb(255,240,165);background-color:rgb(19,119,62)"><span s= tyle=3D"font-variant-ligatures:no-common-ligatures">MOUNTED=C2=A0<span clas= s=3D"m_5763386960038510141gmail-m_4539705022141292638gmail-Apple-tab-span" = style=3D"white-space:pre-wrap"> </span> =C2=A0 =C2=A0 PHYSICAL STANDBY</span></p> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"><br> </div> <div class=3D"m_5763386960038510141gmail-m_4539705022141292638gmail= _signature"> <div><span style=3D"font-variant-ligatures:no-common-ligatures"><= br> </span></div> ~Venky</div> </div> <br> <fieldset class=3D"m_5763386960038510141gmail-m_4539705022141292638mi= meAttachmentHeader"></fieldset> <br> </div></div><pre>------------------------------<wbr>-----------------= -------------<wbr>------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! <a class=3D"m_5763386960038510141gmail-m= _4539705022141292638moz-txt-link-freetext" href=3D"http://sdm.link/slashdot= " target=3D"_blank">http://sdm.link/slashdot</a></pre> <br> <fieldset class=3D"m_5763386960038510141gmail-m_4539705022141292638mi= meAttachmentHeader"></fieldset> <br> <pre>______________________________<wbr>_________________ cx-oracle-users mailing list <a class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-txt-link-ab= breviated" href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"= _blank">[email protected]<wbr>rge.net</a> <a class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-txt-link-fr= eetext" href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-user= s" target=3D"_blank">https://lists.sourceforge.net/<wbr>lists/listinfo/cx-o= racle-users</a><span class=3D"m_5763386960038510141gmail-HOEnZb"><font colo= r=3D"#888888"> </font></span></pre><span class=3D"m_5763386960038510141gmail-HOEnZb"><font= color=3D"#888888"> </font></span></blockquote><span class=3D"m_5763386960038510141gmail-HO= EnZb"><font color=3D"#888888"> <br> <pre class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-signa= ture" cols=3D"72">--=20 Ing. Jakob Gurnhofer, BSc. <a class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-txt-link-ab= breviated" href=3D"mailto:[email protected]" target=3D"_blank">[email protected]</a= > <a class=3D"m_5763386960038510141gmail-m_4539705022141292638moz-txt-link-fr= eetext" href=3D"https://gurn.at" target=3D"_blank">https://gurn.at</a> </pre> </font></span></div> <br>------------------------------<wbr>------------------------------<wbr>-= -----------------<br> Check out the vibrant tech community on one of the world's most<br> engaging tech sites, Slashdot.org! <a href=3D"http://sdm.link/slashdot" rel= =3D"noreferrer" target=3D"_blank">http://sdm.link/slashdot</a><br>_________= _____________________<wbr>_________________<br> cx-oracle-users mailing list<br> <a href=3D"mailto:cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org" target=3D"_blank">= [email protected]<wbr>rge.net</a><br> <a href=3D"https://lists.sourceforge.net/lists/listinfo/cx-oracle-users" re= l=3D"noreferrer" target=3D"_blank">https://lists.sourceforge.net/<wbr>lists= /listinfo/cx-oracle-users</a><br> <br></blockquote></div><br><br> </div></div></div></div></div></div> </blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class= =3D"gmail_signature" data-smartmail=3D"gmail_signature">Hi<br><br><br>~Venk= y</div> </div></div> --001a1144cd1a33c84605527af534-- --===============7123674069563467158== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot --===============7123674069563467158== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users --===============7123674069563467158==--