Home » RDBMS Server » Networking and Gateways » Net Configuration Assistant not running as normal user (Oracle database, 10g rel2, Windows server 2003)
Net Configuration Assistant not running as normal user [message #431352] Tue, 17 November 2009 00:15 Go to next message
saleh_binmasood
Messages: 30
Registered: October 2009
Member
Sir,

We have an application which connects indirectly to Oracle Database Server.

So i am establishing the connection through, installation of the Oracle Client Software.
Then i am trying to open "NetConfigurationAssistant" to make connection through "LocalNetServiceNameConfiguration".

But on any machine the normal user is unable to open "NetConfigurationAssistant" but as the member of administrator group of that machine is able to run "NetConfigurationAssistant".

Any Suggestions ?
Re: Net Configuration Assistant not running as normal user [message #431362 is a reply to message #431352] Tue, 17 November 2009 02:46 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Ask your admin to give you the permissions as you (normal user) dont have....! Its Not related to Net Configuration Assistant it should be in windows forum ..

Sriram Smile
Re: Net Configuration Assistant not running as normal user [message #431365 is a reply to message #431362] Tue, 17 November 2009 03:07 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Another option would be (if the admin doesn't want the "global" tnsnames.ora changed) to create an additional tnsnames.ora file, and put in in the directory the program is launched from.

For example, here I have a tnsnames.ora in c:\test_dir, that is only active when I'm inside c:\test_dir\

C:\>tnsping test_tns

TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 17-NOV-20
09 10:01:00

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:
C:\programme\ora92\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\>cd test_dir

C:\test_dir>tnsping test_tns

TNS Ping Utility for 32-bit Windows: Version 9.2.0.8.0 - Production on 17-NOV-20
09 10:01:12

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:
C:\programme\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.1.1.20)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test)))
OK (0 msec)

c:\test_dir>type tnsnames.ora
tnsnames.ora


test_tns =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.20)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = test)
    )
  )
c:\test_dir>
Re: Net Configuration Assistant not running as normal user [message #434055 is a reply to message #431352] Mon, 07 December 2009 01:25 Go to previous message
nets_edge@cox.net
Messages: 17
Registered: December 2009
Location: home, Arizona
Junior Member
Quote:
Any Suggestions ?


Run the NetConfigurationAssistant on any single box that you do have privileges to run it on.

Then, copy the sqlnet.ora and tnsnames.ora file to the remaining clients, placing them in %ORACLE_HOME%\network\admin directory.

Nets Edge
Previous Topic: Oracle behind a firewall
Next Topic: TNS-12537: TNS:connection closed
Goto Forum:
  


Current Time: Fri Mar 29 03:15:14 CDT 2024