Connect to Oracle DB in Windows 7

50 pts.
Tags:
Oracle 10g
Oracle Database 10g
Windows 7
I installed Oracle 10g client on Windows 7 Pro with no install errors. However, I had to add the user of the machine I am configuring to the local Administrator group for my app that uses Oracle db to be able to connect to the database. I don't want this user to be an admin though. I tried Power User, but did not connect with those privs. I even granted the user full control on the Oracle home folder with no avail.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I would say somehow it does have to do with local security since as soon as I added the user to the admin group oracle connected fine.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    What's the error you get when trying to connect ? Have you tried to connect from Sql*Plus (not from your application) ?
    69,175 pointsBadges:
    report
  • OracleSpatial
    Unless I am logged in as a local admin SQLPlus just closes when I try to log in to the db, no error or anything...just closes. I set the compatability to XP SP3 for SQLPlus with same result. When I try my app that connects to bd, I don't get an error as with SQLPlus. I also set the compatability to XP SP3 for that app.
    50 pointsBadges:
    report
  • carlosdl
    Being an administrator is definitely not an Oracle requirement. I installed the 10g R2 client software on a win 7 ultimate machine yesterday, and was able to connect to the database with standard users without any configuration change to the file system security settings. Please let us know if you find the solution.
    69,175 pointsBadges:
    report
  • carlosdl
    Have you taken a look at the sqlnet log file to see if it offers some useful information ?
    69,175 pointsBadges:
    report
  • OracleSpatial
    No sqlnet.log in client, bin, or network folders. Do I need to turn logging on?
    50 pointsBadges:
    report
  • OracleSpatial
    If I need to turn logging on, please help me by describing how to do so.
    50 pointsBadges:
    report
  • carlosdl
    It should be in client\bin, but the user needs to have modify/write permissions on that folder, otherwise the file is not created. Also, it will only log errors when trying to connect to a db that is defined in your tnsnames.ora file. Also, I would check if the TNS_ADMIN environment variable is set, as it could be being set with different values depending on the groups the user accounts belong to, by a GPO, for example.
    69,175 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following