Netca can't find tnsnames.ora file event though it exists.
Hi,
I'm a newbie in Oracle and need some help of an experienced guy :)
I've installed Oracle 11.2R3 on Linux and currently try to run netca assistant to create an alias.
In the UI everything looks OK, but the tnsnames.ora is not created.
Looking at the logs I saw that it is looking the file under : /network/admin without $ORACLE_HOME (which is well defined) at its beginning.
Log output is below.
Can somebody help me?
Thank you all for your help :)
Log output
netcaXXXlog :
Oracle Net Services Configuration:
ServiceAliasException: Could not save Service Alias: TNS-04415: File i/o error
caused by: java.io.FileNotFoundException: /network/admin/tnsnames.ora (No such file or directory)
Default local naming configuration complete.
Created net service name: db67
Oracle Net Services configuration successful. The exit code is 0
traceXXXlog
[main] [ 2013-03-13 18:48:12.227 IST ] [NetCALogger.initTrace:203] Oracle Net Configuration Assistant: 1303136PM4811
[main] [ 2013-03-13 18:48:12.227 IST ] [NetCALogger.initTrace:204] Oracle Home: /opt/oracle11/product/11.2.0.3/db_1
[main] [ 2013-03-13 18:48:12.227 IST ] [NetCALogger.initTrace:205] Oracle Base: /opt/oracle11/product
[main] [ 2013-03-13 18:48:12.228 IST ] [NetCALogger.initTrace:206] Oracle Home Name: OraDb11g_home2
[main] [ 2013-03-13 18:48:12.264 IST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2013-03-13 18:48:12.264 IST ] [HAUtils.<init>:239] oui location /opt/oracle11/oraInventory/ContentsXML
[main] [ 2013-03-13 18:48:12.276 IST ] [Version.isPre:528] version to be checked 11.2.0.3.0 major version to check against10
[main] [ 2013-03-13 18:48:12.276 IST ] [Version.isPre:539] isPre.java: Returning FALSE
[main] [ 2013-03-13 18:48:12.280 IST ] [OCR.loadLibrary:312]
Inside constructor of OCR
[main] [ 2013-03-13 18:48:12.295 IST ] [OCR.loadLibrary:320] Going to load the ocr library
[main] [ 2013-03-13 18:48:12.295 IST ] [Library.load:188] library.load
[main] [ 2013-03-13 18:48:12.296 IST ] [sPlatform.isHybrid:66] osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2013-03-13 18:48:12.296 IST ] [sPlatform.isHybrid:66] osName=Linux osArch=amd64 JVM=64 rc=false
[main] [ 2013-03-13 18:48:12.296 IST ] [Library.load:264] Loading library /opt/oracle11/product/11.2.0.3/db_1/lib/libsrvmocr11.so
[main] [ 2013-03-13 18:48:12.298 IST ] [OCR.loadLibrary:322] loaded ocr libraries
[main] [ 2013-03-13 18:48:12.298 IST ] [OCR.isCluster:952] Calling OCRNative for isCluster()
[main] [ 2013-03-13 18:48:12.300 IST ] [OCR.isCluster:956] OCR Result status = true
[main] [ 2013-03-13 18:48:12.301 IST ] [OCR.isCluster:968] Bolean result = false
[main] [ 2013-03-13 18:48:12.303 IST ] [CmdlineArgs.<init>:114] Initializing variables array...
[main] [ 2013-03-13 18:48:12.304 IST ] [CmdlineArgs.<init>:120] Initializing NetProperties...
[main] [ 2013-03-13 18:48:12.304 IST ] [CmdlineArgs.initArgs:137] Initializing command line arguments...
[main] [ 2013-03-13 18:48:12.305 IST ] [CmdlineArgs.setOraArgs:242] Setting Oracle arguments...
[main] [ 2013-03-13 18:48:12.305 IST ] [CmdlineArgs.setOraArgs:246] Passed Oracle Home = NO_VALUE
[main] [ 2013-03-13 18:48:12.305 IST ] [CmdlineArgs.setOraArgs:249] Read Oracle Home = /opt/oracle11/product/11.2.0.3/db_1
[main] [ 2013-03-13 18:48:12.305 IST ] [CmdlineArgs.setOraArgs:252] Read Oracle Home ID =
[main] [ 2013-03-13 18:48:12.306 IST ] [CmdlineArgs.setOraArgs:255] Read Oracle Home Name = null
[main] [ 2013-03-13 18:48:12.306 IST ] [CmdlineArgs.setOraArgs:263] Setting Oracle Home = /opt/oracle11/product/11.2.0.3/db_1
[main] [ 2013-03-13 18:48:12.306 IST ] [InitialSetup.configureOPS:4539] Cluster mode is OFF
[main] [ 2013-03-13 18:48:12.307 IST ] [InitialSetup.<init>:4058] TNS_ADMIN is: /network/admin
[main] [ 2013-03-13 18:48:12.310 IST ] [OPSUtil.getHomeVersion:446] Inside getHomeVersion...
[main] [ 2013-03-13 18:48:12.310 IST ] [OPSUtil.getHomeVersion:447] oracleHome = /opt/oracle11/product/11.2.0.3/db_1
[main] [ 2013-03-13 18:48:12.310 IST ] [OPSUtil.getHomeVersion:451] oracle.sysman.assistants.util.OracleHome Object = /opt/oracle11/product/11.2.0.3/db_1
[main] [ 2013-03-13 18:48:12.310 IST ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: null
[main] [ 2013-03-13 18:48:12.313 IST ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
[main] [ 2013-03-13 18:48:12.313 IST ] [OracleHome.getVersion:908] Homeinfo /opt/oracle11/product/11.2.0.3/db_1,2
[main] [ 2013-03-13 18:48:12.733 IST ] [OracleHome.getVersion:936] OracleHome.server.getVersion Version: 11.2.0.3.0
[main] [ 2013-03-13 18:48:12.733 IST ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
[main] [ 2013-03-13 18:48:12.733 IST ] [OPSUtil.getHomeVersion:452] returning oracleHome Version = 11.2.0.3.0
[main] [ 2013-03-13 18:48:12.733 IST ] [OracleHome.getVersion:889] OracleHome.getVersion called. Current Version: 11.2.0.3.0
[main] [ 2013-03-13 18:48:12.734 IST ] [OracleHome.getVersion:957] Current Version From Inventory: 11.2.0.3.0
[main] [ 2013-03-13 18:48:12.734 IST ] [InitialSetup.<init>:4071] Admin location is: /network/admin
[main] [ 2013-03-13 18:48:12.767 IST ] [ConfigureProfile.setProfileParam:136] Setting ADR_BASE: /opt/oracle11/product
Edited by: user2366127 on Mar 14, 2013 12:26 AM