We plan to move the database to a new host with much more RAM, CPU. The new database server will have exactly the same OS version, Kernel version and the same version of database / grid standalone (ASM). I will have to install OS, Database software, Grid Standalone on the new server.
The current version of the database is 11.2.0.3.0 Enterprise Edition and the OS version is Oracle Enterprise Linux 6.3. However, we plan to use the same disks (ASM disks). I believe I don't need to use RMAN to do the migration, Is it correct?
I will be duplicating my production database back to a few weeks ago on my test server, to retrieve certain data. I am running 11g standard edition, not using a recovery catalog.
Below are the basic steps I plan to take in a nutshell.
1. Copy the backup files to the test system
2. In the rman run block (on the test server) A. Set newname for each of the datafiles and tempfiles (don't have many files) B. Duplicate command to point in time, specifying backup location and no filename check.
the strange thing is "lkinstrdmetdev" is the wrong name(sid is rdmetdev), and the file does not exist in the FS too. the correct file name should be "lkrdmetdev" and i've deleted this file from the directory. I did not do any changes. and no any oralce processes running while i started up the oracle instance.
Thu Feb 14 09:25:20 EST 2013 sculkget: failed to lock /u01/app/oracle/product/10.2/dbs/lkinstrdmetdev exclusive Thu Feb 14 09:25:20 EST 2013 sculkget: lock held by PID: 272600512 Thu Feb 14 09:25:20 EST 2013 Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Thu Feb 14 09:25:20 EST 2013 Failed to acquire instance startup/shutdown serialization primitive [code]....
Oracle Instance Startup operation failed. Another process may be attempting to startup or shutdown this Instance. Failed to acquire instance startup/ shutdown serialization primitive
I have 2 server install oracle : server 1 and server 2
server 1 run database DB01
i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .
At server 2 :
After start database with init.ora file and restore controlfile error :
RMAN-03002: failure of restore command at 07/22/2011 02:56:04 RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
i am having database in server and i have to run my web application in client machine. how to set the connection of server database in web.config file.
Due to some some Network issues . we have planing to move oracle database one domain to another domain changing domain name and IP address of oracle database . if want to change oracle database 10g(10.2.0.5.0) 32 bit windows version what are setting s to change in oracle database.
I want to move a oracle job from one database to another database. i tried to open the job from toad by pressing f4 on it in editor , im getting message like...
"unsupported type for describe popups (Without DB admin module)
Are there any good information about on how to move a 10g database to a new server? We will keep the same disks on the SAN, but make a new installation on the new server.
I have written a Database procedure to move data from one data to another database using Database link. When i run that procedure on Sql it is running fine, but i use same procedure in a button in form using "When-Button-Pressed" trigger it generates error, error code is ORA-02055 and ORA-02067.
move the tables with data present in the user scott(full) to another schema named test. In my case scott is in user tablespace and for test schema i have created different tablespace named test_tbs.
We are going to test migration of g10 to g11. To reduce maintenance of configuration we want to install new Oracle on the same server and start on the same port with the same SID. To achieve that we are going to configure new Oracle on different IP and hostname (managed by DNS, whatever). So listener will be configured like for different servers with identical SIDs.
I want to host name and max logon day from the below query But host name not belongs to start with 'IRS%' and 'EMEAUKIMIV00023828'.
My question is How to handle the backslash in oracle 8i and also check the below query is ok or not,
select host, max(logon_day) from ( select host,logon_day from system.stats$user_log where host not like 'IRS%' AND not in ('EMEAUKIMIV00023828')) group by host;
Here i have three tier application. I want to know it host name from sid or sqlid . I want to know which query run on which host. Because i have one user from application to database. So i want to know which query consume more time on which host ?
I've got a problem when I use the HOST procedure to work with DOS Prompt. When I access the DOS Prompt via Oracle Forms HOST Procedure, the name of files and folders got limited by 8 chars plus extension. Lets suppose I want to copy a file and the file name is my_image.jpg. What I have to do is:
HOST('copy MY_IMA~1 C:TEMPIMAGE01');
I guess it sucks cause the function GET_FILE_NAME give me the filename as my_image.jpg. Do I have to convert the filename every time?
Is it possible, Oracle let me connect to an running +ASM instance from a different host? I.E, +ASM running on X host and i want to connect from Y host. (yes Y host has the asm entry in the tnsnames.ora).
I am trying to use Database Replay in 11g Release 1 using Enterprise Manager. In the last step it asks for 'Host Credentials' to start the capture. But when i give the username and password for the host, it throws error as 'Invalid username/password' all the time.