Oracle Listener mess -

-

being newbie oracle 12c messed network setup while modifying memory_target setting, weird know happened somehow.

the sid=oradb2 today listened on 1538 of host oracle12c.mydomain.com nicely. not. , don't know how port 1539 came picture. hope can me.

here $oracle_home/network/admin/listener.ora file:

listener1 =   (description_list =     (description =       (address = (protocol = tcp)(host = oracle12c.mydomain.com)(port = 1538))     )   )  listener =   (description_list =     (description =       (address = (protocol = tcp)(host = oracle12c.mydomain.com)(port = 1539))       (address = (protocol = ipc)(key = extproc1521))     )   )

here $oracle_home/network/admin/tnsnames.ora file

oradb2 =    (description =     (address = (protocol = tcp)(host = oracle12c.omilia.com)(port = 1539))     (connect_data = (server = dedicated) (service_name = oradb2))   ) listener_oradb2 = (address = (protocol = tcp)(host = oracle12c.omilia.com)(port = 1538)) listener_oradb1 = (address = (protocol = tcp)(host = oracle12c.omilia.com)(port = 1538))

now contacting oradb2 sid via jdbc on port 1539 gives me ora-12505 error, , port 1538 not listening.

tnsping oradb2 gives 

attempting contact (description = (address = (protocol = tcp)(host = oracle12c.mydomain.com)(port = 1539)) (connect_data = (server = dedicated) (service_name = oradb2))) ok (10 msec)

the /home/oracle/app/oracle/admin/oradb2/scripts/init.ora file contains line

local_listener=oradb2

add (sid = oradb2) connect_data block in oradb2 tns entry:

your listener entry should this:

oradb2 =     (description_list =       (description =         (address_list =            (address =                (protocol = tcp)               (host = oracle12c.mydomain.com)               (port = 1539)             )          )       )       (connect_data =          (sid = oradb2)       )     )

and in tnsnames.ora put this:

oradb2 =    (description =     (address =         (protocol = tcp)        (host = oracle12c.omilia.com)        (port = 1539)     )     (connect_data =         (sid = oradb2)     )   )

you can make port whatever want here. make sure make same in both listener , tnsnames entry.


Comments

Post a Comment

Popular posts from this blog

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array(
Read more

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub
Read more

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since
Read more