| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle newbie... ORA-01031 and ORA-12154
"Heiko Pliefke" <heiko.pliefke_NOSPAM__at_erl9.siemens.de> wrote:
>Hi NG!
>
>I'm an oracle newbie and had installed oracle reports server 6i, the oracle
>8.1.7.0 personal edition, followed by an Apache, TomCat and Sun JRE. Then I
>imported an database-dump.
>
>This is all for a java-application running in a browser with an apache
>web-server and tomcat-servlet-engine on the localhost!
>
>
>Now I have a problem with the oracle database engine in the background.
>Since thursday i get TNS-errors - if i start the DBA, i'll get the
>ORA-01031: insufficient privileges!
>
>And if i start the DB-Import, I'll get the ORA-12154: TNS:could not resolve
>service name!
>
>I solved the second error, because the programmer changed the SQLNET.ORA
>(NAMES.DEFAULT_DOMAIN entry missed). But now I cannot start the application.
>The JRE runs into Exception Errors!
>
>
>I don't know, what else changed since thursday, but i want to start solving
>this problem at the oracle DBA!
>Does anyone know, why i get this ORA-01031 error? And how to solve it??
>
>Any help would be greatly appreciated! Thx a lot,
>
>regards,
>
>H. Pliefke
>
This is the error:
Cause:An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to UPDATE a table with only SELECT privileges, if attempting to CONNECT INTERNAL, or attempting to install a database without the necessary operating system privileges.
When Trusted ORACLE is configured in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action:Ask the database administrator to perform the operation or grant the required privileges.
For Trusted ORACLE users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to re-grant the privilege at the appropriate label.
hth,
( btw, http://technet.oracle.com/doc/oracle8i_816/server.816/a76999/toc.htm is a very comprehensive site for 8.1 errors - the base site( http://technet.oracle.com) may be a site you should keep as a shortcut..registration is needed but it is free and will prove to be a very valuable reference point for most things Oracle..) Received on Tue Dec 10 2002 - 10:16:49 CST
 |
 |