java.sql.SQLException: ORA-00942: table or view does not exist

I encountered ORA-00942 error while I was trying to connect a database schema/user using Oracle JDBC/thin client/Apache Tomcat/JSP/Java.

It got fixed after I granted the SELECT ANY DICTIONARY privilege to that user.
SQL> grant SELECT ANY DICTIONARY to mytest;

Grant succeeded.

Now test your connection after granting the privilege, It shouldwork without issue.

Cheers.

Starting AdminServer Without Username & Password Prompt in WebLogic Server 10.3

To bypass the username password prompt when starting domain Admin Server or any of its managed ones, you can do the following steps:

1. Navigate to the current Domain Admin server directory that usually should be under the following location:
<FMW_HOME>/user_projects/domains/<Domain_Name>/server/AdminServer/

2. Create the “security” directory under the following location :

$mkdir <FMW_HOME>/user_projects/domains/<Domain_Name>/servers/AdminServer/security
3. Use any text editor to create a file called boot.properties in the security directory recently created in the previous step, and enter the following two lines in this file:
username=weblogic
password=password
After you edit the file, start up the server as soon as possible in order for the entries to be encrypted.
This is applicable to WLS 10.3 to 11.1.1.2 or later versions.