I tried to convert a physical SuseLinux with Oracle 9i Machine into an virtual Machine (esxi Server 5.0). (VMware vCenter Converter ) Before started I shutdown database:
su – oracle
sqlplus ‘/ as sysdba’
shutdown
and the run converter.
But i have problem with copy /u01 and /u02 (database files) "Error: Unable to clone the volume mounted on '/u01' "
So i want clone machine without /u01 and /u02 then copy file. What I should do to be correctly?
I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?
Can i keep the database name as ASMDB in another Machine ?
I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:
rman auxiliary sys/******@dbracdup RMAN> duplicate database to dbrac spfile backup location '/oracle/backup'; ... ... Finished recover at 25-JUL-12 Segmentation fault
And the database was in mount stage, and when i tried to open database it failed with below error:
SQL> alter database open; alter database open * ERROR at line 1: ORA-19838: Cannot use this control file to open database .
I have a query regarding the cloning of a database.
Actually, i have made the two machine on a single system(Laptop) and now i want to clone the database, so for that i am unable to move the database backup from one Machine to another.
how can i move the backup and which command is applicable for that.
Note: - Listener/TNS is already configured on both the database.
I have an Oracle 10.1 database on a Windows 32 bit platform that I am attempting to clone to a new server to make a development instance.
For this particular scenario the database needs to stay at version 10.1. Both servers are Windows Server 2003. Following oracle docs I have copied the home folder and am attempting to run OUI with the clone switch.
OUI crashes and reports the error as "unknown". OUI also crashes if I try to run it without the clone switch from gui.
Why this occurs, and have confirmed that PATH is correct etc on the new dev server and the other obvious stuff.
I just need a quick way of getting this dev server instance up and running AND maintaining the same database version (10.1). I thought the clone operation would be a good option but don't know how to troubleshoot when the error is "unknown".
I want to create such a script to clone the Database user with the new name. Just like we do normal import and export I want that i should enter just the username of the existing user and username of the new user I want to get created, the password for the same.
It should create the new user with all roles and the default roles and privileges of old user.
i install oracle 10g on linux on perform the following step but my database is not auto start with the machine
Automatic startup and shutdown oracle on linux Oracle database server provides two scripts to configure automatic database startup and shutdown process.
The scripts are, $ORACLE_HOME/bin/dbstart $ORACLE_HOME/bin/dbshut
Now let's look at unix level script. When a unix machine boots it runs scripts beginning with Snnname in /etc/rc3.d.
-Here the number nn indicates the order in which these scripts will be run. The name just indicates the function of the script.
In the same way shutdown scripts are named as Knnname which are run from /etc/rc0.d.
If we want that Oracle is the last program that is automatically started, and it is the first to be shutdown then we will name the startup and shutdown scripts on OS like /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
The database script dbstart and dbora will be called from OS script /etc/rc3.d/S99oracle and /etc/rc0.d/K01oracle respectively.
Note that dbstart and dbshut take each SID, in turn, from the /etc/oratab file and startup or shutdown the database.
Automate Startup/Shutdown of Oracle Database on Linux
Step 01: Be sure that oratab file is correct and complete.
Check for oratab file either in /etc/oratab or in /var/opt/oracle/oratab.
Database entries in the oratab file have the following format:
$ORACLE_SID:$ORACLE_HOME:Y Here Y indicates that the database can be started up and shutdown using dbstart/dbshut script.
If in my database there is two database named arju and arjudup then my oratab file will contain the entry like, arju:/var/opt/oracle/product/10.2.0/db_1:Y arjudup:/var/opt/oracle/product/10.2.0/db_1:Y where /var/opt/oracle/product/10.2.0/db_1 is the $ORACLE_HOME of my database.
Step 02: Create a script to call dbstart and dbshut. In this example I will create one script that will do both startup and shutdown operation. I will name this script as dbora and will be placed in '/etc/init.d'.
a) Login as root. b) Change directories to /etc/init.d c) Create a file called dbora and chmod it to 750.
# touch dbora # chmod 750 dbora d)Edit the dbora file and make the contents of it like below.
I'm using Oracle Database 11g R2 for study purposes.Currently I'm learning about the DBCA clonic templates.I have an Oracle DB 11g R2 X86 running properly in Ms Windows XP Professional SP 3 X86, using DBCA I created the seed template file .dbc and the .CTL and .DBF files, later I copied those files to a server running Oracle DB 11g R2 X86 in Ms Windows 7 Ultimate X86. Again, using DBCA I successfully created the source database through the seed template file, everything was ok.
Now, I formatted my testing server and I installed Ms Windows 7 Ultimate X64 and Oracle Database 11g R2 X64. I copied the seed template file .dbc and the .CTL and .DBF files to "assistantsdbca emplates" directory. Well, I started DBCA to try create the source database and when the DBCA is creating and starting the Oracle instance it shows the errors:
1. I installed oralce with Service_Name=DB1 it works fine,
2. I created another database with dbca named DB2,
3. I connected both system/password@db1 and system/password@db2 without any problem,
4. After rebooting the computer I can connect only the first database DB1 which I installed with Oracle installation. But, I can not connect to the 2nd database which I created with dbca. Error Message Shows: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
DB1 has no problem I can connect to that, but I can not connect to DB2 after rebooting the system. Now I need to know how to connect to DB2.
Quote:
connection messages: oracle@pc ~]$ sqlplus SQL*Plus: Release 11.1.0.6.0 - Production on Thu Oct 21 12:51:43 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Enter user-name: SYSTEM@DB1 Enter password:
I have a RedHat Server with Oracle Ent. 8iI did a full export of all my current data bases ( DCTEST, DCPROG, DCUSAC, DCCAND)I now have the DC*.dmp files. How can I know import these files into Oracle Database 11R2?
Do you have a Step-by-Step how-to ?IF I don't have the scripts to re-create the databases how to go forward ?
From a script how I can read a local file (where I have the sql client)?
I have an Oracle database on a server, and I connect from another machine with SQL Developer.I want to read a text file on my local machine ( where I run my script) to use the data in the script.I never want to read or write on the server.
Reading on internet i read about UTF_FILE package But what is not clear to me is, this is on the server or client ?Also some people says UTF_FILE can work both on client side and server side.Also I read about package text_io, but I think it is only for forms.
Iam using Oracle 10g Release 10.1.0.3.0 Database and Linux Operating System for Server. I have a Stored Procedure which generates a Text File in Oraload Folder. Can I copy it to /home/ftp-docs/ using utl_file.fcopy ? If yes, how to do it ?
i am working on Database 11g. I Need to download file to local after the file is created in the database directory using UTL_FILE . i am able to generate the file but not aware how to copy or download the file to local using PL/SQL . i have done the same in forms using webutil pll.
1) at the click of button, some data will be written to XML file and after writting to file, it should get saved to some location on local machine(c: emp), without asking user, where to save.
How to do this in oracle form?
Also is it possible to read file from local machine?
I am writing a program for doing some file transfer between the client machine and the application server.I am using Webutil_File_Transfer.Client_To_AS to do the transfer and also using Webutil_File.File_Size to check on the file size at the source.
Once the transfer is complete, I also need to check on the destination file size (the application server running on Linux) for verification purposes and can't find the way to do it.
I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .
I need to copy .CSV File from a Windows Server shared path (\hostnameoutput) to another server which i believe is on unix.The other server name is abc.hcl.com. On this server i need to put it in the root directory. I will have to use SFTP and not FTP.
I want to create binary copy of control file every time I do backup. I am using sql "alter database backup controlfile to ''+FRADG/TESTDB/controlfile/controlfile.ctl'' "; in my rman backup script. If I run it second time I got errors as it does does not allow to overwrite existing one.
I want my application to provide an end-user with ability to upload the files from their machine to SFTP server directly. So far, I have managed to write the function which uses java source and allows to upload files from the database. It works just fine.
The function looks as follows:
FUNCTION SFTP_CMD ( V_USER IN VARCHAR2, V_PASS IN VARCHAR2, V_HOST IN VARCHAR2,
[code]..
where V_FILE_SRC represents location of the file to be uploaded. The thing is that the FILE BROWSE apex item does not allow to specify the file location, it identifies it somehow automatically, when you press the button 'Choose file'. The question is how can I catch file's path, so that I can pass it to V_FILE_SRC parameter in my function? Should I write my own plugin? or hack FILE BROWSE item? =)
There is a requirement to make a table data in a database (eg: HR database) available in another database (eg: EMP database), instead of accessing it using database link. In EMP database(where data needs to be cloned), data will only be queried and no write operation will be done. Data in remote database (eg: HR DATABASE) will be occassionally fully truncated and reinserted. The plan is to do a similar truncate and reinsert of data (from HR database) into EMP database monthly once using dbms scheduler job. So basically data in just one table needs to be cloned in another database.
Question: For this situation, is a regular table or Materialized view the right choice to clone the table in EMP database and why? The table in HR database (remote database) is not very big.
