If you are testing or working with the Oracle Enterprise Manager, and you are hitting the error-message "Connection to host as user Administrator failed. Bad SQL_SCRIPT at - line 227." when trying to define a backup, your Configuration for the Database has an error. This error means that a file or script in the configured directory can't be found.

The reason is that the database has a wrong not existent oracle-home defined you can check it if you go in the Oracle-Enterprise-Manager Console to "Targets" and choose the Tab "Databases" there choose your Database and press the button "configure". You will see that there is a wrong directory defined. If it can not be changed for any reasons a workaround would be to copy the Oracle home to the directory that the EM expects or define a link to this directory.

Yesterday I posted an article about failsafe and forgot to tell you that it does NOT just take care of the Oracle Databases, it can also take care and failover your Oracle Application Server and you Oracle Agents for your Enterprise Manager.

Take a look at the Product-Infos.

Oracle Failsafe is a mostly unknown Oracle Product.  I am working with this product since a short period of time, and must say it is a perfect and cheap High-Availability Solution for Oracle-Database.

 failsafe

"How cheap is it?"
Hmmm it costs NOTHING Money mouth you are allowed to use it if you have an oracle database. Of course, it costs you Microsoft-Licenses (Microsoft Enterprise Server) but no additional Oracle licenses.

"Do i need additional Database Licenses the same way i use the Oracle-RAC (Real Application Cluster)"

No, There is no additional License necessary because there is always just one Database active, read more about it in the Oracle Software Investment Guide.

"How does it work?"

Failsafe is a peace of software that takes care of your Oracle Database on a Microsoft Cluster. If one Database-Server goes down for any reason (fire, maintenance etc.) the database gets switched on an other server (called "node" in a clustered environment).

"How long does this switching take?" 

 It takes below an minute, we measured between 20 and 30 seconds (the listener and the database gets restarted).

 

Here a screenshot of how it looks like:

 33treeview

 

 

 

 

 

 

 

 

 

 

 

 

 

 In this example (from the manual) you can see the Cluster FS-150 and two nodes (servers) FS-151 and FS-152.

Hee you can get more information about it:

The Failsafe-Manual 

More Product-Infos 

 

Getting REP-56055 "Exceed max connection allowed" means check why so many connections occured at the same time, if it is normal to your environment (printing a lot of reports at 01:00 etc.) you can change following report-parameters in "...conf/rwserver.install"

<connection maxConnect="20" idleTimeOut="15"> 

set maxConnect to an appropriate value for your environment.Laughing

We have a very nice Java-Application at our side, and wanted to speed up the performance with the OracleDataSource (before we were working with Standard JDBC).

oracle.jdbc.pool.OracleDataSourceSo we tested a lot and the performance was slightly better in the test-environment than before.After that we went to production with it.... and the phones began to rang, the performance was BAD BAD BAD Cry

After 3 hours of analyzing of our sourcecode we had the solution:

                        Caching is not enabled by default  (suprise surprise... by Oracle)

After adding  additionals lines

        <jdbc-connection-pool datasource-classname= "oracle.jdbc.pool.OracleDataSource" ...>
        <property name="ImplicitCachingEnabled" value="true"/>
        <property name="MaxStatements" value="190"/>
        </jdbc-connection-pool>

We had an incredible speed up! 

The application is now about 10 times faster than before using this DataSource.  If it is possible in any case use this Datasource!

 


I was testing around with Oracle on Windows (2003) and got "insufficient disk space" when cloning a database.
The problem is in a perl-script (db_common.pl) of the agent, that checks the disk-space and uses an old windows-function to determine how much is left.
The solution is to install a newer client (downloadable at OTN choose the "Mass Agent Deployment").


if you are using the servlet you have to add the parameter "distribution" and "destination".

An example:

http://abc.def.com:8888/reports/rwservlet?report=c:\myreports\testreport.rdf&userid=scott/This email address is being protected from spambots. You need JavaScript enabled to view it.&destination=c:\temp\test.xml&distribute=yes

If you are starting it in the reports-builder just choose "Distribute" from the File-Menu.
The "distribution" functionality is a great feature since Reports 9.i
It enables you to send mails of the reports to different recipients, printers change the subject of the
mail, split the generated file by grouping (f.e. departments).

There are two ways to use "the" distribution. The first is to use the built-in property in the Report-builder.

distribution functionality in the reports-builder

The easier way, but within there you cannot use all features. For an exact list of the features you should take
a look at the documentation for your report-version at
http://www.oracle.com/technology/documentation/reports.html
choose the "Oracle Reports Building Reports" document.

The second-way is to use an xml-file and pass this file in the url.
Here you can download an example for such an file:

distexample.xml


!!! Don't forget the "destination" tag, the server needs them in the documentation they are not in the examples...
Acer N35

After the service of my Acer N35 (connector was broken) the builtin GPS was not working. So i brought it back to Acer and they changed the antenna. I got it back and ... it was not working again.... the answer on the support-line was i shall bring it to them.

After consulting the Internet (RTFM) and a friend of mine the solution was to set the clock. After the standard-Reset the clock was reset to xx.xx.2004 and GPS needs to know the correct date and time to determine the correct sateliltes.....

A terminal-file in Forms is like a key-configuration-file in other applications. In Client-Server Mode it was set by environment or registry-variables. In Webforms you have the possibility to add it to your servlet-parameters (edit some files...) or you can put it in the formsweb.cfg the easier way.

Here a example:

[sepwin]
separateFrame=True
lookandfeel=Generic
otherparams=term=C:\oracle\FRHome_1\forms\fmrpcweb.res

 



If you are running on 10G and you get "ORA-00257 ORA-16020 Archiver Stuck" then you should look at the size of your flashback-area and increase it. Most of the documentation you find about this errors is about, that the disk is full, but nobody mentioned, that there is a new feature called "flashback" in 10G and that this area also can be full.


Resize the flashback-area with for example:

alter system set db_recovery_file_dest_size = 4000000000;


If you are using the datapump (expdp or impdp etc.) and you get the following errors:

ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid

There is no directory defined. You have to define it on the server.
Choose a user with the rights to create an directory, start sqlplus and enter following
command:

create directory data_pump_dir as '\exphd\datapump';

for windows...

create directory data_pump_dir as 'x:\exportdrive\datapump';

Be sure, that the directory exists on the os before you define it in the database!