I've come across an fatal error which terminates my database instance. It's basically cropped up twice over a weekend, and the instance needs to be restarted as a result.There doesn't appear to be any entry in the alert log that ties with the time of the failure, so I only have the trace file entries to go on...
CODE*** 2010-07-30 22:15:31.238
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Failed
kgskrecoveryrecalc: Failed kgsksysstop for 6
kgsksysstop: from KGSKWT_INTSTATECHNG6 retry FALSE mode
kgsksysstop: Succeeded
[code]....
I had a look on my old metalink account to see if there was anything relating to that ORA-56710 error code, but the one article I foun d seemed to be related to RAC instances (which I'm sure that this instance isn't).
I have a table called temp which has nearly 20 columns when i insert values in some columns then null is inserted successfully in remaining column except one column,this column takes string of unexpected characters(like-"inverted question mark") which are not exist on my keyboard, how it is possible. it is happening only in this column and this is only one column of "nvarchar" type , is this because of it(datatype)?
An Unexpected error window like popup is raised when starting Oracle SQL developer.Here I have attached the screenshot of the error.What does the error mean. How to resolve.Below is the error message shown if I click the REPORT button
FeedbackAn unexpected error has occured provide some information that would allow the developer to reproduce the problem
SELECT SUM(salary) FROM employees WHERE department_id =60 O/P is : 28800But when i use the above query in anonymous block it gives me 684400 DECLARE v_sum_sal NUMBER;
[code]....
The above output statements gives me 684400 as output.. But the expected is 28800
[oracle@localhost Desktop]$ netca Oracle Net Services Configuration: # An unexpected error has been detected by HotSpot Virtual Machine: # SIGSEGV (0xb) at pc=0xa23ae762, pid=7422, tid=3075933888 # Java VM: Java HotSpot™ Server VM (1.5.0_17-b02 mixed mode) # Problematic frame: # C [libclntsh.so.11.1+0x429762] snlinGetAddrInfo+0x1b2
An error report file with more information is saved as hs_err_pid7422.log
#If you would like to submit a bug report, {URL}...
I am trying to export a Schema from 11.2.0.2 and getting the below error on export ORA-39127: unexpected error from call to export_string
:=SYS.DBMS_RMGR_GROUP_EXPORT.GRANT_EXP(12425,1,...) ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 154 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 7049 ORA-39127: unexpected error from call to export_string :=SYS.DBMS_RMGR_GROUP_EXPORT.GRANT_EXP(12424,1,...) ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 154 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 7049 ORA-39127: unexpected error from call to export_string :=SYS.DBMS_RMGR_GROUP_EXPORT.GRANT_EXP(12423,1,...) ORA-06502: PL/SQL: numeric or value error: NULL index table key value ORA-06512: at "SYS.DBMS_RMGR_GROUP_EXPORT", line 154 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 7049 ORA-39127: unexpected error from call to export_string := SYS.DBMS_SCHED_JOB_EXPORT.GRANT_EXP(2003412,1,...) ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SCHED_MAIN_EXPORT", line 2296 ORA-06512: at "SYS.DBMS_SCHED_JOB_EXPORT", line 52 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_METADATA", line 7049.
I have searched the forum and found similar errors, but I am struggling to understand the cause and solution.Forums seem to indicate it may be related to bug 4358907, Re: Datapump export/import object grants given by another user but not sure it is relevant as I can see a ORA-01031: insufficient privileges in this log.
- 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?
I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.
Here is what I've done:
1. Install a database (11202), single instance and create a database 2. Install Grid Software only (user: grid) 3. start the cluster 4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid. 4.1> I was able to start/stop the database with srvctl command here onwards 5. configure disks using asmlib and start the asm 6. "srvctl add asm" to register asm with grid. 7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:
RMAN> backup as copy database format '+ASM_DATA_DG';
Starting backup at 24-AUG-12 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=134 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf RMAN-00571:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29 ORA-19504: failed to create file "+ASM_DATA_DG" ORA-12547: TNS:lost contact ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted ORA-15055: unable to connect to ASM instance ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:
[Code]....
All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production Start Date 22-AUG-2012 06:08:53 Uptime 2 days 2 hr. 50 min. 48 sec Trace Level off
creating an ASM instance. I've never done this before and searched all known documentation. I just can't seem to figure this out. This is an 11g database on a WinXp machine for testing purpose before attempting to do this on a live production environment
SQL> desc RCA_SMART_CARD; Name Null? Type ----------------------------------------- -------- ---------------------------- N_CARD_ID NOT NULL NUMBER(10) C_CARD_SERIAL_NUMBER NOT NULL VARCHAR2(20) C_SIM_MSISDN VARCHAR2(20) C_SIM_IMSI VARCHAR2(20) C_LINKED_CARD VARCHAR2(20) N_PRO_IDENTIFIER NOT NULL NUMBER(4) C_CARD_TYPE VARCHAR2(1) N_SIM_STATE NUMBER(1) N_EEPROM_SPACE_LEFT NUMBER(9) N_VOLATILE_SPACE_LEFT NUMBER(9) N_NONVOLATILE_SPACE_LEFT NUMBER(9) N_CARD_OPTI NOT NULL NUMBER(15) N_PRODUCT_ID NUMBER(10) D_CREATION_DATE DATE D_MODIFICATION_DATE DATE D_STATUS_MODIFICATION_DATE DATE
SQL> desc IMEI; Name Null? Type ----------------------------------------- -------- ---------------------------- MSISDN NOT NULL VARCHAR2(20) IMEI NOT NULL VARCHAR2(16) DATE_MOD NUMBER(13) IMSI VARCHAR2(18) ICCID VARCHAR2(20) T_PROF RAW(20) EXTRA_DATA VARCHAR2(100)
If I want to join two table together . I want to search the number of record in IMEI that have N_SIM_STATE =1 in RCA_SMART_CARD . The MSISDN in IMEI is equal to C_SIM_MSISDN in RCA_SMART_CARD .
In the past, we setup a standby database on our production server. My OS is HPUX, Oracle 10g and my database is in archive mod. We are no longer using the standby database method. My problem now is that one of my tablespace (/oradata/tn/rd2_temp 20gb) became 100% full on my production system. In trying to provide more space, I removed one of the standby redo logs. Instead of using ALTER database, I just did a rm from the OS. As I said earlier my STANDBY DB is inoperatable.
When I tried to drop the tablespace(/oradata/tn/rd2_temp it is 20gb), I am getting an oracle error (ora-19528 redo logs being cleared may need access to files). Im also getting and INSTANCE LOCK on ARC4. The rd2_temp tablespace is now offline. If I get rid of rd2_temp, I will be able to gain more space back to /oradata/tn.
I have Oracle 11g R2 (11.2.0.1) with Oracle EM running on Solaris 10 with ZFS.When I start OEM it comes up and tells me that the listener is running but that the DB instance is down and agents are down.I know that the instance is up because I can start it manually.
Each time I start emctl, lsnrctl and DB manually everything starts running but OEM returns a failure for the DB. long as the display shows the DB not running OEM won't allow me to work in it.Instead of getting the login page I get the Database Control Page stating that "Enterprise Manager is not able to connect to the Database instance."I have tried the various emca -config dbcontrol db -repos drop and recreate but no luck.
Is there a way to uninstall/reinstall without dropping the DB?Are there control/configuration files I may hack to tell OEM the correct information?
Below is the desc table : SQL> desc RCA_SMART_CARD; Name Null? Type ----------------------------------------- -------- ---------------------------- N_CARD_ID NOT NULL NUMBER(10) C_CARD_SERIAL_NUMBER NOT NULL VARCHAR2(20) C_SIM_MSISDN VARCHAR2(20) C_SIM_IMSI VARCHAR2(20) C_LINKED_CARD VARCHAR2(20) N_PRO_IDENTIFIER NOT NULL NUMBER(4) C_CARD_TYPE VARCHAR2(1) N_SIM_STATE NUMBER(1) N_EEPROM_SPACE_LEFT NUMBER(9) N_VOLATILE_SPACE_LEFT NUMBER(9) N_NONVOLATILE_SPACE_LEFT NUMBER(9) N_CARD_OPTI NOT NULL NUMBER(15) N_PRODUCT_ID NUMBER(10) D_CREATION_DATE DATE D_MODIFICATION_DATE DATE D_STATUS_MODIFICATION_DATE DATE
SQL> desc IMEI; Name Null? Type ----------------------------------------- -------- ---------------------------- MSISDN NOT NULL VARCHAR2(20) IMEI NOT NULL VARCHAR2(16) DATE_MOD NUMBER(13) IMSI VARCHAR2(18) ICCID VARCHAR2(20) T_PROF RAW(20) EXTRA_DATA VARCHAR2(100)
If I want to join two table together. I want to search the number of record in IMEI that have N_SIM_STATE =1 in RCA_SMART_CARD . The MSISDN in IMEI is equal to C_SIM_MSISDN in RCA_SMART_CARD .
I am installing 4 Node Oracle RAC 11.2.0.2 on RHEL 5.5 (x86_64) {for the first time} I am having some issues with ASM monitoring from em console. the +ASM instance appears to be "down" on the em console. However i can connect to separate ASM instances on respective nodes and thus know that they are not down. I am trying to find out the reason why em console is not able to communicate with my ASM instance.
DATAPOINT1 --------------- Under Metric Collection Error link, I can see the following error message for all the nodes.
Target: xxxxx Type: Host Metric: Storage Data Collection Timestamp: MON D,YYYY H:MM:SS PM Error Type: Collection Problem Messsage: executable nmhs should have root suid enabled [code]....
Now the problem is that I cannot find any binary named "nmhs" anywhere in the grid installation, but this file exists in oracle database bin directory: -rws--x--- 1 root oracle 67778 May 2 18:04 nmhs
I am also not sure whether this is the error which tells me about the problem why em console is not able to communicate with ASM.
DATAPOINT2 --------------- I tried to run emctl to check if the agent for the ASM instance is running: I set the following for running from grid home: ORACLE_HOME=/apps/RAC/grid ORACLE_SID=+ASM1 [code]....
I have seen in all the forums, that there is a directory named "agent11g". I cant find this anywhere in my installation. Its not there in the grid infrastructure directory or the oracle database directory. what are its contents?, do i need this for my RAC setup?, how to I create this now?
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).
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ listener_networks string local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.28.155.79)(PORT=1521))))
I am planning a single instance database using Oracle 11gR2 Enterprise. The instance will run on OEL 5.5 which is on VMWare ESX 3. All disk space will be provisioned as VMDKs. The physical disk comes from a NetApp 7 controlled SAN with multiple disk arrays (one fast disk array and one slower disk array) using NetApp's RAID-DP (RAID-6).
Is there any benefit to using ASM in this single instance configuration ? It seems the data is already being striped, balanced, deduped, and (somewhat) protected by ESX, NetApp, and RAID-DP. NetApp SnapShot provides additional back-up options.
I am thinking without ASM, I could have one 1 TB LUN, say /u01, for the binaries, data files, and management files on the fast disk array and one 1 TB LUN, say /r01, for the flashback recovery area and all other recovery related files on the slower disk array. With autosize capabilities, any of the files can expand as needed up to the 1 TB capacity. 1 TB per disk array is the resource allocation for this instance.
With ASM, on the fast disk array I would have one 32 GB LUN for binaries and other files which must be outside of Oracle's CFS under ASM and then four 248 GB LUNs to create the ASM disk group DATA. On the slower disk array I would have four 256 GB LUNs to create the ASM disk group FRA.
we have lost a Tempfile due to SAN problem ( the temp tables has 7 tempfiles ) Problem is that some application servers have still that tempfile available since they are connected since a longteime and therefore some users receive an error while trying to use it .
I just wanted to drop it from the system dictionary but i can't i always receive and error ( datafile cannot be dropped at this time)
and i can't see what session is using it, that query wouldn't be useful since i have 7 datafiles and it's based on Tablespace name only .
How can i drop that tempfile without bouncing the instance ?
Initial situation: Oracle 10g database single instance on Windows 2008 (datafile within NTFS partition) Final situation: same database upgraded to Oracle 11g r2 on a two nodes RAC on Windows 2008 (datafile within ASM)
In your opinion, is this the best way to achieve the job ?
1) on the two nodes install grid 11gr2, asm, rdbms 11g r2 (SE) 2) export full from 10g 3) create a new empty 11g r2 database in the RAC 11g r2 infrastructure with the same tablespace layout of 10g database 4) import full from 10g to 11g r2
I have SQL Server database I would like to migrate into Oracle. The database supports a large application. It is around 10GB. I requested a new instance but was advised I would have to pay for that but if I asked for a new Schema it could go in our current company instance. I am fine with that since it wont cost more money if I just add a new schema to our Company Oracle instance. Just curious what is the advantage of getting a new instance compared to creating a new schema for 10 GB of data?I assume the advantage of creating a new instance is our Schema (in new instance) and work will have its own space/house and can grow in size without any issues?
I want to replicate an Oracle instance from one Server to another one. On server 1 Oracle is running with instance TEST02 in archive mode. I have to backup this instance while it is running active and in use by multiple users working in our ERP-System. Now I want to backup alle stuff I need (database, archivelogs, rodlogs?) into another instance TEST03 running on another Server to have a fallback solution. This backup I would like to repeat every 2 hours to have always a copy of Server 1 TEST02 on Server 2 TEST03
Any script how to do this Job(s)? (I know how to connect to instance by *.bat but in internet I did not find the useful statement(s) how to backup / recover the complete instance.
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.
