<div>
what user you are using? Does this user have &quot;create session&quot; privilege?
</div>


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

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


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

<div>
The problem was solved by creating a static db registration in listener.ora. &nbsp;Thanks for your comments, case closed :)
</div>


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

<div>
<div class="content wysiwyg-content">
I am trying to get an Oracle 10.1.0 DB running on a new machine for testing purposes. &nbsp;I have installed Oracle and copied over the various directories (/network/admin, dbs) from the old server. &nbsp;When I try to login via sqlplus, I get an Insufficient Privilege error. &nbsp;This is not an issue related to the dba group as I am able to login via sqlplus to another db on the server. &nbsp;What am I missing here?<br />
<br />
Thanks,<br />
<br />
Rich
</div>
</div>


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

ORA-10131 Insufficient Privileges

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.