Oracle Database Administration

ORA-02019: Connection description for remote database not found

I had 7 databases in production environment. I wanted to create a testing environment but I only wanted 2 databases in that so I took the cold back up of two databases and did the cloning. Now my application is able to connect to the database but I am getting an error on some of the operations...

Database

How do I create an oracle database?

Link Between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE in Release12

I'm in an upgrade project from 11.5.7 to 12.0.4, the client has some major customizations using the existing link between MTL_MATERIAL_TRANSACTIONS and GL_INTERFACE like the reference21 in GL_INTERFACE = batch_id in MTL_MATERIAL_TRANSACTIONS and the reference23 in GL_INERFACE = TRANSACTION_ID in...

oracle - automated testing tools

what automated tools can be used to test oracle forms application and oracle database backend

SQL query ORACLE report "Active Users"

I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?

Urgent Help

I have some doubts related to oracle database..... I am in ECC 5 implementation project (OS: Windows, DB: Oracle) My Question....... After Installing ECC 5 the default database size is around 50 GB, some 300 GB HDD is allotted to database , the client is saying to utilize the remaining 250 GB...