?
Solved

Collecting oracle server configuration

Posted on 2013-02-06
10
Medium Priority
?
412 Views
Last Modified: 2013-03-22
Hi,
I need to collect as much information as I can for my oracle servers/databases.

The Oracle RDA will work well but I do not have access to download RDA. I can go thru Oracle CSI support but will take weeks to gain access.

Does anyone have list of SQL queries to collect same configuration information? I do have access to database and sudo access to server.

Thanks
0
Comment
Question by:crazywolf2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
  • 2
10 Comments
 
LVL 23

Expert Comment

by:David
ID: 38862189
Wolf, what do you really want to accomplish, beyond accumulating a whole lot of impressive data?  The "... as much information as I can..." is vague.  You then turn around and say your goal is "some configuration information".  Well, what do you need that the init.ora file doesn't have?

We can hand over many, many queries, but not necessary to replicate what RDA does.

Secondly,   if your supervisor has authorized you to use Oracle Support, then this CSI "taking weeks" is halderdash.  One signs into MOS, using your existing Oracle SSO account or a newly created one.  A window or two later, you enter the authorized CSI number.  An email goes IMMEDIATELY to the DBA or DBAs who administer access.  Conceivably, your supervisor should have emailed the/those DBAs with a note of authorization.  Otherwise, the ONLY reason they have to take weeks and weeks is that someone is being dishonest -- or in rare circumstances, the staff pooled into a winning lottery ticket and they've all quit.
0
 

Author Comment

by:crazywolf2010
ID: 38875682
Hi,
I am looking for rda like SQL collection of queries which will list database server build information to replicate at other site.

Thanks
0
 
LVL 23

Expert Comment

by:David
ID: 38876255
Wolf, to replicate the database, all the relevant information is maintained in the database control file.  The DBA can dump the contents to an editable trace file, then cut and paste the CREATE DATABASE information into SQL on the new host.  This is explained in clear detail, one good source is http://oracleinstance.blogspot.com/2010/09/re-create-lost-controlfile.html.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38876280
>>is maintained in the database control file

I would like to add that you would also need the spfile (or pfile) to get the parameters.

What additional information do you think you need that is not in those two locations?

I've never generated an RDA report so I'm not sure what all is in there.
0
 

Author Comment

by:crazywolf2010
ID: 38876282
Hi,
I do not have access thru ssh or scp on server. I just have SQL client side access.

Thanks
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38876319
The suggestion was to have the DBA dump the controlfile.  The DBA should also be able to provide you with the spfile.

That said:
spfile contents can be found in v$parameter (look for isdefault='FALSE' for the ones set by the dba).

The datafiles and tempfiles can be selected from dba_data_files and dba_temp_files.

What else are you looking for?
0
 
LVL 23

Expert Comment

by:David
ID: 38876415
Wolf, I am becoming confused, which frankly is not difficult.  Since you do not have the administrator access, can you explain for us why you need to have configuration data?  Better still, can you explain to your DBAs why he/she/they should provide this to you?
0
 

Accepted Solution

by:
crazywolf2010 earned 0 total points
ID: 38930055
Hi
I finally have rda installed on the box thru ssh access. Took too long to get an access.
0
 
LVL 23

Expert Comment

by:David
ID: 38930283
Good news, then.  I look forward to learning if this approach resolves your expectations.
0
 

Author Closing Comment

by:crazywolf2010
ID: 39010322
No one supplied the info I needed
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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 setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses

770 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