ORA-10131 Insufficient Privileges

Posted on 2006-04-05
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?


Question by:qmtech
    LVL 19

    Expert Comment

    what user you are using? Does this user have "create session" privilege?
    LVL 19

    Expert Comment

    You can log in as sys dba to see privileges of this user and grant some common privilege to it.

    Author Comment

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

    Accepted Solution

    PAQed with points refunded (500)

    Community Support Moderator

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now