I want to Transfer Oracle Database 11g Release 11.1.0.7.0 on windows 2003 32 bit server to Windows 2008 server 64 bit I have Cold RMAN backup. and directory structure of both server are same Do i need to do anything to change datafile to 64 bit or do i need to apply any change to any object
View 6 RepliesI 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 1 Replies View RelatedI 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 RelatedDoes Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.
View 1 Replies View RelatedI've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.
On Database Server
SQL> create directory win_expdp_dir as 'd:expimp';
Directory created.
SQL> grant read, write on directory win_expdp_dir to lab;
Grant succeeded.
On Windows 7 machine (client machine)
D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.
On windows 2008, need to schedule task for database backup.
View 4 Replies View RelatedWe have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.
We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?
We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .
i have a question about oracle database 9i in windows server 2003 R1 X86 . I set the parameter of pga_aggregate_target=1000M and 500M sometimes i found after few days that error message appear to client
ORA-12500 TNS:listener failed to start a dedicated server process
when i try to connect from the server sometimes logon and sometimes another message appear
ORA-12560: TNS:protocol adapter error
i think the problem in pga_aggregate_target value
I want to do cloning of a database on my standalone pc having oracle 10g on windows 7. PC is P4 with 2GB RAM.
The database is installed on my pc and i want to clone it on the same pc.
I want to install Oracle 10g R2 on Windows Server 2008.
View 22 Replies View RelatedWe have been upgrading our servers to Server2008 and are getting..
[ORA-3134: Connections to this server version are no longer supported.]
..using the drivers we used to use in XP and Server2003 to access a legacy Oracle7 db. Connections to this db are needed for typical CRUD functionality by multiple applications, some written in Classic ASP and some in C# .NET 3.5 & 4.0. I have tried ODBC drivers (System.Data.Odbc) and also ODP (Oracle.DataAccess.Client) to no avail.
Any existing driver solution to make this connection without have to resort to a custom HLI interface?
I would think we aren't the only ones needing to access Oracle7 from Server2008.
I want to apply patch 13 to 11.2.0.3 database for windows server 2008 R2. I saw the pre requisites and found that opatch should be 11.2.0.1.9 or later. My optach is 11.2.0.1.7. I downloaded the patch # 11846294 and unzipped under the opatch directory. In one of the step it asked me to run the following command
$ORACLE_HOME/OPatch/oplan/oplan generateApplySteps <bundle patch location>
but then it says oplan is not recognized. I have set the Oracle_home and path variable
my path is C:Oraclegrid_homein;C:Oracledbhome_1in;C:Oraclegridin;%SystemRoot%system32;%SystemRoot%;%SystemRoot%System32Wbem;%SYSTEMROOT%System32WindowsPowerShellv1.0;C:Program FilesArcGISArcSDEora11gexein;C:Program FilesXIVhost_attachin;C:Oracledbhome_1oplan
Note that my database version is 11.2.0.3 with ASM
I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.
D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba
[code]....
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"
[code]....
* on my DB server I am login using my administrator account, on my PC I dont have admin account.
* I have checked remote execution using local user as well as admin user.
* I have checked the permission and my local ID & EVERYONE has all permission in that folder.
My automated RMAN backup plan.
ShutdownDB1.bat
set oracle_sid = pldg
C:oracleproduct10.2.0insqlplus.exe /nolog @c:oraclebackupshutdowndb2.sql
ShutdownDB2.sql (called by the previous batch file)
set echo on
spool C:oraclebackupShutdownDB.log
connect /@pledgemaker as sysdba
shutdown immediate
spool off
exit
<Here there will be a thirty minute window or so while I XCOPY the Oracle Inventory and Oracle Home directories.>
RMANBackup1.bat
set oracle_sid=pldg
C:oracleproduct10.2.0BIN
man.exe target / cmdfile = 'c:oraclebackup
manbackup2.scr'
log = 'c:oraclebackupRMANBackup.log'
RMANBackup2.scr (called by the previous batch file)
startup mount
backup database
alter database open
exit
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."
I'm trying to write a bat file for the rman backups that can be used for any of our databases. I'm passing variables into the bat file and that is working fine (i.e. oracle_sid, drive letter, oracle_home), my problem is when the rman actually runs and calls the ctl file, the variables aren't being passed thru to that file.
View 3 Replies View RelatedI am looking for Oracle database 10g (best if it is the lastest release of 10G) 64bit for windows2003 64bit machine but cuold not find the download (Oracle has took this off line, only 11g is available). where can I get this installation file?
View 1 Replies View RelatedDoes already installed Oracle 10g (10.2.0.1) on a windows 2003 server x64? Do you notice strange behaviors, any errors after the installation?
Does already installed Oracle 10g on a windows virtual machine? Are there any prerequisites?
Is it possible to set a physical standby between 2 servers with same OS but different level ? I mean primary has windows 2003 SP1 and Standby has windows 2003 SP2. I want to know if it will work properly or not.
View 1 Replies View Relatedwe don't have system or storage admin available..I have to create the development environment. I have 2 Dell 2950 Power Edgde Servers and 500 GB Buffalo NAS with Windows 2K3 X64 EE, tell me whether I can install Oracle RAC with this kit.
If yes , how can I configure shared storage and present it to OS so that both nodes can see it.
i have windows 2003 server, oracle 10g release 2 installed, but enterprise manager is not exist.
how could i install enterprise manager without risk , without need of restarting database?
it is a production database.
Oracle 9i instalation problems in Windows Storage Server 2003.
I got the error "ORA-12546- TNS:Permission denied" when trying to install ORacle 9i in Windows Storage Server 2003. This error occurs at the time of Creating database.
,I am new to Oracle database administration i am working on a 24*7 tool .the tool will work as a non stop.this is a standalone tool.there wont be any one who will be taking care of the database.I need to design a backup statergyNeed to take backups on timly basis.Since the database can't be go offline cold backup's can not be useenhot backup needs to implemented.what are steps needs to do for hot backup.Is there are some pre defined scripts to run the backup.
View 6 Replies View RelatedI have a 11g database installed on a windows 2003 server. When I created the database I could not assign more than 2GB for SGA_TARGET where as I have 16GB of RAM available on the server. I created the database with SGA_TARGET as 1.5 GB and Memory_TARGET as 2GB. I could create the database successfully. Later when I again tried to increase SGA_TARGET to 6GB and MEMORY_TARGET to 8GB, I could not start the database. I got below error;
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command
Quote:I added /pae in the boot.ini
Added AWE_WINDOW_SIZE key to registry as 2000000000
Set use_indirect_data_buffers=true
added db_block_buffer=131072 (ie. 2GB DB_BLOCK_SIZE=16kb)
java_pool_size= 1000M
large_pool_size=1000M
shared_pool_size=2000M
I got again the same error
I could not use SGA_TARGET. So is AMM not allowed with AWE?
I have Oracle 9i DB in windows 2003 server, I want to access this DB from Linux desktop. Is there any 'client software' is available to connect Or procedure to connect the DB.
View 0 Replies View RelatedI have Windows 2008 R2 32 bit server having 32 Gig of memory I want to use /PAE settings. I already follow metalink 225349.1 but to no avail.
below is my pfile settings. But i received error when i start with this settings
the error "ORA-27102: out of memory
OSD-22
O/S-Error: (OS-8) Not enough storage is available to process "
ppciorcl.__java_pool_size=200M
ppciorcl.__large_pool_size=200M
ppciorcl.__streams_pool_size=200M
[Code]....
I am trying to return a value of an oracle stored procedure using Excel VBA.
OS: Win XP SP3
Excel 2003
Ora Client: 11g
By trying different things I have noticed, that I could have troubles with the ODBC-connection. Maybe I am not using the right one. To store data returned from select statements I have an ODBC-Connection (Driver: Oracle in XE), which works perfectly, e.g.:
'-----------------------
Sub Extract_Data()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim db_name, UserName, Password As String
cn.Open db_name, USerName, Password
[code]....
When debugging the connection string, I find the Provider=MSDASQL5.1.
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 2 Replies View RelatedOracle 11g R1 or R2 is availble for Windows Server and If YES then any link for the same.
View 2 Replies View Related