Oracle what are the "grantable" for?

I am a newbie of oracle database.I study oracle database using Oracle Database 10g Express Edition Release 10.2.0.1.0I have created 2 users, TESTING and TESTING2I have created a table SKU for TESTING (the owner of table SKU is TESTING)I set the GRANTS of table SKU.please see this image : http://img6 ...

Problems with Oracle RAC 10gR2 on Solaris 9

all. Recently I have got into problems with RAC, I have posted this on OTN (see the thread here). I thought I would post it here as well, to see if any of you could shed some light. For those who doesn't still have an OTN account, I'm going to repeat it here.Quote: Hi all. Recently, we've setup a Su ...

Oracle Problems with Privileges

I have a development env of my application on my desktop, for which I am using the developer's version of Oracle 9.2.0.1.0.My tables are spread across 3 different schemas (A, C and S)and I need a common role/ user to be able to access all 3 schemas.... Seems pretty straight forward but I have been b ...

Oracle ORA-00600:internal error code

My instance is automatilly crashing after some time after startup by throwing following error, plz help me ksdpec: called for event 13740 prior to event group initializationStarting up ORACLE RDBMS Version: 10.2.0.1.0.System parameters with non-default values:processes = 150__shared_pool_size = 3313 ...

Oracle Slow startup and performance problem

When I am trying to save data through forms 6i , forms window is getting killed andI can see the below pasted message in alert log, corresponding to every kill of forms window :Instance recovery: looking for dead threadsInstance recovery: lock domain invalid but no dead threadsAnd , when i restart t ...

Oracle Create Database Error in RAC manually ! ORA-00600 2901

anyone Can help ?Tks !alert_RACDB1.log Mon Oct 9 00:17:08 2006Starting ORACLE instance (normal)Mon Oct 9 00:17:08 2006Global Enqueue Service Resources = 64, pool = 1Mon Oct 9 00:17:08 2006Global Enqueue Service Enqueues = 128Mon Oct 9 00:17:08 2006WARNING: EINVAL creating segment of size 0x000000000 ...

Oracle SHUTDOWN: waiting for detached processes to terminate

I have cold backups running every night and before the backup session starts, we have a cronjob 'srvctl stop -p prod' where our db servers are running on RAC. but starts from last saturday, our backup session for raw device failed. when look at the alert log, it gives as (example on 15th November 20 ...

Oracle Shutdown: waiting for detached processes to terminate

Shutdown: waiting for detached processes to terminateHi guys, I have an 9.2.0.1 database running on HP-UX 11.00 (64-bit). After a long period of successful shutdowns, it is now prompting me with "SHUTDOWN: waiting for detached processes to terminate". If I do a shutdown abort, I can bounce my databa ...

Oracle RAC Hang

2x Oracle 10gR2(10.2.0.3) , Windows 2003 EE( 9GB RAM).My database was hang (two node in the same time). At Tue Feb 05 14:36:18 2008 every session was hang, i canot log on SYS. Windows eventslog is empty and no errors in storage array. after the node was hang i wait few minutes, but nothing was chang ...

Oracle problem with download_my_file

I implemented a file upload/download application (like in the demo)and executed the GRANT statement.GRANT EXECUTE ON download_my_file TO PUBLIC;The statementSELECT * FROM user_tab_privsWHERE TABLE_NAME LIKE '%DOW%'ORDER BY TABLE_NAMEreturns:GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE GRANTABLE HIERAR ...

Oracle Download procedure not found on server.

I created a File Upload functionality using the Oracle tutorial (http://download.oracle.com/docs/cd/B31036_01/doc/appdev.22/b28839/up_dn_files.htm#CIHBFCDH). The files are copied from the flow table into a custom table named SR_ATTACHMENTS with the following structure:Column Name Data Type Nullable ...

Oracle user priviliges and sqldeveloper

So I have a database called nort1 and on that database I have some tables that were created using the sysdba account, but are just regular ordinary tables (created with create table values ();Well I created a new user (scen1) and tried to grant it permissions to those tables, so that I wouldn't have ...

Oracle Problem downloading BLOB from table

I've seen several posts on this site regarding how to setup a report where the user can click on a link and download a file from a table. However, I'm getting an error when actually executing this and clicking on the link to download the file. Straight from the Oracle docs:[http://download.oracle.co ...

Oracle ASM diskgroups disappeared...

I have awful situation. Today after update of VMware ESX server our RAC nodes failed. ASM failed to mount diskgroups (I've checked disks permissions, they are OK) with following messages:Mon Apr 6 15:11:41 2009lmon registered with NM - instance id 2 (internal mem no 1)Mon Apr 6 15:11:42 2009Reconfig ...

Oracle 11gR1 RAC database creation(DBCA) on SG 11.18 HP-UX11.31 IA cluster.

My Oracle 11gR1 RAC database creation(DBCA)on SG 11.18 HP-UX11.31IA Cluster hangs @52%.Please find alert log file below. Please note that i didnt face any issues with Clusteraware and RAC binaries installion and it all went fine.Only Problem that am facing is while creating RAC database DBCA hangs @ ...

Oracle RAC error log

WE have Oracle 10.2.0.1 on IBM AIXI recently found this error in alert logSun Oct 25 08:30:42 2009Errors in file /Oracle/admin/KKMS/udump/kkms1_ora_888978.trc:ORA-07445: exception encountered: core dump [] [] [] [] [] []ORA-00604: error occurred at recursive SQL level 1ORA-01000: maximum open cursor ...

Oracle Table Access Path

I am using oracle 10g on windowz xp. I am giving below query :SQL> ED Wrote file afiedt.buf   1 SELECT GRANTEE,PRIVILEGE,GRANTABLE FROM DBA_TAB_PRIVS 2 WHERE 3 OWNER='SCOTT' AND 4* TABLE_NAME='EMP' SQL> /    GRANTEE PRIVILEGE GRA ------------------------------ ------------------ ...

Problems with Oracle RAC 10gR2 on Solaris 9

all. Recently, we've setup a Sun Cluster consisting of two V490 box that are scheduled to go in production soon. We have installed into this cluster Oracle RAC 10gR2 (10.2.0.2.0) and everything went fine. The application and all are working flawlessly. However, we've now detect some issues with it. ...

Oracle object privilege question

Hi, the oracle documentation says:A user automatically has all object privileges for schema objects contained in his or her schema. A user can grant any object privilege on any schema object he or she owns to any other user or role. A user with the GRANT ANY OBJECT PRIVILEGE can grant or revoke any ...

Oracle ORA-03113: end-of-file on communication channel error

I am new to oracle. I need your help.I got oracle error on client site while running SQL.Oracle ORA-03113: end-of-file on communication channel error Process ID: 18805 Session ID : 1610 Serial number: 15367 I looked alert.log which is given belowFri Apr 02 14:36:27 2010 Thread 1 advanced to log sequ ...

Oracle The requested URL /pls/apex/ procedure was not found on this server

I'm moving applications to a new server and am running into issues with the file download procedures.I received the following error when trying to download a blob using the procedure: ForbiddenYou don't have permission to access /pls/apex/PDSQADB.CUSTOM_IMAGE_DISPLAY on this server. Based on this po ...

Oracle RAC - ASM Issue - ASM Mounted,but not accessible.

Oracle DB: 10.2.0.2 - AIX 5.3I have a problem where ASM is mounting and then when I try and start the instance, it mounts but then terminates because it is unable to create the archive log on the diskgroup. It sounds permissions related as you will see in the error message in a moment, but I cannot ...

Oracle Streams cannot create an index

I am currently implementing an Oracle Streams setup to stream a schema from one database to another database. While I have been able to overcome most problems so far, I currently have an issue where the streams apply process cannot create an index in the destination.I have effectively disabled VPD o ...

Oracle 9i RAC DBCA problem

Oracle 9i Rac (9.2.0.6) on Windows Server 2003 Ent. SP2 (with latest Windows patches).The RAC consist of 2 nodes, install based on Metalink Note: 178882.1, during installation I have run into some bugs, but the clustercheck said ok, the services runs fine now, both of them (clustercheck, servers) se ...

Global Resource Directory frozen when startup Oracle after power failure

Oracle 12.2.0.2 on redhat 5.2, 3 node RAC. Data/redo and 2 of the 3 control files are on ASM. We had a power failure when all systems startup and file system is back but Oracle did not started. Got errorSQL> startup pfile='?/dbs/initCchprd2_64crash.ora' ORACLE instance started.   Total Syste ...

Oracle 2 Node RAC abnormal behaviour

Platform: "HP-UX 11.23 64-bit"Database: "10.2.0.4 64-bit"RAC: 2 Node RAC setup Our RAC setup has been properly done and RAC is working fine with load balancing i.e clients are getting connection on both instances. BUT the issue I am facing with my RAC setup is High Availability testing. When I send ...

Oracle +ASM2 unable to start following GI Upgrade from 11.2.0.1 to 11.2.0.2

Not going anywhere fast or far with MOS, so I thought I would ask for help here.Following an out of place upgrade of GI 11.2.0.1.2 to 11.2.0.2 on a 2 node cluster running OEL 5 the asm instance on node 2 is failing to start, OCR and voting are stored within asm. Patch 9706490 was applied before star ...

jQuery and PHP/Oracle interaction

I'm building a small web system for a group project in my database class. Basically how this works is someone searches for flights by departure city, destination city, date, and time. From there, results are shown in a table and users should have the ability to select which flight they want using a ...

Data Migration: Adabas to Oracle 8

HiWe currently need to export some data from Adabas (on OpenVMS) and import to a new Oracle 8.1.7.4 database.Can anyone advise on best procedure? Scripts, tools or other metods etc. ...

Adabas migration to Oracle

I need to migrate a database from Adabas to Oracle. I have the database structure in secuential files, and I thought to use SQL*Loader scripts to read the data, but the problem is that I don't know how to manipulate "multiple-valued" fields or groups.Any idea?????Thnks in advance. ...

How to join data from Adabas and Oracle?

I am recently working with Adabas. Also we have a database on oracle. We need to receive data from both databases and process them together. Please, suggest me how do it? ...

oracle LPAD corresponding func. IN db2

Does anybody have any clue for corresponding DB2 function of LPAD of oracle!thks in advance! ...

db2 export and db2look and Oracle full database export

Oracle full database export generates 'dmp' file that carries all objects and content in database. (May be used for database recovery, tablespace recovery, object recovery, or data recovery, in some extent.Or recreate database)What are the command, utilities and or functions (excluding db2 backup) i ...

fetch object using oracle API

I cannot fetch object using oracle functions defined for php3. Can anyone help me????? ...

Extracting DB2 data to Oracle

We are beginning to look at integrating data from an IBM DB2 database running under VM on a mainframe into Oracle applications. Currently, we have Oracle 8i, but will migrate to 9i within the year. Does anyone have any experience with extracting data directly from a DB2 database into an Oracle appli ...

Dtsession on AIX for Oracle Application Server 10g (10.1.2.0.2)

How to maintain Dtsession process to run in background (always running)?The problem occurs when running Oracle Application Server, we need to keep this process to make Oracle Application Server running well.Symptom: emctl must execute on console or X-browser, and the session must keep alive. Cause: ...

Display Server Problem with Oracle Apps

I am facing the isseu with DIsplay server running on IAX to integrate with Oracle Apps.It does not let Oracle apps to connect to display server for any report to process.i want to let every cleint connect to displaya server.this i am doing with xhost +.But its not working...it constantly hangs there ...

DB2 equivalent to Oracle's Partitioned Tables

I have a table in Oracle that is designed using ranged partitions. I am converting the database to DB2 and wanted to know if version 7.2 has a similar function. ...

how to insert items dynamically to list box from database like oracle

please tell how to dynamically insert items in list box in javascript.That is . When ever new element in stored in oracle that should be listed in listbox ...

Simple Question - DB2 UDB & Oracle

When looking at IBM web site for DB2 UDB i found that DB2 UDB EE runs on Windows 98/NT/2000. Can i install or anyone worked with DB2 UDB EE on Windows ME (Milliniun Edition). If yes, can you expalin how different it is from Windows NT/200? I need to work with DataJoiner, DB2 Relational Connect on DB ...

Oracle=sysdate; DB2=?

I want to convert this oracle query in DB2 :SELECT ...WHERE TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') > 20020101000000Could you help me plz? ...

Merge Statement In DB2 as in Oracle

HelloI was wondering if there is a MERGE statement in DB2 as in ORACLE and if not, any similar statement ?Merge statement actually updates the rows in TABLE B if present and Inserts the rows if not present from TABLE A( In Oracle) ...

trigger in Oracle

I am trying to create a trigger on a table in Oracle that will create a sequence each time a row is inserted into a table. When I try to compile the trigger I get a message that the trigger is invalid.The syntax I am using is:create or replace trigger on_part_insertbefore insert on PARTfor each rowb ...

Connect to Oracle from MYSQL

I'd like to know if it's possible (and how :-)) to get connected from MYSQL to Oracle (something like an Oracle database link). I'd like to make something like this (from the MYSQL database) : insert into MYSQL_TABLE (select some_fields from ORACLE_TABLE@DISTANT_DATABASE) ; Is it possible ? Thx by a ...

Using IBM's MQSeries Integrator to migrate data from DB2 to Oracle 9i database

We have a project requirement wherein our client's data from DB2database running on AS400 needs to be migrated to Oracle 9i database.Can anyone tell us how it can be done? We have gone thru redbooks and whitepapers, but we are not clear as tohow to go about doing this?We would like to know things li ...

Oracle Discussion Forum Availability

Is the software used to provide these discussion forums available for use by other organisations. If this software is not the propriety of Oracle could you please advise who produces it. ...

Oracle certification

I am an experienced user of both PL/SQL and SQL itself, but most of the certified pathways seem to be geared towards knowing one of the Oracle toolset e.g. Designer/Developer 2000. Does anyoneknow of a certified pathway I can take for PL/SQL and SQL, since I have hardly any toolset knowledge. ...

Producing an Oracle enviroment

I want to try and work for my application certification from home. Not having access to any oracle software, would like to know best way to get software so as to be able to practice for cert. download does not work keep getting server hang up message. and oracle wants to sell the software $6000 for ...

download of oracle 9i database

iam not able to download the oracle 9i database from the site..guess the link ain't workin..any solutionss..??? been trying for the past 3 weeks..gagan ...

Oracle Installing 8.1.7 on Pentium 4 causes problems with 7.3.4 support files

A client has stated just today that after they installed Oracle 8.1.7 onto a Pentium 4 client environment running Windows 2000, they could no longer use 7.3.4 support files. This seems to affect any application developed in PowerBuilder or other 3rd party tools.Has anyone heard of this? Is true, is ...