Server Administration :: Moving IT_TO_DUM_LOADING Job From G1 Database To G2?
Jun 17, 2011
I want to move IT_TO_DUM_LOADING job from G1 database to G2 database.
I executed the below query and returned one row with jobname IT_TO_DUM_LOADING.
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_CREATOR, CLIENT_ID,
GLOBAL_UID, PROGRAM_OWNER, PROGRAM_NAME, JOB_TYPE, JOB_ACTION,
NUMBER_OF_ARGUMENTS,
SCHEDULE_OWNER, SCHEDULE_NAME, SCHEDULE_TYPE, TO_CHAR(START_DATE,'DD-MON-YYYY') START_DATE,
[code]....
it returned the result with
owner,
job_name=IT_TO_DUM_LOADING
job_creator='BALA'
job_type=stored_procedure
job_action='DUM_IT_LOAD'
schedule_type=calendar
start_date='12-JUNE-2008
[code]....
I could not find this job in dba_jobs. how to move this job from one database to other database?
View 23 Replies
ADVERTISEMENT
Jun 22, 2011
We have an Oracle Server database of Size 50 GB having 10 GB Data. And Planning to have a new Database Server of 200GB . So my question is after moving all the 10 GB data to 200 GB Database Server, will the performance of the system come down? Will it reduce the speed?
View 9 Replies
View Related
Mar 13, 2013
The steps to move OMF files in ASM. I tried the following and was not successful.
RMAN> switch database to copy;
datafile 1 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/system.357.809972853"
datafile 2 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/sysaux.363.809972837"
datafile 3 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs1.365.809972737"
datafile 4 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/users.361.809972859"
datafile 5 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs2.360.809972761"
datafile 6 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs3.359.809972787"
datafile 7 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs4.358.809972811"
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2013 16:30:05
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
RMAN> alter database open;
so switch worked reset logs says can't use it there so I just try to open and it just hangs.
View 1 Replies
View Related
Mar 23, 2013
I have problem with moving old DB to the new (the same DB 10.2.0 in Win 2003, first in 32 bit, second in 64 bit). I want move DB from 32 to 64 bit. Problem is that all objects in old DB were created in SYSTEM schema by SYS. I can't export that objets (with data) because impdp nor imp don't touch this objects (tables with indexes). I can't use export import procedure. I'm looking for another method to transfer data, which will be the best and the fastest? Maybe files copy on OS? I suppose it will be problems with configuration files, database have other tablespaces.
View 13 Replies
View Related
May 25, 2010
We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.
View 1 Replies
View Related
Sep 23, 2010
I need to move database ORCL into our existing central database CNTR (both are on same OS and oracle version) I started exp each schema from ORCL and imp in CNTR.
But there is one schema EXMP in database ORCL which also exists in CNTR database with same tables, indexes . The data under schema EXMP in ORCL should be added to schema EXMP in CNTR.
View 9 Replies
View Related
Jun 28, 2011
I have a problem(illega use of LONG) while moving image data from SQL Server 2005 database to Oracle10G table in BLOB.
insert into table
select [[mailto:.....tablename@odbc SQL|.....tablename@odbc_SQL]]
I am using HS connection and DBLink.
View 10 Replies
View Related
Jun 18, 2010
I want to move oracle database 9i on win server 2003 32-bit to be oracle database 10g R2 on win server 2003 64-bit on a new hardware.
View 2 Replies
View Related
Jul 25, 2013
I need to move everything from database 'X' to database 'Y' (assume: both are Oracle 11.2).Which should be the most appropriate way to achieve that?I thought of Transportable Tablespaces- URL..... but I'm worried about it's limitations especially this:SYSTEM Tablespace Objects - You cannot transport the SYSTEM tablespace or objects owned by the user SYS. Some examples of such objects are PL/SQL, Java classes, callouts, views, synonyms, users, privileges, dimensions, directories, and sequences This means all PL/SQL code- Packages/Procs/Functions will be affected.
View 27 Replies
View Related
Oct 31, 2012
I read this article:
[URL]......
Does it work with copying datafiles from 10g2 to 11g2? I want to move one huge tablespace (which contains one table) from 10g2 to 11g2, what is the best method to do that?
View 3 Replies
View Related
Oct 19, 2011
We're currently in a situation where the primary database server fs size does not match the standby database server fs size.
Standby database filesystem is almost 100% utilized, and we suggested to move some of the datafiles first to avoid threshold alerts and archive gaps.
Now, if we're gonna move datafiles on the physical standby, I believe the process would be stop managed redo apply -> shutdown standby -> OS move -> startup mount -> alter rename -> start managed redo apply. Is this correct? If not, how?
Also, would it have an effect if the controlfiles of primary and standby do not match because of the movement?
View 1 Replies
View Related
Oct 7, 2012
I have a requirement to move the databases to a new server.
Existing set up:
database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.2
OS - UNIX AIX-5.3
New Server (setup):
database1-40GB,
database2-40GB,
database3-180GB
Oracle version - 11.2.0.3
OS - UNIX AIX-6.1
My query is what is the best way to move the database to new server(UNIX AIX 6.1)?
a) can i upgrade the database to 11.2.0.3 before moving to new server or its better to move the database in 11.2.0.2 and then upgrade there?
b)is export and import of database can work for moving this?
c) RMAN backup and restoration can be done for moving databases?
d)simply moving all the related files to new server and start upgrading it from there?
View 8 Replies
View Related
Jul 2, 2012
I've inherited a DB where they are going to do a restore this weekend.
The current DB admin is using a db restore (not a duplicate). RMAN with no catalog. The current issue is that the DB restores fine, but when we do a delete obsolete after our backups it's asking if we want to delete the data files.
View 13 Replies
View Related
Mar 26, 2011
i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies
View Related
Aug 16, 2013
when migrating from 32 bit Linux to 64 bit Windows version on database standard edition, is there a server media needed?if yes, can you give me more details on what it consists of?
View 2 Replies
View Related
Aug 14, 2013
Oracle version : 10g, 11g (applicable to both) Consider a schema named 'UNIVERSE' present in the database A running on Linux platform where this schema needs to be moved to another database B running on windows platform or AIX platform with no downtime provided and data needs to be consistent. Is this practically possible?
View 13 Replies
View Related
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
Oct 31, 2012
I 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 Related
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
Apr 18, 2011
I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.
View 1 Replies
View Related
Apr 30, 2012
database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?
View 9 Replies
View Related
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
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
Oct 22, 2011
I want to know if I can access a procedure created on Database server A from database server B.
View 2 Replies
View Related
Apr 17, 2011
Can I extract data from our Oracle server regarding the no. of sessions per day? But the problem is that our Boss wants a previous dates from April 11-17, 2011.
View 4 Replies
View Related
Aug 17, 2010
I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
View 1 Replies
View Related
Jun 10, 2010
see as i said keep on my database down in the night time around 9 pm. the OS redhat linux 5 restarting morning around 6.45 am.when i check alert_log there is no indication.when i check OS log , OS restarting around 6.45 amchecked in the log file in OS level
location: /var/log
i found this
Jun 7 06:45:33 Alraya syslogd 1.4.1: restart.
Jun 8 06:42:22 Alraya syslogd 1.4.1: restart.
Jun 9 06:47:12 Alraya syslogd 1.4.1: restart.
what is this mean, system restarting around 6:45 daily i think now i m posting listener.log for reference
<b>06-JUN-2010 21:04:52 *</b> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
06-JUN-2010 21:05:05 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)
[code]...
OS is restarting around 6.45 in the morning, but database getting down night around 9 pm itself why then in the morning if i bounce the database it starting with no problem
View 9 Replies
View Related
Jun 4, 2012
i m facing a problem in my databse when going to startup. sql> startup ora:00824- can not set sga_target due to existing inernal setting see alert log for more information . when i checked the alert log file i found
cannot set sga_target with statistics_level=basic. acutally last time i change the parameter statistics_level=basic scope=spfile (typical to basic).now my database is not open.what can i do to startup the database.I have no any type of backup.
View 5 Replies
View Related
Dec 15, 2012
I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?
View 1 Replies
View Related
Mar 8, 2013
I am using oracle 10gXE just for basic practice but its showing following Errors
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 8 11:46:34 2
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down fir
SQL>
SQL>
SQL>
SQL> select * from dept;
select * from dept
[code]....
View 3 Replies
View Related
