Server Administration :: Oracle Version?

Mar 21, 2011

In my test server ..When i'm going to check the oralce verion .which version this one ? im not seeing anything from oracle EE or standard edition & personal edition ...

SQL> select BANNER from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

View 2 Replies


ADVERTISEMENT

Server Administration :: Incorrect Version Of Oracle

Apr 28, 2011

I installed 11.1.0.6. on Linux RedHat 5.5. Then upgraded to 11.1.0.7. However when I issue sqlplus /nolog and do select banner from v$version it shows 11.1.0.6. Although the install and upgrade were successful. I wonder why it does not show 11.1.0.7. I upgraded using the installer and not dbua could this be the reason why?

View 17 Replies View Related

Server Administration :: Oracle Version Significance

Apr 7, 2010

We have various oracle versions line 9.2.0.1 or 10.1.0.1. There are 4-5 numbers which specify the version of the Oracle Installation.

View 1 Replies View Related

Server Administration :: Upgrade Oracle Version From 10.2.0.1.0 To 10.2.0.4.0

Apr 27, 2011

I want to upgrade my Oracle version from 10.2.0.1.0 to 10.2.0.4.0 but but i don't know what are the correct ways. i read the read me file in the patch set and fallowed the steps but its giving me error e.g. "Error in writing to file D:Oracleproduct10.2.0.2.0inoraevrus10.dll" every time. We have no RAC and Cluster Environment.

View 10 Replies View Related

Server Administration :: Jobs Created When Upgrade To Oracle 11.1 Version?

Feb 8, 2012

what jobs will be created when we upgrade to oracle 11.1 version ?

View 4 Replies View Related

Server Administration :: Version-time In V$database?

Jun 21, 2011

what does mean VERSION_TIME column in V$DATABASE;i know that there is an other column which is called CREATED which indicates when the database has been created and i think it will never change,but, what about VERSION_TIME ? when does it change ?

View 6 Replies View Related

Server Administration :: Database Version Change?

Feb 6, 2010

i have a oracle server installed enterprise edition, for some reation i need to degrade the version from enterprise to standard

i need same tablespace,data's everything same as of now.

View 8 Replies View Related

Server Administration :: What Will Be The Impact If OS Version Change

Dec 21, 2010

Which config file is used to change the os version(RHEL 4.0 to RHEL 5.5) by OS admin what will be its impact on ORACLE Databases.

View 3 Replies View Related

Server Administration :: Upgrade From 11.1.0.6 To 11.2.0.2 Patchset On Linux X86-64 Version?

Oct 1, 2010

I am testing upgrade from 11.1.0.6 to 11.2.0.2 patchset on linux X86-64 version. And facing the following component related issue.

The following components cannot be upgraded as the corresponding upgrade scripts are missing:

OLAP Analytic Workspace ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/apsdbmig.sql )
OLAP Catalog ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/amddbmig.sql )
Spatial ( /u01/app/oracle/product/11.2.0/dbhome_3/md/admin/sdodbmig.sql )
Oracle OLAP API ( /u01/app/oracle/product/11.2.0/dbhome_3/olap/admin/xoqdbmig.sql )

If you want to upgrade these components, you must first install them, using the OUI, and then re-run the Upgrade Assistant. Do you want to continue with upgrade? Note: If you continue, the above components will not be considered as part of the upgrade process.*

Following is the status of the specified components from 11.1.0.6

COMP_ID COMP_NAME VERSION STATUS
AMD OLAP Catalog 11.1.0.6.0 VALID
SDO Spatial 11.1.0.6.0 VALID
APS OLAP Analytic Workspace 11.1.0.6.0 VALID

Should I install these components while installing 11.2.0.2 patchset prior upgrading? I was unable to find any component installation on OUI.

Also DBUA pre-upgrade asked to remove existing UltraSearch from 11.1.0.6 prior upgrading. Though I removed it, but not sure is that going to hamper the upgraded DB, as I'm not sure of the usage of this component as well.

View 7 Replies View Related

Server Administration :: Can Restore Database Password File In ASM For 11gR2 Version

Mar 28, 2012

Can we restore database password file in ASM for 11gR2 version.

View 4 Replies View Related

SQL & PL/SQL :: Check If A Particular Version Available In Earlier Version Of Oracle

Mar 30, 2012

I am using Oracle 11g version, I wanted to check if a particular function is available in the earlier version of Oracle (Say 9i). Oracle optimizer to run the query only using the features available in the 9i version?

View 4 Replies View Related

Restore Full Backup On New Server (With Same OS / Version Of Oracle) Without RMAN Catalog DB

Aug 26, 2010

I started restoring and testing all the backups. So far I did good and I wanted to restore and test in different host. I couldn't find any online documentation regarding restore full back up in a new different server (With same OS and same version of Oracle) without RMAN catalog database.

View 4 Replies View Related

Client Tools :: Can Use Oracle Client Version To Create A Database In That Server

Jan 13, 2011

can we use oracle client version to create a database in that server.

View 3 Replies View Related

Precompilers, OCI & OCCI :: PRO*C Compiler Version Versus Database Version

Oct 15, 2010

We are planning to upgrade a database from 9.2.0.8.0 to 10.2.0.4.0.We have a lot a PRO*C programs pre compiled using 9.2.0.8.0 (and most likely even 9.2.0.7.0) compiler.

if we could upgrade the database without having to re-compile all the programs.We have tested this approach against some of our programs. Most of them executed fine - but in 2 cases we are getting "ORA-01001 invalid cursor". I suspect, that the case is that Pre compiler version 9 is not supported against 10g databases - but I am not sure.

Would it be a better option to upgrade Pre compiler/client as the first step and the db as the second step (and would that be supported) ? We definitely don't want to upgrade both Pre compiler/Client and the Database in one goal - that would be too risky.

View 3 Replies View Related

Reports & Discoverer :: How To Run Version 10g Report In Builder 6i Version

Jun 3, 2010

I have a report of version 10g . I want to run this report in oracle reports 6i version.

View 1 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 :: 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 :: 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

Server Administration :: Connect 500+ Client To Remote Oracle Server?

Aug 10, 2010

we have oracle server. we have to connect 500+ client machine to oracle server.

is it i need to install client version to all 500+ or any other shortcut way?

View 6 Replies View Related

Server Administration :: Find Or Set New Oracle Instance Name On Backup Server

Sep 22, 2010

We performed image copy of production Oracle server (OS and instances) to a backup server. After a few weeks, we try to restore a latest Oracle database backup from production server to backup server. As we know, Oracle instance must be unique on the network.

Even we log on to backup server and bring up the instance, I think that still point to production instance since all init file, TNSNAMES.ora and listener file are still same. If we restore the database, we will end up bring down the production instance and restore on top of productions. How to change instance name on backup server including TNSNAMES, sqlnet, listener files in order for us to restore Oracle database from production to backup server?

View 2 Replies View Related

Server Administration :: Oracle 10g - Database Server Startup / Shutdown

Jun 29, 2011

I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.

View 5 Replies View Related

Server Administration :: Oracle Database Server - Logon Denied

Jul 19, 2011

I am connected as System. It was the only user I set-up a password when installed the database on personal computer.

SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

[code]...

SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied

View 1 Replies View Related

SQL & PL/SQL :: How To Know Uses Of Oracle 9i Version

May 31, 2010

How to know the uses to oracl9i version ?

View 2 Replies View Related

Server Administration :: Oracle DB Server Migration Checklist

Apr 11, 2012

We will be having a meeting with our client regarding their Database Server Migration (They are planning to buy a new server). Their current database is Oracle 10gR2, they will not upgrade to 11g, they just plan to migrate to a new more powerful machine.

I was planning to ask the following questions.

1. Specifications of the current server and the new one.
2. Operation system (I think they will use same OS, just an updated one)
3. Can the business afford full downtime on current servers?
4. Size of the DB, because it can take hours to move large files.

And is there documentation regarding Server Migration (Change of machine only, not database upgrade or anything,

View 5 Replies View Related

Server Administration :: Oracle 10G Client Works With 11G Server?

Jul 17, 2013

Does a 10g oracle client works with an Oracle 11g server?

View 1 Replies View Related

Server Administration :: How To Install Oracle 8i And 9i Databases On Same Server

Feb 20, 2011

How to install oracle 8i and 9i databases on same server for example i want that both type of databases run on same server.

View 7 Replies View Related







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