Solved

Schema Installation

Posted on 2011-03-12
9
401 Views
Last Modified: 2013-11-11
Hi all, i am an dba, but unfortunately got stuck with appsdba work, i have got to install all schemas on new servers, but the problem is there are system dba's who are assigned to do that work, i am not getting what is my part of work to do there, in my meeting they said is there are lot many schemas which are associated with different applications so, they said my work is mapping all schemas with those applications, and after that the system dbas will perform importing objects on to those schemas, hope i am clear if anybody understood this please try to help me out.


Thank a lot in advance
0
Comment
Question by:irukulla
  • 3
  • 2
9 Comments
 
LVL 4

Assisted Solution

by:pinkuray
pinkuray earned 166 total points
ID: 35120019
First find out what are the application are there on the server and list it out.
Second try to check each application associated with each schema.
Based on that you will get to know what are the application and associated schema details.

If you are able to check this then it will be easier to map all your application with object specific.


0
 
LVL 4

Accepted Solution

by:
subratabiswas earned 167 total points
ID: 35121029
Your question can be interpreted in many ways. My guess is, the DBAs found a large number of objects to transfer when they tried to migrate to new server. The DBAs are probably trying to identify the junk accumulated over period of time and bring over only the objects that are necessary.

A typical appsdba might maintain a document of different databases / schema created for different applications and there owners / developers. That document might also indicate if the application and corresponding database / schema are still active or defunct. If any such document is available, that can be used to prepare the list of schema required by the DBAs.

What will possibly happen is, the DBAs will bring over only those schema that you identify, and will plan to obsolete the remaining to free up resources. Since there might be gap between what is documented and what is happening in reality, it would be safer to finalize the list of objects (database / schema) after collecting feedback from the developers.

Hope this helps.
0
 
LVL 4

Expert Comment

by:pinkuray
ID: 35121727
Agreed with subratabiswas.

1st identify what are the applications and schemas related to it.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 167 total points
ID: 35127791
>>they said my work is mapping all schemas with those applications

You need to first get a list of all the users in the database.  Then get some idea of the types and number of objects those users own.

After that, you need to hit all the IT folks in the organization to see what applications are using those objects.

Another good thing to look at is the listener log files for as far back as you can go.  This should tell you what users are connecting and from where.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35172898
If you got the solution why are you deleting the question?  Did we not assist you
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35231759
I suggest an even split since I feel we all added value to the question:

http:#a35120019
http:#a35121029
http:#a35127791
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
ORA-12560: TNS:protocol adapter error 8 127
Concat multi row values of a field in oracle 6 63
exp/imp 25 73
Require data to appear on a single line 2 39
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question