Server Administration :: How To Compare DB Parameters

Mar 19, 2013

I recently discovered that there was a difference in my QA and prod environments, which I have since rectified.

SQL> select DBMS_STATS.GET_PARAM('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
--------------------------------------------------------------------------------
FOR ALL COLUMNS SIZE 1
SQL> select DBMS_STATS.GET_PARAM('METHOD_OPT') from dual;
DBMS_STATS.GET_PARAM('METHOD_OPT')
--------------------------------------------------------------------------------
FOR ALL COLUMNS SIZE AUTO

I found a script that allows me to compare values from v$parameter

set pagesize 1000
col name format a28
col local format a20
col remote format a20
select local.name, local.value local,
remote.value remote,

[code]....

Is there other SQL code or another methode out there that would find differences in my DB's such as the method_opt setting, which don't appear in v$parameter.

View 4 Replies


ADVERTISEMENT

Server Administration :: Modified Objects - Compare Two Users On Different Databases

Oct 2, 2012

I want to compare two users on different databases, actaully there are two users one in user a on database a and another user b on database b they have same tables, and everytime when a table or object is created on user a (database a) i will take the table name ,procedure or any other object from user_objects based on ddl_created date and then i need to recreate the same on user b on database b, is there a way to find out tables which are not only created but also i need to check whether if there is any column added or any change in procedure or any other objects.Is there a way to generate the scripts based on list of objects selected from user_objects.
all i want is.

a)Find out the list of objects added along with creation scripts
b)find out the list of objects modified along with creation scripts.

View 2 Replies View Related

Server Administration :: Create View With Parameters?

Oct 26, 2011

I created a view with parameters l_id and l_name, how can i find them in oracle view?

Create Table tb_test
(
Id Number,
Name Varchar2(64)
);

Create Or Replace View vw_tb_test(l_id,l_name)
As
Select Id,Name From tb_test;

View 3 Replies View Related

Server Administration :: Size_clause Of Parameters Method_opt

Sep 15, 2011

What is the function by specified the size_clause of parameters method_opt?

dbms_stats.gather_table_stats
method_opt := FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause]
FOR COLUMNS [size_clause]
column|attribute [size_clause]
[,column|attribute [size_clause] ... ]

size_clause := SIZE [integer | auto | skewonly | repeat],
where integer is between 1 and 254

View 16 Replies View Related

Server Administration :: Can't Change The Parameters Resource_manager_plan

Jul 11, 2011

I can not change the parameters RESOURCE_MANAGER_PLAN, at first, I set the parameters to DAYTIME,but when I restart my db,the parameters hold old values named MAXCAP_PLAN. Why?

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

[code]....

View 5 Replies View Related

Server Administration :: Change SGA_TARGET And SGA_POOL_SIZE Parameters

Aug 31, 2010

When I was going through the Enterprise Manager Grid Control, I found an error due to which I looked at the trace file and it said:

ORA-07445: exception encountered: core dump ACCESS_VIOLATION unable_to_trans_pc PC:0x7C81BD02 ADDR:0x49444E49 UNABLE_TO_READ]

I searched and found that it has something to do with the SGA parameters. I saw that the shared_pool_size and the sga_target paramters are set to 0...Also there are certain SQLs hanging at some point. I thought I should change the above mentioned parameters.

My question now is, can I use the Alter System statements from the SQL Plus to change these parameters, and do they change immediately or do I need to reboot the Oracle instance for those changes to take effect? I would like to do:

alter system set sga_target=400m;
alter system set shared_pool_size=200m;

would these work and take effect immediately?

View 5 Replies View Related

Server Administration :: Displaying Session Level Parameters

Aug 9, 2013

A way to show session parameters? Such as

CONSTRAINTS
USE_STORED_OUTLINES
ROW ARCHIVE VISIBILITY
CURRENT_SCHEMA

I can detect the CURRENT_SCHEMA with a query against the user env context, but I can't find any of the others there. Could there be an issue with these values being stored in PGA, and therefore not visible though any regular views? I did find an article that showed a query against an x$ data structure which showed something for different settings of CONSTRAINTS, but I can't find it again.

View 4 Replies View Related

Server Administration :: ORA-01078 / Failure In Processing System Parameters

Feb 25, 2010

I had newly installed oracle 11g database, for testing & learning purpose.

Don't know wht happen to it after successfull installation , I am not able to start database.

Following error is appearing, how to resolve this.

Ora-01078:failure in processing system parameters

I can do only login to idle instance.

View 9 Replies View Related

Server Administration :: Create SPFILE - Failure In Processing System Parameters?

Oct 11, 2004

I have a small problem with creating the SPFILE,

These are the commands i had issued :-

1. startup nomount
2. create SPFILE from PFILE ;

Then i got an error :-

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:ORACLEORA92DATABASEINITORCL.ORA'

Ever since this happened i am unable to connect to ORACLE under any schema !

I get the following error : -

SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Warning: You are no longer connected to ORACLE.

WHY DOES THIS HAPPEN AND HOW CAN I OVERCOME IT ?

View 8 Replies View Related

Server Administration :: Database To Startup With PFile - Failure In Processing System Parameters

Feb 8, 2011

I successfully created a DB manually with PFILE.

I want the DB to startup with SPFILE at next login.So i fired the below command.

CREATE SPFILE='path/SPFILEPRAGAT.ORA' FROM PFILE='path/file.ora'.

But it shows the error as below:

ORA-01078: failure in processing system parameters
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (os 123) The filename, directory name,or volume label syntax is incorrect.

View 20 Replies View Related

RAC & Failsafe :: ORACLE Server Failover Parameters In Windows Server Machine.config File

Jan 17, 2012

working on setting up connection between a Windows 2008 server and a pair of Oracle 11g DBs in a RAC Cluster. One Database (let's say DatabaseA) is in one data center, and the other (DatabaseB) is an a secondary, backup database. The RAC Cluster is all set up, working fine, etc. However, I Need to set up the machine.config file on my Windows Server, to go only connect to DatabaseA, unless it fails, in which case, we want it to connect to DatabaseB. Think we could do this if the host app server was Linux/Unix, but it is windows, and I just don't have the background as to the parameters to set up in the machine.config file. They are similar, but different, and we want a very specific behavior (use DatabaseA, unless fails, then DatabaseB). Application is .NET 4.0 app.

View 6 Replies View Related

Server Utilities :: Parameters Of Exp And Imp Command

May 31, 2004

What is the parameters of exp and imp command?

View 4 Replies View Related

Server Utilities :: Data Pump Job Parameters

Sep 2, 2011

How (or having a script) to get, in PL/SQL, the parameters that have been given on a Data Pump command (export or import): mode (easy), tables/schemas list, exclude/include values and so on?

10.2 (preferred) or 11.2 as you want.

View 2 Replies View Related

Server Utilities :: Conflicting In Parameters Of Export

Sep 18, 2010

I had specified the below:

Q1: Can we combine the 2 parameters together (owner and tables)? If not, then what is the way to specify it....

Exp scott/tiger owner=scott tables=(T1)
Error msg is: conflicting modes specified.

Q2: what is the privilege need for exporting other schema's tables?

Q3: what is the use of export table with index and many, but without ROWS?

View 1 Replies View Related

Server Utilities :: Indexes Parameters Original Impdp

Sep 25, 2011

As we know,there is a parameters named indexes of orignal imp,it use to generate create index ddl,Is there a parameter in impdp compare to it?

View 6 Replies View Related

Memory Management - Choose Parameters For Server With A Fixed RAM?

Apr 18, 2011

the erelationship between sga_max_size,sga_targt,shared_pool_size,pga_aggregate_target and the server memory.

In short how shud i choose the above parameters for a server with a fixed RAM.

View 1 Replies View Related

Server Utilities :: KUP-00554 / Error Encountered While Parsing Access Parameters

Dec 2, 2010

I receive the following error message

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "binary_double,

[code].....

when I select count(*) on the external table created below.

SQL> CREATE TABLE cac_500_load
2 (
3 EMAILADDRESS VARCHAR2(80),
4 FIRSTNAME VARCHAR2(60),
5 LASTNAME VARCHAR2(60),
6 STREETADDRESS VARCHAR2(100),

[code].....

Here is the db version info:

SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT

View 12 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Server Utilities :: Compare Column Name Of Schema With Other Schema's Column Name

Dec 15, 2012

I have a standard schema named ABC and 600 more schema's over there in my database.They all has same table name and column name as on standard schema. But in some tables number of columns varying. So I need to compare all schemas with my standard schemas column name. I create below script but it is generating output in infinite loop.

SET SERVEROUTPUT ON
DECLARE
V_COLS VARCHAR2(20);

BEGIN
FOR CUR_CCD IN(SELECT DISTINCT TABLE_NAME,OWNER FROM ALL_TABLES
WHERE OWNER LIKE 'CCD_MAIN'
[code]....

View 16 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.

"The image file D: is Valid, but is for a machine type other than the current machine."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Server Administration :: Server Installation Gets Abruptly Ended For Client Get TNS Errors

Jan 11, 2011

after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>

after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.

View 2 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Server Administration :: While Creating Index ORA-00603 / ORACLE Server Session Terminated By Fatal Error

Jul 26, 2010

While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".

We have the space in tablespaces and also in the file systesm.

View 13 Replies View Related

Server Administration :: Create Multiple Database In Single Server

Apr 18, 2011

I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.

View 1 Replies View Related

Server Administration :: Access To Database Server Machine Login?

Apr 30, 2012

database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?

View 9 Replies View Related

Server Administration :: Oracle 11g R2 Installation On Windows 2008 64 Bit Server

Apr 19, 2011

I want to install Oracle 11g R2 in windows 2008 64 bit server. How can I know whether my server is ready to install Oracle ie is all components are available in server or any patch is to be applied etc.

View 3 Replies View Related

Server Administration :: How To Connect Oracle Client To Remote Server DB

Jun 29, 2013

I'm trying to connect a oracle client application on the client machine to a remote oracle server on the server machine but i get a connection fail.

On the server machine I configured oracle server in the following way:

Installed oracle server. Created a database "DB_Test" with the database configuration assistant Created a LISTNER with the Oracle NET Manager with the following parameter:

Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521 Created "dbtest" service with the Oracle NET Manager with with the following parameter:
Service Name: "dbtest" Protocol: TCP/IP HOST: server pc hostname (ENZOVAIO) or server machine address ip (192.168.0.71) in the network lan Port Number: 1521

All services on the server machine are running and I opened port number (1521) in the router. On the client machine I installed SQL PLUS and SQL Developer.

With SQL Plus as by the official documentation I have entered the following command:

CONNECT username/password@[//]host[:port][/service_name]. In my case is:
CONNECT SYSTEM/oracledb@//ENZOVAIO:1521/testdb.

With SQL Developer I have entered the same parameter.

But with both SQLPlus and SQL Developer the connection fails.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved