Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 414
  • Last Modified:

Collecting oracle server configuration

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
crazywolf2010
Asked:
crazywolf2010
  • 4
  • 4
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
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
 
crazywolf2010Author Commented:
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
 
DavidSenior Oracle Database AdministratorCommented:
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
slightwv (䄆 Netminder) Commented:
>>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
 
crazywolf2010Author Commented:
Hi,
I do not have access thru ssh or scp on server. I just have SQL client side access.

Thanks
0
 
slightwv (䄆 Netminder) Commented:
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
 
DavidSenior Oracle Database AdministratorCommented:
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
 
crazywolf2010Author Commented:
Hi
I finally have rda installed on the box thru ssh access. Took too long to get an access.
0
 
DavidSenior Oracle Database AdministratorCommented:
Good news, then.  I look forward to learning if this approach resolves your expectations.
0
 
crazywolf2010Author Commented:
No one supplied the info I needed
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

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