?
Solved

ORA-10131 Insufficient Privileges

Posted on 2006-04-05
5
Medium Priority
?
2,111 Views
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?

Thanks,

Rich
0
Comment
Question by:qmtech
  • 2
4 Comments
 
LVL 19

Expert Comment

by:actonwang
ID: 16388528
what user you are using? Does this user have "create session" privilege?
0
 
LVL 19

Expert Comment

by:actonwang
ID: 16388532
You can log in as sys dba to see privileges of this user and grant some common privilege to it.
0
 

Author Comment

by:qmtech
ID: 16390823
The problem was solved by creating a static db registration in listener.ora.  Thanks for your comments, case closed :)
0
 
LVL 1

Accepted Solution

by:
DarthMod earned 0 total points
ID: 17479257
PAQed with points refunded (500)

DarthMod
Community Support Moderator
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question