• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Schema Installation

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
irukulla
Asked:
irukulla
  • 3
  • 2
3 Solutions
 
pinkurayCommented:
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
 
subratabiswasCommented:
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
 
pinkurayCommented:
Agreed with subratabiswas.

1st identify what are the applications and schemas related to it.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
slightwv (䄆 Netminder) Commented:
>>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
 
slightwv (䄆 Netminder) Commented:
If you got the solution why are you deleting the question?  Did we not assist you
0
 
slightwv (䄆 Netminder) Commented:
I suggest an even split since I feel we all added value to the question:

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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now