|
Enterprise manager is Not Connecting to database Hi I installed oracle 10g on my system the installation was successfull but in the enterprise manager console 1.database instance is down 2.Listener is up and running 3.Agent Connection to Instance Status Failed Details ORA-12505: TNS:listener does not currently know of SID given in connect descript... 6 Jul 2008 19:07
Differences in BULK COLLECT between 9i and 10g? Oracle 9i 9.2.0.1.0, Windows XP Pro In playing around with the 9i on my desktop I've come across something which has me a bit baffled. In the first code segment I have a cursor where I return a row based on a database table. I then BULK COLLECT into the nested table which is defined on the database table. ... 6 Jul 2008 14:00
LIKE operator on CHAR column when there is no wildcard character We are trying to upgrade our database from Oracle 9i to 10g. We have a CHAR(30) column in a table. When we perform string comparisons using '=' operator (Eg.....where col = 'XYZ' ) the trailing spaces are ignored, which is perfectly fine (both in 9i & 10g). When we use LIKE operator without specifying any... 6 Jul 2008 10:56
Trasaction between procedure calls. Problem Statement: Ive written a Stored Procedure which has several insert statements. After inserting these statements ,its calling other stored procedure which again has some insert statements. Now if the second procedure has some error, everything should be rolled back. The skeleton of the procedure is as fo... 6 Jul 2008 08:53
create two database Hi guys, I created two database but I have some problem : 1.How I can startup two data base or one of them ? 2.After create second database the listener is point on first data base ,How I can start listener for second database ? 3.Can not login to second database? Thanks ... 6 Jul 2008 07:52
JDBC Driver 8.1.6 Hello, Is it possible to download somewhere JDBC Driver 8.1.6 ? I would need to connect an old Oracle 7 database (The oldest one I found is 8.1.7) Thanks in advance. ... 5 Jul 2008 15:35
is there anyway to get the 10g|11g DBMS_CRYPTO stuff for 9i? hello forum, i know about DBMS_OBFUSCATION_TOOLKIT in 9i. but, is there anyway to get the 10g|11g DBMS_CRYPTO stuff for 9i? for example, if i get a hold of {ORACLE_HOME}/rdbms/admin/dbmsobtk.sql from a 10g/11g installation, would it work if i plonk it into my 9i installation? if so, what else would i need to ... 5 Jul 2008 13:32
Oracle support is sub-optimal On Jul 4, 3:27 pm, "gym dot scuba dot kennedy at gmail" <kenned...(a)verizon.net> wrote: snip I hope Oracle isn't going the way of the Detroit Auto makers of the early 80's until very recently. Think you have no competition and then just have quality and customer service suck. Ummm well not exactly. F... 5 Jul 2008 13:32
create database fatal error Hi I am having some serious problems with my create data procedure. After the CREATE DATABASE statement i run the catalog.sql and catproc.sql scripts. During the catproc script it after a while encounters a massive amounts of errors ending up in a fatal error whihc terminates the session. All statements afte... 6 Jul 2008 19:07
Fresh Enterprise Manager Install Can't connect "Connection Closed" DavidK wrote: On Jul 3, 2:18 pm, DavidK <davidknollh...(a)yahoo.com> wrote: On Jul 3, 1:57 pm, sybra...(a)hccnet.nl wrote: On Thu, 3 Jul 2008 12:59:40 -0700 (PDT), DavidK <davidknollh...(a)yahoo.com> wrote: I've an 8.1.7 oracle home on an xp pc. I installed OEM 9.2.0.1 of cli... 4 Jul 2008 00:49
SELECTing from a DML statement DB2 allows one to select from an insert, update, or delete, e.g.: select * from old table (delete from x where y = 1); --OR-- select * from new table (update x set y = 1 where z = 2); --OR-- select * from final table (insert into x (c1) values (1)); Is there any equivalent in Oracle? Thanks and reg... 4 Jul 2008 15:07
ASM I/O size Hello, I'm running under 10.2 database on AIX5.3L I have disk group ASM_DATA which has 100 SAN equi-sized (256GB) disks/ luns. with MBRC of 16 & Block size of 16K , When I read a table of 10GB via FTS, what should be my I/O size/lun ? Should my I/O size be same for all the LUNs? 1) ASM level 2) I/O stats (io... 3 Jul 2008 17:39
Fresh Enterprise Manager Install Can't connect "Connection Closed" I've an 8.1.7 oracle home on an xp pc. I installed OEM 9.2.0.1 of client cd. I created repository tablespace and user and granted recommended roles. i changed my oracle home to 9. I imported the database tree and after I enter the login and password I get a popup saying "Connection Closed" Any idea? David... 4 Jul 2008 03:52
Weird Query Hi, I have a query which is this: SELECT cnt || ':' || t_id cnt_t_id FROM (SELECT COUNT(*) cnt, t_id FROM zc_body zb, zc_type zt WHERE zb.t_id = zt.id GROUP BY t_id); The output is this: 101:18 49:27 47:36 378:9 118:10 76:15 28:16 38:19 However, they want the output like th... 3 Jul 2008 15:36
why ora1801 Hi My proc program report a ora1801 error. My code is like this -----tblPdspTxnMon.h------------ typedef struct { char sa_pri_key[ 36 ]; char sa_related_key[ 36 ]; char sa_alt_key[ 36 ]; char sa_lock_ind[ 2 ]; char sa_rout_fwd_id[ 14 ]; char sa_rout_rcv_id[ 14 ]; char... 4 Jul 2008 21:15
The light dawns - public synonym called SYS - how to drop? With reference to my other post on various SYS packages being unavailable, I now know the cause. Despite my declarations of confidence, it turns out that one of our guys (a student on work placement as it happens) wanted to create a public synonym and called it "SYS". 2 things 1) am surprised that Oracle (10g... 4 Jul 2008 16:09
What is "automated batching of data from computer to computer" in Named User License? Hello, I have Oracle Sales too, but if you could let your light shine on what the following line from the Named User Plus license means/implies, it is appreciated (http://www.oracle.com/corporate/pricing/eplext.pdf). "Automated batching of data from computer to computer is permitted." Our sales rep tries to co... 4 Jul 2008 03:52
substr or like Hello everyone, I'm looking for increasing my database performance, I ve just noticed, in a heavy query that using substr instead of like is very faster : 350ms vs 30s !! But in the other hand, when i count all the element in the table with the 2 method, the like is better : select count(*) from a_t_c where... 3 Jul 2008 13:32 |