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
ADVERTISEMENT
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
Jan 31, 2012
i got an error while creating database manually
View 26 Replies
View Related
May 4, 2011
I want to install oracle 11.2.0.2 single instance database on AIX 6.1, does oracle recommend separate OS user for grid infrastructure and for oracle install? how many groups I need to have for these users like oinstall, dba etc?
View 1 Replies
View Related
Mar 16, 2011
My context on our servers is the following one:
- one ASM instance
- X DB instances
- each DB instance uses 2 or more dedicated diskgroups from the ASM instance
- there is one diskgroup named FREEDISK that contains spare disks
On each DB instance you can see:
- the list and global parameters of all diskgroups using v$asm_diskgroup view
- the list and parameters of all disks the instance is using with v$asm_disk view
So my question is: how (if this is possible) to know the list of (spare) disks in FREE DISK disk group?
View 6 Replies
View Related
Dec 20, 2011
I am still getting the erros.
C:>set oracle_sid = sidname C:>set oracle_sid oracle_sid = sidname
C:>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 21 01:49:06 2011 Copyright (c)
[code]....
View 2 Replies
View Related
Mar 19, 2010
I got this error after i patch to 10.2.0.4.0. Before patch, database running smooth.
I shutdown as usual using shutdown only.
View 8 Replies
View Related
Sep 22, 2010
We imaged production Oracle Server ( OS and Oracle and everything) to a backup server. I guess my question shall be how do we access the local instance via this backup server. When we log on to this backup server, we ran sqlplus and connected to the instance but it ended up to connect to production instance. Shall we stopped local Oracle services and change init.ora, tnsname, or listener files in order not conflict with production instance?
View 1 Replies
View Related
Dec 9, 2010
findout and to fill up the excel which lists down the Database schemas and states whether they have in active / or not.
Active state may be determined whether it has been used for the last 3 months or so. The last updated time may be a good indicator of the same.
View 2 Replies
View Related
May 20, 2010
How I can find the hostname for an oracle session id?
View 4 Replies
View Related
May 10, 2012
My production database is about 900 GB in size but the actual data in our database is only approx 600Gb it means 300GB is a deleted data and not fragmented, as per my understanding the best way to resolve fragmentation is Import/Export but we can go for this option because its a very time taking process.
We are taking full database backup using RMAN every week and also going to upgrade our production database from Oracle SE to Oracle EE edition using the same full database RMAN backup, as i know Rman is also not backup of those blocks which not containing any data , it means if we will use Rman full backup to setup our new EE database it will only 600GB of data not 900GB or there is only Export/Import to remove fragmentation.
View 2 Replies
View Related
Sep 8, 2013
[oracle@localhost /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Sun Sep 8 19:10:30 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
--------------------------------------
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '/home/oracle/app/oracle/product/11.2.0/dbhome_2/dbs/'
ORA-27037: unable to obtain file status
Additional information: 5
What seems to be a problem here? I've been trying to fix this for few weeks.
View 24 Replies
View Related
Jul 15, 2010
I am learning to create an ASM (Automatic Storage Management) instance using dbca.
View 3 Replies
View Related
Apr 29, 2013
How to create DBMS_SCHEDULER job for particular instance,we have 3 instance we want to schedule few jobs in Instance 2,how to schedule in Particular instance.
View 3 Replies
View Related
Sep 28, 2011
I've to install Oracle 10g on Solaris 10, Sparc. I prepared anything successfully, but, when I gone to create ASM instance, I found the Create new bow did not show any disks into. I take brief something:
1- Sparc & disks preparation:
# isainfo
sparcv9 sparc
# ls -lL /dev/rdsk/c4t50060E800570B715d0s6
crw-rw---- 1 root sys 336, 14 Sep 28 14:08 /dev/rdsk/c4t50060E800570B715d0s6
# ls -lL /dev/rdsk/c4t50060E800570B715d2s6
crw-r----- 1 root sys 336, 62 Sep 28 14:09 /dev/rdsk/c4t50060E800570B715d2s6
# ls -lL /dev/rdsk/c4t50060E800570B715d3s6
[code]....
Those 6 partitions disks above were supplied to ASM, so, I make mknod to link them.
# ls -lrt /asmdisks
total 0
crw-r--r-- 1 oracle dba 336, 110 Sep 28 15:35 disk6
crw-r--r-- 1 oracle dba 336, 94 Sep 28 15:39 disk5
crw-r--r-- 1 oracle dba 336, 78 Sep 28 15:39 disk4
crw-r--r-- 1 oracle dba 336, 30 Sep 28 15:39 disk3
crw-r--r-- 1 oracle dba 336, 14 Sep 28 15:39 disk2
crw-r--r-- 1 oracle dba 336, 62 Sep 28 15:39 disk1
Well, I go to ASM, but And nothing on Available Disk Groups.
View 2 Replies
View Related
May 11, 2011
Getting the below message even after doing the
oracle@ttlwaurd001:~$ ps -ef | grep pmon
oracle 7779 1 0 Feb08 ? 00:00:07 ora_pmon_WGRGOLD1
oracle 10155 1 0 Feb20 ? 00:30:48 ora_pmon_DPTLS01
oracle 12354 1 0 Feb20 ? 00:00:53 ora_pmon_DOEMS01
oracle 17902 1 0 Feb20 ? 00:00:13 ora_pmon_DREPS01
oracle 23745 23360 0 19:51 pts/4 00:00:00 grep pmon
oracle@ttlwaurd001:~$
oracle@ttlwaurd001:~$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 19:49:54 2011
Copyright 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
oracle@ttlwaurd001:~$ echo $ORACLE_SID
DPTLS01
View 15 Replies
View Related
Mar 2, 2013
I am trying to configure a new ASM instance. I am getting error " -bash: crsctl: command not found" .. where should i actually look for the error. crsctl command not found.... I am doing this as a root user .
View 5 Replies
View Related
Jul 8, 2011
I have a lot of shemas inside an instance... How to organize them?
What I see is a long list of schemas which could be difficult to manage if number of schemas grows up... For example, I'd like to group Schema_1, Schema_2 and Schema_3 in something like Group_1, so it could be seen more organized.
Group_1
Schema_1
Schema_2
Schema_3
Sometimes a java or .net application uses 3 or 4 schemas... these schemas are in the same instance which has other schemas for other applications.
View 2 Replies
View Related
Jul 14, 2010
create an ASM (Automatic Storage Management) instance using dbca. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.
I went back to do some cleaning up as follows:
1) Edit the oratab file to remove the ASM entry
2) backed up these files by renaming to old-<filename>
old-ab_+ASM.dat
old-hc_+ASM.dat
old-lk+ASM
old-orapw+ASM
old-spfile2+ASM.ora
3) killed the following processes (kill -9):
oracle 1590 1 0 22:52 ? 00:00:00 asm_pmon_+ASM
oracle 1592 1 0 22:52 ? 00:00:00 asm_psp0_+ASM
oracle 1594 1 0 22:52 ? 00:00:00 asm_mman_+ASM
oracle 1596 1 0 22:52 ? 00:00:00 asm_dbw0_+ASM
oracle 1598 1 0 22:52 ? 00:00:00 asm_lgwr_+ASM
[code]....
4) Run the following as root:
/u01/app/oracle/product/10.2.0/db_1/bin/localconfig delete
5) Restarted the database
Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:
"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."
I click OK. Then I get the error message:
ORA-01012 not logged on
View 12 Replies
View Related
Apr 27, 2012
how can i monitor the instance status and log switch summary.
View 8 Replies
View Related
Mar 29, 2011
I have successfully installed Oracle R12 on my machine but after rebooting I can not start.
This is what I did
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
You are running addbctl.sh version 120.1
Starting the database VIS ...
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start
[code]....
BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.
View 18 Replies
View Related
Jun 24, 2010
Find an appropriate script to automate Oracle DBs in one server? This db server have 6 instances. We always done the starting up and shutting down manually, although we have a reference script that does this but in Oracle v7.3.4. We do want to include the automatic start/stop of dbconsole for accessing it via OEM.
View 1 Replies
View Related
Nov 9, 2011
is there a way to find out which unused columns in oracle?
View 8 Replies
View Related
Mar 9, 2012
how to find a table is updated and when the table is updated.
View 1 Replies
View Related
Jul 26, 2011
I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?
View 6 Replies
View Related
Jan 17, 2012
We need to find when any datafile was resized ( if at all)in a tablespace. Actually, by noting the created date from v$datafile , we used to know the data growth in a tablespace. Now as the number of datafiles have increased, we want to resize them. This diagnostinc have to be done without changing/adding anything in DB.
View 12 Replies
View Related
May 10, 2010
where i can find an alert log errors so whenever they occur in my RAC so i can comprehend them very well. I am trying to know that what can be the errors when u have RAC with ASM and SAN .
View 3 Replies
View Related
Dec 27, 2011
I can not find the sql plan for insert statement,why?
Select sql_text From v$sql a
Where a.SQL_ID = '0yungrk19a277';
-------------------------------
INSERT INTO OS_USERBILL_ACTV_READ_MON_DT
(MONTHNO, MAILCODE, OPERTYPE, PROVCODE, AREACODE, DAY_TOTALCOUNT, TOTALCOUNT,
CREATETIME, MODIFYTIME, SENDER_TYPE, SENDER_DOMAIN)
VALUES
(:B9 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , SYSDATE, SYSDATE, :B7 , :B8 )
[code]....
View 4 Replies
View Related
Jun 20, 2010
Is there any way to find the last run duration of a job which was scheduled using DBMS_JOB?
View 3 Replies
View Related
Aug 15, 2011
How to find the base table of a view,such as a view:
create or replace view vw_test as select * from tb_test;
Is there dic view to get the base table of view?
View 3 Replies
View Related
