Oracle uses NETCA error

Use Xshell to connect to Oracle database server in win7 system, configure monitoring to use NETCA error

[Email protected] ~]$ NETCA Oracle Net Services Configuration: Error:null Check the trace file for details:/opt/oracle/cfgtoollogs/netca/trace_oradb11g_home1-1609063pm3137.log Oracle Net Services configuration failed. The exit code is 1 [Email protected] ~]$ Tail/opt/oracle/cfgtoollogs/netca/trace_oradb11g_home1-1609063pm3137.log [Main] [2016-09-06 15:31:38.782 CST]  [oraclehome.getversion:936] OracleHome.server.getVersion version:11.2.0.3.0 [Main] [2016-09-06 15:31:38.783 CST]  [oraclehome.getversion:957] Current Version from inventory:11.2.0.3.0 [Main] [2016-09-06 15:31:38.783 CST] [opsutil.gethomeversion:452] returning oraclehome Version = 11.2.0.3.0 [Main] [2016-09-06 15:31:38.788 CST]  [oraclehome.getversion:889]  Oraclehome.getversion called. Current version:11.2.0.3.0 [Main] [2016-09-06 15:31:38.789 CST]  [oraclehome.getversion:957] Current Version from inventory:11.2.0.3.0 [Main] [2016-09-06 15:31:38.789 CST]  [initialsetup.<init>:4071] Admin location is:/opt/oracle/11g/network/admin [Main] [2016-09-06 15:31:38.877 CST]  [configureprofile.setprofileparam:136] Setting adr_base:/opt/oracle Java.lang.NullPointerException At oracle.ewt.lwawt.bufferedapplet.<init> (Unknown Source) At Oracle.net.ca.netca.<init> (netca.java:443) At Oracle.net.ca.NetCA.main (netca.java:429)

This is due to the Win7 unable to pull the server through the Xshell GUI, execute the following three commands can be

Switch to an Oracle user and execute the following command

[[email protected] ~]$ export display=192.168.20.100: 0//192.168.20.100 is the address of the Win7, not the IP address of the server, remember

[Email protected] ~]$ Xhost +

Access control disabled, clients can connect from the any host//proof setting is successful

[Email protected] ~]$ NETCA

Oracle Net Services Configuration://This table name appears in the graphical interface

This article is from the "Dong Yonggang blog" blog, make sure to keep this source http://dongyonggang.blog.51cto.com/9784442/1846904

Oracle uses NETCA error