QueryDB

insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure 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 the appropriate privilege at a higher label, ask the database administrator to regrant the privilege at the appropriate label.

Exporting questionable statistics Cause: Export was able to export statistics, but the statistics may not be useable. The statistics are questionable because one or more of the following happened during export: - A row error occurred, client character set or NCHARSET does not match with the server, a query clause was specified on export, - Only certain partitions or subpartitions were exported, or a fatal error occurred while processing a table. Action: To export non-questionable statistics, change the client character set or NCHARSET to match the server, export with no query clause, or export complete tables. If desired, import parameters can be supplied so that only non-questionable statistics will be imported, and all questionable statistics will be recalculated. or run the follwing query while exporting from database:- >exp username/psswd@orclservicename tables=table1,table2 file=c:/db_dump/db.dmp statistics=none; or >select VALUE 2 from nls_database_param

TNS:unable to connect to destination cause:-Invalid address specified or destination is not listening. This error can also occur because of underlying network or network transport problems. action:-Verify that the net service name you entered was correct. Verify that the ADDRESS portion of the connect descriptor which corresponds to the net service name is correct. Ensure that the destination process (for example the listener) is running at the remote node.

TNS:listener does not currently know of service requested in connect descriptor cause:-The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. action:-- Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services - Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener. - If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener. - Check for an e

ERROR: java.lang.SecurityException:: Unable to initialize SSLUtils: Configuration properties [security/sslConfig] are missing. solution:- check the username and password and repository path i.e, the file path