oracle - SQL*Net configuration - spurious IP -



oracle - SQL*Net configuration - spurious IP -

i can't connect oracle 12 database through sql*net

tracing backwards tnsping result follows:

tnsping devpdb tns ping utility linux: version 12.1.0.2.0 - production on 08-oct-2014 05:28:55 copyright (c) 1997, 2014, oracle. rights reserved. used parameter files: used hostname adapter resolve alias attempting contact (description=(connect_data=(service_name=))(address=(protocol=tcp)(host=xx.xxx.xxx.xx)(port=1521)))

the host ip unresolvable computer. don't know getting it's not nat address of host or of router, it's @ to the lowest degree 30 hops away per ping.

tnsnames.ora:

# generated oracle configuration tools. devdb = (description = (address = (protocol = tcp)(host = tts-poweredge-t105)(port = 1521)) (connect_data = (server = dedicated) (service_name = devdb) ) ) devpdb = (description = (address = (protocol = tcp)(host = tts-poweredge-t105)(port = 1521)) (connect_data = (sid = devpdb) (server = dedicated) (service_name = devpdb) ) ) diamondpdb = (description = (address = (protocol = tcp)(host = tts-poweredge-t105)(port = 1521)) (connect_data = (sid = diamondpdb) (server = dedicated) (service_name = diamondpdb) ) )

the /etc/hosts is:

127.0.0.1 localhost 192.168.1.2 tts-poweredge-t105 # next lines desirable ipv6 capable hosts ::1 ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters

ping works:

ping tts-poweredge-t105 ping tts-poweredge-t105 (192.168.1.2) 56(84) bytes of data. 64 bytes tts-poweredge-t105 (192.168.1.2): icmp_seq=1 ttl=64 time=0.054 ms

my sqlnet.ora:

# sqlnet.ora network configuration file: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora # generated oracle configuration tools. names.directory_path= (tnsnames, onames, hostname)

when alter tnsnames.ora follows:

# tnsnames.ora network configuration file: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora # generated oracle configuration tools. devdb = (description = (address = (protocol = tcp)(host = tts-poweredge-t105)(port = 1521)) (connect_data = (server = dedicated) (service_name = devdb) ) ) devpdb = (description = (address = (protocol = tcp)(host = tts-poweredge-t105)(port = 1521)) (connect_data = (sid = devpdb) (server = dedicated) (service_name = devpdb) ) ) diamondpdb = (description = (address = (protocol = tcp)(host = 192.168.1.2)(port = 1521)) (connect_data = (sid = diamondpdb) (server = dedicated) (service_name = diamondpdb) ) ) wtf = (description = (address = (protocol = tcp)(host = 192.168.1.2)(port = 1521)) (connect_data = (sid = wtf) (server = dedicated) (service_name = wtf) ) )

i this:

tnsping wtf tns ping utility linux: version 12.1.0.2.0 - production on 08-oct-2014 08:21:15 copyright (c) 1997, 2014, oracle. rights reserved. used parameter files: tns-03505: failed resolve name

my environment:

ld_library_path=/u01/app/oracle/product/12.1.0/dbhome_1/lib oracle_sid=devdb oracle_base=/u01/app/oracle oracle_home=/u01/app/oracle/product/12.1.0/dbhome_1

i can remove tnsnames.ora file , original message not beingness used.

i tried changing sqlnet.ora to:

# sqlnet.ora network configuration file: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora # generated oracle configuration tools. #names.directory_path= (tnsnames, onames, hostname) names.directory_path= (hostname,tnsnames, onames)

and makes no difference

so whatever hostname adapter or how configured seems problem. note "used parameter files:" empty

i exported tns_admin

export tns_admin=/home/u01/app/oracle/product/12.1.0/dbhome_1/network/admin

but still no parameter files beingness used. have read permissions on file.

i suspect has sqlnet.ora file, have run out of ideas.

oracle tnsnames

Comments

Post a Comment

Popular posts from this blog

Delphi change the assembly code of a running process -

Delphi change the assembly code of a running process - i'm trying alter address 00741fa5 has push test.009e721c . alter push test.009e71c8 . procedure callback; asm force $9e71c8 end; procedure tform2.btn1click(sender: tobject); var ppid :dword; pprocess : cardinal; begin getwindowthreadprocessid(findwindow(nil,pchar('test')), @ppid); pprocess := openprocess(process_all_access, false, ppid); injectasm(pprocess, $741fa5, 10, integer(@callback), 0); end; here injectasm function (with error checking) function injectasm(process: longword; injectaddress, injectsize, codeaddress, codesize : integer): pointer; var csize, rsize : integer; replaced : array of byte; jmp : array [0..4] of byte; jmpaddress : integer; nopv : byte; : integer; nbr: ulong_ptr; begin //injectsize must equal or greater 5, because need space our //(far) jmp wwxxyyzz instruction //if there's no space, inject in place of few instructions if injectsize ...
Read more

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) -

json - Hibernate and Jackson (java.lang.IllegalStateException: Cannot call sendError() after the response has been committed) - hello have problem hibernate , jackson. have 2 pojos @entity @table(name = "users") public class user implements serializable { static final long serialversionuid = 4235637833262722256l; @id @generatedvalue private int id; @column(name = "creation_date") private date creationdate; @column(name = "first_name") private string firstname; @column(name = "last_name") private string lastname; @version @column(name = "version") private int version; @column(name = "e_mail") private string email; @column(name = "enabled") private boolean enabled; @column(name = "login") private string login; @column(name = "password") private string password; @jsonmanagedreference("role") @onetomany(mappedby = "user", cascade = cascadetype.all,fetch = fetchtyp...
Read more

C++ 11 "class" keyword -

C++ 11 "class" keyword - i've started using c++ 11 little bit more , have few questions on special uses of class keyword. know it's used declare class, there's 2 instances have seen don't understand: method<class t>(); and class class_name *var; why precede typename keyword class in first example, , keyword pointer in sec example? that known elaborated type specifier , necessary when class name "shadowed" or "hidden" , need explicit. class t { }; // love of god don't t t; t t2; if compiler smart, give these warnings: main.cpp:15:5: error: must utilize 'class' tag refer type 't' in scope t t2; ^ class main.cpp:14:7: note: class 't' hidden non-type declaration of 't' here t t; ^ if class not defined, deed forwards declaration. for example: template <typename t> void method() { using type = typename t::value_type; } method...
Read more