We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now


ORA-10131 Insufficient Privileges

qmtech asked
Medium Priority
Last Modified: 2010-05-18
I am trying to get an Oracle 10.1.0 DB running on a new machine for testing purposes.  I have installed Oracle and copied over the various directories (/network/admin, dbs) from the old server.  When I try to login via sqlplus, I get an Insufficient Privilege error.  This is not an issue related to the dba group as I am able to login via sqlplus to another db on the server.  What am I missing here?


Watch Question

what user you are using? Does this user have "create session" privilege?
You can log in as sys dba to see privileges of this user and grant some common privilege to it.


The problem was solved by creating a static db registration in listener.ora.  Thanks for your comments, case closed :)
PAQed with points refunded (500)

Community Support Moderator

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.