Server Administration :: Differences In Versions According To Init-parameter Compatible

Dec 15, 2010

How oracle deals with the setting of init.ora parameter compatible.

e.g. we have
DB Version=10.2.0.4
compatible=10.2.0

what is the possible leak for us ? Is there any description about the features changed in 10.2 up to 10.2.0.4 in all steps - so that we can check out which functions we do not have.

View 3 Replies


ADVERTISEMENT

Server Administration :: Oracle Export Import Utility Different Versions?

May 10, 2012

We are migratingfrom [IBM P5 - AIX 5.3 - Oracle DB 10.2.0.1 64bit]to [IBM P7 - AIX 6.1 - Oracle DB 10.2.0.5 64bit]

The new database is already up and running, our next step now is the following:
1. Create Tablespaces (done)
2. Export the Database from P5
3. Import the dump to P7.

We have this following options:

I. Use a Windows XP workstation 32bit with Oracle 10.2.0.1 Database software to export from P5, then import the dump to P7. (Export/Import Utility 10.2.0.1 Windows 32bit)
II. Use the Export Utility of the P7 (10.2.0.5 AIX 64bit) to do the export and import.
III. Use the Export Utility of P5 (10.2.0.1 AIX 64bit) then use the Import Utility of P7 (10.2.0.5 AIX 64bit)

BTW, our colleague tried to do the following:
A. Use Windows - Export Utility 10.1.0.2.0 - 32bit to make a dump of our database (Oracle 10.2.0.1.0 AIX 64bit)
B. Use Windows - Import Utility 10.1.0.2.0 - 32bit to import the dump file from step A to our new database (Oracle 10.2.0.1.0 AIX 64bit)

But after issuing imp system/password@NEWDB file=(a.dmp, b.dmp... c.dmp) full=y ignore=y statistics=none

The import seems to hang here...importing SYSTEM's objects into SYSTEM

View 5 Replies View Related

Server Administration :: Oratab File In Window Versions Of Oracle 11g Xe?

Oct 10, 2011

is there a oratab file in window versions of oracle 11g xe?I found out that, oratab is:

associate with ORACLE_SID, ORACLE_HOME value, and you can input parameter like:

orcl:/opt/oracle/product/10.2.0/db_1:Y

to allow the datebase to be started when the server reboot.I am thinking for window versions, they are using 'SERVICES' right? That's why no oratab files?

View 1 Replies View Related

11gRel2 DBCA - Using Compatible Parameter 10.2.0.3.0 Results In ORA-00201

Aug 16, 2012

Following is the scenario:

1. Oracle DB Binaries: 11.2.0.2.2
2. Using dbca to create General Purpose Database and then modify initialization parameter "COMPATIBLE from 11.2.0.0.0 to 10.2.0.3.0" in the "All Initialization Parameters" window.

So, when I finally start installing database, I get following error during the install:

ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.2.0.3.0
ORA-00202: control file: '/u01/app/oracle/cfgtoollogs/dbca/infpp1/tempControl.clt'

IGNORE OR ABORT...

Now you might ask why i am doing this. Actually I want to install fresh 11grel2. database with lower compatible parameter. IMPORT DP custom schemas into this database making sure compatible is set to 10.2.0.3.0. Then run database with such settings for a week and finally change compatible parameter to 11.2.0.0.0

Any thoughts where i am going wrong? as the default template seems not accepting what i am interested to do.

View 7 Replies View Related

Oracle 11g R1 / 10g R2 - Two Different Versions In Same Server

Feb 15, 2012

I had installed Oracle 11g R1 on windows system where Oracle 10g R2 also installed. As I required both versions parallel on same server, both are installed on different Oracle homes.

Configured listener.ora & tnsnames.ora files on 11g (path) with 10g details also in same file, checked the listener status, its �READY� & windows services also started but now only I am able to connect Oracle 11g & not able to connect Oracle 10g.

how to configure so that I can able to connect both VERSIONS separately on the same server.

View 3 Replies View Related

Server Administration :: How To Reset Parameter Value

Dec 9, 2011

I often use "alter session set xxx=xxx;" command to change parameter value temporarily. After that, how to reset parameter value to default and I don't want logout sqlplus.

View 3 Replies View Related

Server Administration :: Increase SGA Parameter

Jul 22, 2010

SQL> alter system set sga_max_size=1G scope=spfile;

System altered.

SQL> startup force
ORA-12545: Connect failed because target host or object does not exis
SQL> show parameter sga
ERROR:
ORA-03114: not connected to ORACLE

SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

View 3 Replies View Related

Windows :: Different Versions Of Oracle Between Server And Client?

Apr 11, 2012

I'd like to know if it's possible to install a client with Windows 7 (64bits) can be installed with Oracle 11gR2 (32 bits) when the server is still with Oracle 10.1.0.2 ?

View 1 Replies View Related

Installation :: Two Versions Of Oracle Database On Same Server

Jul 31, 2012

Can i have 2 versions of oracle database installed on same server under one user on AIX also on windows,

Currently we have oracle 10.2.0.4.0 installed on AIX server, can we install oracle 11gR2 on the same server under on user, & both the versions will be in use.

How to manage the profile of the user having 2 oracle versions on AIX & on windows how to handle it.

View 2 Replies View Related

Server Administration :: How To Change DB Timezone Parameter

Aug 31, 2010

How to change db timezone parameter. My application team has asked me to change the db timzone parameter by following sql.

ALTER database SET TIME_ZONE = '+10:00';

Is this way is the correct one , and do we have any impact on database and does it require a db bounce.

View 2 Replies View Related

Server Administration :: Use Large Pages Parameter And AMM?

Jul 29, 2011

It always used to be that Automatic Memory Management and Linux huge pages were incompatible: you had to use one or the other. But 11.2.0.2 has new parameter, USE_LARGE_PAGES. This isn't documented apart from a few articles on metalink, but Googling it suggests that if it is on TRUE (the default) or ONLY then I can use AMM with huge pages.

View 3 Replies View Related

Server Administration :: UNDO In Parameter File?

Dec 9, 2011

I have a question ragarding undo tablespace. I want to ask that why only undo tablespace information we need to specify in parameter file. We do not specify any other tablespace information. Not even for temporary tablespace. Then why we need to give undo tablespace name while instance is creating.

View 5 Replies View Related

Server Administration :: Which Initialization Parameter Can't Be Changed

Apr 29, 2012

which initializaion parameter cant be change after creating the database?

View 5 Replies View Related

Server Administration :: Database Parameter Comparison

Nov 4, 2013

We have migrated database data from physical servers to virtual servers. i want to ensure all database parameters are set correctly in both physical and vblock servers. My question is what are all the parameters need to check and compare in both servers to ensure database from both servers ( physical/vblock ) are in sync.

Database used -- RAC database
OS used -- RHL 5.7

View 5 Replies View Related

Upgrade :: Compatible Parameter During Upgrade

May 21, 2013

Why COMPATIBLE Parameter is important to be at a certain value before you UPGRADE(10.2.0.4 to 11.2.0.3) to 11g ?

View 2 Replies View Related

Server Administration :: Hash_Area_Size Unit In Show Parameter

Aug 27, 2012

When I list the parameters with "show parameter", I get only numeric value for hash_area_size with no unit, what is the unit for that value and conversion of it to MegaBytes.

View 3 Replies View Related

Server Administration :: Change Parameter Value In Oracle 11gR2?

May 11, 2012

I want to change cursor_sharing, open_cursors and session_cached_cursors parameter values for SPFILE (Only SPFILE) using SQL Query.

I have found following SQL Queries, but I don't know these queries are only for SPFILE or not.

ALTER SESSION SET cursor_sharing='EXACT';
ALTER system set open_cursors=2500;
ALTER SESSION set session_cached_cursors=70;

I need SQL Queries only for SPFILE.

View 3 Replies View Related

Server Administration :: Database Sessions - Setting Value Of Parameter

Mar 26, 2013

I have a simple question about database sessions. The value of parameter "sessions" is set to 500 and the users connect to database through an application server(Jboss). There are more than 500 users connect to the database through application.

My question is, how more than 500 users can connect to the database without any issue, if we set the value of "sessions" parameter to 500?

View 2 Replies View Related

Server Administration :: Quick Check On Hidden Parameter?

Mar 20, 2013

quick check on a hidden parameter? I need to know the default value and possible values for _serial_direct_read on various releases, I have only 11.2.0.3 available right now and I'ld like to know this for 11.2.x.x 11.1.x.x, and 10.2.x.x.

Below is the query that will show what it is currently which (unless you've changed it) will be the default: auto for my 11.2.0.3. Then to see the options, try to set it to something wrong, my options are false/true/never/auto/always. I think false/true were the only choices for 10.2 and are maintained only for compatibility. But I can't rememebnr 11.1.

orcl>
orcl> set lin 80
orcl> select KSPPSTVL from x$ksppcv join x$ksppi using (indx) where ksppinm='_serial_direct_read';
KSPPSTVL
--------------------------------------------------------------------------------
auto

orcl>
orcl> alter system set "_serial_direct_read"=rubbish;
alter system set "_serial_direct_read"=rubbish
*
ERROR at line 1: ORA-00096: invalid value RUBBISH for parameter _serial_direct_read, must be from among false, true, never, auto, always

orcl>
update: added 11.1.x.x to my wishlist

View 10 Replies View Related

Server Administration :: ORA-32004 / Obsolete And / Or Deprecated Parameter(s) Specified

Nov 9, 2011

I am getting the following error while starting database.

ORA-32004:obsolete and/or deprecated parameter(s) specified

View 25 Replies View Related

Server Administration :: Initialization Parameter File - Currently In Effect For Session

Jan 31, 2012

I have a question about spfile.

SQL> SELECT COUNT(*) FROM v$parameter WHERE value IS NOT NULL;
COUNT(*)
----------
246
SQL> SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL;
COUNT(*)
----------
20

v$parameter displays information about the initialization parameters that are currently in effect for the session,but v$spparameter displays information about the contents of the spfile.I want to know why the count of parameters whose values are not null in v$parameter is greater.where are they from? My initialization parameter file is spfile.

View 3 Replies View Related

Server Administration :: Deprecated Parameter Not In Spfile And Cannot Reset In Memory?

Apr 12, 2013

i try to startup a database, and get that obsolete/deprecated parameter specified(ORA-32004: obsolete and/or deprecated parameter(s) specified)so i try to reset the parameter, but it seems it is already reset(not in spfile), so maybe this is in memory. SO now i try to reset with scope = memory or both, it gives this error(ORA-32029: resetting with SCOPE=MEMORY or SCOPE=BOTH is currently not supported).

what to do, because now i cannot reset with scope = memory and in spfile it is not there but still it comes in deprecated parameter.

View 7 Replies View Related

Init Parameters After Patching

Jan 16, 2013

Database version: 10.2.0.4 Patch 45 on Windows 2003

1. Documentation says to set "_first_spare_parameter" to resolve bug 6904068. What should be the value if we actually see this bug occurring after applying the patch. How can we determine that we need this parameter to be turned on?

2. How can we determine we need to set "_third_spare_parameter"? How can we check if there is a regression on log files?

View 6 Replies View Related

Server Utilities :: Finding Versions Of Exp And Imp Utilities Of Database Server?

Feb 23, 2012

how to find the versions of exp and imp utilities of database server from windows command prompt?

Note: Currently i have 10.2.0.10 oracle software installed on my local machine.

View 4 Replies View Related

RCU-6107 / DB Init Param Prerequisite Failure For / PROCESSES

Jan 22, 2013

I want to install datbase schemas using RCU but it is throwing me an message

"RCU-6083:Failed - Check prerequisites requirement for selected component:WEBCENTER
Please refer to RCU log at C:OracleRCUofm_rcu_win32_11.1.1.2.1_disk1_1of1
cuHome
culoglogdir.2013-01-22_16-03
cu.log for details.
RCU-6107:DB Init Param Prerequisite failure for: PROCESSES
Current Value is 150. It should be greater than or equal to 300."

I tried to change the process using SQL> alter system set processes=300 scope=spfile; and got the msg that system altered but still the error persisit. I reffered to a link RCU-6107, RCU-6092 for the same here it is mentioned in one ofthe post that some user has changed it manually ion init.ora file... Changing manually or through cmd ....

View 1 Replies View Related

SQL & PL/SQL :: DB Differences?

May 17, 2012

I have two Schemas

DMS_NS_STG_1,DMS_NS_STG_2

Both are having same tables but with diffrent data. I want to write a generic code piece for a table to get that diffrences out, it can be for multiple tables. There will be a DB link between two DB.

View 10 Replies View Related

The Differences Between CAT And TAB Table

Jan 1, 2013

1. What's the differences between CAT and TAB?

2. Why doesn't TAB exist in dict?

3. What the appropriate situation for CAT and TAB?

sys@ORCL> desc cat
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TABLE_NAME NOT NULL VARCHAR2(30)
TABLE_TYPE VARCHAR2(11)

sys@ORCL> desc tab
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
TNAME NOT NULL VARCHAR2(30)
TABTYPE VARCHAR2(7)
CLUSTERID NUMBER

sys@ORCL> select * from dict where table_name='CAT';

TABLE_NAME COMMENTS
---------- -----------------------------------
CAT Synonym for USER_CATALOG

sys@ORCL> select * from dict where table_name='USER_CATALOG';

TABLE_NAME COMMENTS
-------------------- -----------------------------------------------------------------
USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user

View 2 Replies View Related

SQL & PL/SQL :: Differences Between Explicit And Implicit Cursor?

Nov 16, 2011

what are the main points that these examples are considered cursors? and why are they called explicit and implicit cursor.

explicit
for x in (select * from emp) loop
dbms_output.put_line('emp no: '||x.empno);
end loop;

implicit
select empno
into vEmpno
from empno
where empname = 'SCOTT';

for all we know that these are not clearly defined on the declaration area as cursor.

View 16 Replies View Related

Build And Load Differences Between Dumps?

Jun 19, 2012

we get daily a full dump from our customer. We have to build the differences of tables (deltas) and load them in separate tables.

There some questions, requiremenst and restrictions:

1) Is it possible the merge the dumps ?

2) How to build the differences as the easiest ?

3) The whole process (import, merge, extract) should be run in batch.

4) We have only a solid knowledge and liitle time for doing.

View 1 Replies View Related

PL/SQL :: Differences Between Calling SQL Statement / Procedure?

Apr 22, 2013

I am planing to write the web-application which use Oracle DB 11g.I would like to understand what are the differences (specially, performance issues, steps of execution, optimizer possibilities) between calling SQL statements and PL/SQL procedures/functions. Which approach is more appropriate, and why?

Examples:
a) WebApp->Call("select * from employees where department_id = ?", 10) ;

b) WebApp->Call("? := mypackage.get_emp(?)", refCursor, 10);

create package mypackage is
function get_emp(dep_id in number) return sys_refcursor is
   begin
    open cur for select * from employees where department_id = dep_id;   
end;
end;==========================================
Requirements: High-concurrency, 100+ db sessions, DB will not be used for business-logic.

View 10 Replies View Related







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