OraFAQ Forum: Networking and Gateways » Net Configuration Assistant not running as normal user

Home » RDBMS Server » Networking and Gateways » Net Configuration Assistant not running as normal user (Oracle database, 10g rel2, Windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Net Configuration Assistant not running as normal user [message #431352]

Tue, 17 November 2009 00:15

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 ?

Report message to a moderator

Re: Net Configuration Assistant not running as normal user [message #431362 is a reply to message #431352]

Tue, 17 November 2009 02:46

ramoradba
Messages: 2457
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

Report message to a moderator

Re: Net Configuration Assistant not running as normal user [message #431365 is a reply to message #431362]

Tue, 17 November 2009 03:07

ThomasG
Messages: 3212
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>

Report message to a moderator

Re: Net Configuration Assistant not running as normal user [message #434055 is a reply to message #431352]

Mon, 07 December 2009 01:25

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

Report message to a moderator

Previous Topic:	Oracle behind a firewall
Next Topic:	TNS-12537: TNS:connection closed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 11:46:05 CST 2024