In my database server i am not able to login to the database via sqlplus and exp/imp also having error as below. But i am having permission to the this executable. I am falling under other user catagary
Enter user-name: sys as sysdba Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Even i start the Oracle service through the services.msc there are no new entries seen in alert log file of the database.I even changed the init DBNAME. ora file but that file is not being read. what is the normal procedure used by oracle 8i while starting the DB ? Which file should be edited if i come across shared realm memory error.
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production
PARAMETER VALUE
NLS_LANGUAGE AMERICAN NLS_CHARACTERSET AL32UTF8 NLS_NCHAR_CHARACTERSET UTF8
When i am trying to load an XSD document its failing with Error-15. When i removed the below line from the xsd doc
It went through fine. The issue is its not supporting ;А-я NCS of Cyrillic alphabet(Russian) . Guess its some kind of character set issue. But i cant identify. The same doc is working fine in 10g. issue is in 11gr2.
Loading of xsd happens from a product interface. header details
running CENTOS 6 and oracle DB 11.2.0 and when i try to launch sqlplus i get the following error:
Error 6 initializing SQL*Plus SP2-0667: Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
problem is, it's telling me to set ORACLE_HOME but I'm not sure where this is to set.
I am loading a Excel file into oracle database using a ORACLE form 6i and i am getting an ORA-302000. This Form run and load database file into database in many pc.
But One of the PC COuld not loading a Excel file into oracle database. Also i can't Create Excel file Database Through form 6i.
after connecting to database using username and password , i get below error message connection is established and able to work asusal,
Enter password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options select 'Welcome to database: ' || name from v$database * ERROR at line 1: ORA-00942: table or view does not exist
I have 1M Records coming from an External Data source as a Flat File (using ETL). Now I need only Yesterday's data only to load in my Database Table.
this can be done using Bulk Load and Filter.
write the CODE.
Second Part:-
Hint: if I need to update only those records been updated Say the Address1 field is updated. So this records need to update in my Master Customer Table.
If I have many fields in table and any records that are modified (coming to me from External Datasource as a Flat file) how to identify and update that record in my Master Customer Table?
I have a .sql file that is used as a wrapper file that when executes within sqlplus (9.2.0.1.0), executes a bunch of .sql files within it. Example below:
Each of the .sql file (A,B,C,D,E) Spools individual output of sql statment within them. Each of the indv .sql file queries different tables with different filters(where) clause.
I would like to capture any error (OS,SQL,DB) into indv error file (A_ERROR.log). The reason being is because later in the process we need to validate if there were any errors before processing and loading the data into our SQL database
While importing dump to the new database, error occurred. Below are the errors -
ORA-02374: conversion error loading table "INS"."GENMST_FINANCIER_BRANCH" ORA-12899: value too large for column TXT_IFSC_CODE (actual: 19, maximum: 15) ORA-02372: data for row: TXT_IFSC_CODE : 0X'4644524C30303031353739A0A0A0A0' [code]...
I would like to know, why such error occurred during the import.
tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:
rakesh@ubuntu:/$ sqlplus "/ as sysdba" bash: sqlplus: command not found [color="#000000"][/color] rakesh@ubuntu:/$ sqlplus bash: sqlplus: command not found
i have also tried to set the oracle_home, oracle path & oracle SID.
find the below configuration parameters which i have set to.
root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server export ORACLE_HOME ORACLE_SID=XE export ORACLE_SID #NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
We have OSB 10.44 installed on 64 Bit Red Hat OS. Is working pretty fine with a Virtual Library that is configured in an Storage Box. Now we have acquired a Physical Storage and we want to duplicate the backups already taken by the Virtual Library into the new Physical Library.
We have 20 drives for the VTL and for the physical we are planning to have the same to duplicate all backups from VTL. That is being done in case Emergency Failures, so we can restore from Physical Library in case the VTL fails.
The question is: Is there any documentation on how to do duplicate backups.?
The duplicate backups copy wont be done in real time. They will be done after the backup is finished in the VTL and then will start the copy in the physical library.
it seems to me that the file tnsnames.ora is not read when i execute sqlplus.whit the command: sqlplus username / password @ servicename i receive the error ORA-12154, while if i pass the whole connection string i can connect without problems
I am getting below error while retrieve the data from client 9.2.0.8.0 installed in SunOS. The job is scheduled fetch lacks of record from the client. In mid of job running getting this error.
Unfortunately still our business using 9i version since our code is supporting only for 9i version.
ERROR: Failed retrieving configuration from database. User: 'XXXX' DB Environment: 'PVS' with error: Database client libraries are inaccessible.
Either the Object Engine has not been linked with the required libraries, or the DLLs for those libraries are not in your search path. For more information, consult the release notes for this Connect product.
I have created TABS using jquery tabs library 1.8 and works right now the problem i want to add multiple-select autocomplete item but this only comes with jquery 1.9.2 and UI 1.10.1 so if i add this reference to the page header the multiple autocomplete works but the entire tab-set is broken due to conflicting versions of jquery libraries.... apex 4.1.
i recently installed an apex plugin but after deinstalling the plugin some of the functionality was still there.I suspected the plugin uploaded a js library and a css file.I found the functions apex_javascript.add_library and apex_css.add in the plugin.Where does apex save the files that are uploaded using those functions?I want do remove then.
In one of the book (Personal Oracle Real Application Clusters: Create Oracle 10g Grid Computing) I have seen the detailed explanation to configure Oracle 10g RAC on external disk- MAXTOR A01A200.
Is it possible to configure Oracle 11g Release 2 RAC with two node using MAXTOR disk?
or Is there any other external disk available which I can use it as a shared storage?
I wanted to setup a two node 11g RAC with ASM at my home for learning purpose. I have read many documents to configure shared storage using NFS, Openfiler, VMsetup etc. Is there any hardware available (something like maxtor disk) which is not much expensive to setup a shared storage ?
When investigating memory usage on HP-UX V3 for my oracle database 11.2.0.3.4 which use AMM, it seems to me that system is not shifting shared SGA memory to private PGA memory when needed but it allocate other memory.The shared memory don't shrink all the memory_target id allocated. VSZ = RSZ
To test i have used this script which will allocate memory in process PGA.
create or replace package demo_pkg as type array is table of char(2000) index by binary_integer; g_data array; end;
[code]...
I have done the same test on a linux machine (Red Hat Enterprise Linux Server release 6.3) and the size of the POSIX shared memory switched (/dev/shm) to the PGA like demonstrated by Tanel Poder in his blog [URL]...
Some shops run Oracle RAC using "conventional" storage, like emc, netapp, etc. Some shops run Oracle RAC using JBOD, just bunch of disks, all redundancy is managed by ASM.
How would you distinct these two approaches? JBOD approach sounds cheaper, so why serious enterprises are still using traditional conventional storage, like netapp and emc?
Way to share or manage the TNSNAMES.ORA file for all oracle clients in same place?I already have a TNSNAMES.ORA configured and running in the machines (locally).The problem is that any change done( ip, port etc), imply in update all files in all the Oracle clients
Just trying to figure out a way to reset a lost sys password.The Customer has a database that were configured by the application provider.They were however kicked out and did not leave any kind of documentation behind
they also configured the passwordfile to disable OS (oracle) user to login to the DB.Is it possible to change the password file with orapwd to set a new password for the sys user?I some how recall that it can only be done if the passwordfile is set to exclusive and not as in this case set to shared.
I scheduled a RMAN backup job to take FULL database backup to a shared network drive.
RMAN Script used:
RMAN> run 2> { 3> allocate channel ch1 device type disk format '\\BACKUP1635\X$\ARC%U'; 4> backup database plus archivelog; 5> release channel ch1; 6> }
Environment: Windows server 2003 OS and Oracle 10.2.0.4.0
Iam facing below error.
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch1 channel at 02/20/2011 18:19:46 ORA-19504: failed to create file "\\BACKUP1635\X$\ARC1BM55JL8_1_1" ORA-27040: file create error, unable to create file OSD-04002: unable to open file O/S-Error: (OS 5) Access is denied.
I checked shared network drive and found READ/WRITE access for me. I am able to take RMAN backup in local system without any issue.
If I have specify the SGA_TARGET, do I still need to specify the amount of memory for SHARED_POOL_SIZE? I thought once the SGA_TARGET, auto memory management is in place and SHARED_POOL is not neccessary.
When i try to extract create statement of table i get below error message.
SQL> SQL> set heading off SQL> set pagesize 0 SQL> set long 1000000 SQL> set feedback off SQL> select 2 dbms_metadata.get_ddl( 'TABLE','CATALOG_TBL','JACK') 3 from 4 dual 5 /
ERROR:
ORA-04031: unable to allocate 104 bytes of shared memory ("shared pool",
"SELECT /*+rule*/ SYS_XMLGEN(...","SQLA^fc8f5280","qecsub : qkxrPXformQbc") ORA-06512: at "SYS.DBMS_METADATA", line 2625 ORA-06512: at "SYS.DBMS_METADATA", line 2668 ORA-06512: at "SYS.DBMS_METADATA", line 2983 ORA-06512: at "SYS.DBMS_METADATA", line 3897 ORA-06512: at "SYS.DBMS_METADATA", line 5678 ORA-06512: at line 1
Note: ---- I am executing this command from another user 'DEMO' which has got DBA privilege.
how to fix this error and extract the create table statement.