Ask Anantha

This is a brand new error message with Oracle 10g.   Here is what Oracle has to say: All instances supporting the service requested by the client reported that they were blocking the new connections. This condition may be temporary, such as at instance startup.   And here are what Oracle advices as action: Attempt the connection again. If error persists, then contact the administrator to check the status of the instances.   And what we have to say: This error usually crops up when you are starting up your database, or just started up your database. This is actually a known problem with Oracle 10g where a SHUTDOWN IMMEDIATE is followed by a STARTUP MOUNT. If this where the case it would be solved by issuing a SHUTDOWN to the database and then again issuing a STARTUP. This should solve the problem.   However there might be some scenarios where this error might occur even if you are starting your database after a restart of the ope...

This error occurs when the session initiating to connect to Oracle database fails due to domain mismatch between oracle database server and a client trying to connect.   What Oracle says is the cause: The authentication service failed to retrieve the credentials of a user. What Oracle says to be done to resolve: Enable tracing to determine the exact error.   Now more about this error This error occurs usually in a windows domain where the domain of the server where database is installed is different from that of the client machine trying to connect, to prove this correct try to connect to database from the server machine.   If the connection is obtained from within the server you can be sure that the cause is different domain.   Now if you are in a development or test environment you can bypass this security measure by changing the sqlnet.ora file (The file is available in ORACLE_HOME /network/adm...

Test Your PL/SQL Knowledge This puzzler has come from Steven Feuerstein for the month of January 2008. So I thought to reproduce the puzzler with its answer: Answer the following multiple choice question to see how well you understand the nuances of PL/SQL: Which of the following do not help you execute multiple PL/SQL programs simultaneously? Oracle Advanced Queuing DBMS_JOB DBMS_SQL Pipelined Functions Now for the answer scroll down: . . . . . . . . . . . . . . . . . Answer: (c) DBMS_SQL . Both Advanced Queuing and DBMS_JOB provide mechanisms for communicating with other sessions, thereby allowing you to "kick off" multiple PL/SQL programs at the same time. Pipelined functions are a special type of table functions: functions that can be called in the FROM clause of a query. If you include the PARALLEL_ENABLE clause in the header of a pipelined function, then the Parallel Query engine will be abl...

Are you running out of space in the file system where database files (data files) are installed? Try out this tip in order to move some of your data files from one drive to another and update the datafile location in your database. The operating system: Oracle Enterprise Linux The Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 In our environment we have installed our database's files (data files) in /oracle/oradata/mydb location. The drive is getting up to 99% of utilization. Now we will move the system01.dbf from the above mentioned location to a new location in /oracle/hdb1/oradata/mydb location. /oracle/hdb1 is mounted from /dev/hdb1. The drive is nearly empty, that's why I chose it. Now for the real moving part, we will perform the following steps: Login to SQL* Plus and shutdown the database Logout from SQL* Plus and move the files from the source directory to destination directory. Login to SQL* Plus as /nolo...

I have never tried this kind of reporting before. Mail from a friend prompted me that I should start creating this report and also publish an article which shows a step-by-step process of creating one. So here is the list that we are going to achieve: Create a DTD file Create an XML file Create a report based on the two files created. First step is to create a DTD file. Our XML file contains details of all database environments in use by a team. The following is our DTD file. Save the following contents as c:\database.dtd:                          , OracleSID                          , DatabaseDomain                          , Administrator+                          , DatabaseAttributes       ...