Friday, 3 July 2009
|
Hi , Are u familiar with Oracle Cl...  arabe 19:04:13 |
| | Hi ,
Are u familiar with Oracle Clinical? I need access to do some practice in writing the Validation Procedures. Any advice.
Thanks
LowLifeD |
| | Add comment |
Wednesday, 13 May 2009
|
| [?] SYSDBA audit Vladimir 18:41:03 |
| | Hello,
I need to audit SYSDBA activity, so I turn audit_sys_operations to TRUE, and
SYSDBA/SYSOPER activity is being placed into Windows Application Log. Is
there a way to place those activity records into DB or somehow get an access
to those records from SQL?
Thank you for your time,
Vladimir.
|
| |  9 answers | Add comment |
Thursday, 7 May 2009
|
| Running Setup in Oracle Developer Suite 10g for windows XP Pro SP2 Jean-Benoit MORLA 09:54:34 |
| | Hi,
I can't get past the first screen in the setup/installer of Oracle Developer Site.
There are 3 fields:
Source -> points to the products.jar file
Destination ->Origin Oracle Home directory is a variable "OraDb10g_Home1"
Destination ->Path:C:\oracle\product\10.1.0\db2
Now if I click the button "Installed Products",
I see a tree with a "OraDb10g_Home1" leaf and the message: not available.
How can I fill these fields with the correct values?
Many thanks
jbmorla@tiscali.fr
|
| | 7 answers | Add comment |
Wednesday, 10 December 2008
|
| How to delete a lock Dn.Perl@Gmail.Com 16:12:08 |
| |
A table has been locked and I want to free it. I have
looked at v$lock and v$session objects, but I don't know
what entry to delete from where. What I do know is that
nobody is using the database right now, and it is okay
for me to delete the appropraite entry (whether from
v$lock or v$session). Out of the first 5-10 links which
turn up in a google or google-groups search for "delete
lock oracle", no link provides a quick route to delete
a lock and free the locked object.
Please advise.
|
| | 7 answers | Add comment |
Tuesday, 9 December 2008
|
| 9i to 10g migration Dave 22:57:51 |
| | OK, Im having a bit of difficulty here and hoping that the knowledgeable
folks here at cdos can help me out:
We are upgrading a 9iR1 database to 10gR2. At the same time, we are
upgrading the hardware. Both platforms are Win2K. Right now, I am
attempting to transfer the 9i instances to the 10g server. I had thought I
could do this with RMAN and the DUPLICATE command. However, this doesnt
seem to work out: RMAN ends with the following error:
printing stored script: Memory Script
{
Alter clone database open resetlogs;
}
executing script: Memory Script
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 11/20/2005 09:49:29
RMAN-10039: error encountered while polling for RPC completion on channel
clone_default
RMAN-10006: error running SQL statement: select act from x$ksusex where
sid=:1 and serial=:2
RMAN-10002: ORACLE error: ORA-03113: end-of-file on communication channel
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: alter db
RMAN-06136: ORACLE error from auxiliary database: ORA-01092: ORACLE instance
terminated. Disconnection forced
RMAN-06097: text of failing SQL statement: alter database open resetlogs
RMAN-06099: error occurred in source file: krmk.pc, line: 23265
RMAN-04014: startup failed: ORA-32004: obsolete and/or deprecated
parameter(s) specified
Recovery Manager complete.
Examination of the alert log indicates that the following obsolete and
depreciated parameters are listed in the pfile:
Obsolete system parameters with specified values:
enqueue_resources
End of obsolete system parameter listing
Deprecated system parameters with specified values:
log_archive_start
max_enabled_roles
sql_trace
End of deprecated system parameter listing
So my first question is: Where can I find how to enable similar
functionality in 10g? Of particular concern to me is log_archive_start.
(If I have to disable the others for the time being, it shouldnt affect
much.) I am not finding the Oracle Database Upgrade Guide helpful in this
regard as it only tells me that the parameter is depreicated.
However, I am unsure that this is the actual problem as I can start and stop
the instance manually(without opening it) and while I get a warning, it
works. The docs indicate that this is expected, a warning, but the db will
open. Futher examination of the alert.log indicates the following
additional error, which I suspect may be the actual problem:
Sun Nov 20 09:49:25 2005
SMON: enabling cache recovery
Sun Nov 20 09:49:26 2005
Errors in file d:\oracle\admin\udump\orcl\orcl_ora_900.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Sun Nov 20 09:49:26 2005
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Sun Nov 20 09:49:26 2005
Errors in file d:\oracle\admin\bdump\orcl\orcl_pmon_684.trc:
ORA-00704: bootstrap process failure
This ORA-00704 is repeated several times, followed by:
Instance terminated by USER, pid = 900
ORA-1092 signalled during: alter database open resetlogs...
<EOF>
I thought there might be an UPGRADE option to the DUPLICATE command, but
docs do not seem to list one. I would appreciate any input as to what I am
screwing up here, or how to accomplish what I am trying to do. I would
prefer not to copy the os files over as that would require an outage of the
production db to develop the test db, and a longer outage when we switch
over, but that seems to be the only option right now.
Thanks for any and all help.
Regards,
Dave
|
| | 7 answers | Add comment |
Tuesday, 21 October 2008
|
| set autocommit off; Guest 09:09:40 |
| | Anyone know why Oracle won't let me do this
set autocommit off;
in a PL/SQL procedure?
It won't take this:
create or replace procedure addname
as
begin
set autocommit off;
insert into test values('testname');
commit;
end;
|
| | 4 answer | Add comment |
Monday, 13 October 2008
|
| Urgent help on using OCCI in Linux. Dragon_num_one 08:38:44 |
| | Hello there,
I am in urgent need to solve the following problem regarding use Oracle OCCI
under Linux.
Could someone help me to solve this problem? Is OCCI so difficult to use?
the crash is caused by using getString(). If I commented out the second and
third printf(), the program will be having no problem.
while (rs->next())
{
printf("Book ID = %d\n", rs->getInt(1) );
printf("Title = %s\n", rs->getString(2).c_str() );
printf("Auther = %s\n", rs->getString(3).c_str() );
printf("Price = %d\n", rs->getInt(4) );
}
Thanks so much.
Steven
==================================================================
The OCCI I downloaded back is version 10.2.0.2, Instant Client Package -
Basic
The following are some info of it.
Currently we use gcc 4.0.2 (gcc (GCC) 4.0.2 20051125 (Red Hat 4.0.2-8)),
maybe they are not compatible.
Oracle C++ Call Interface - Downloads
OCCI for gcc 3.4.3 (Linux) Download (tar)
OCCI 10.2.0.1.0 support files for building applications with gcc
version 3.4.3 on RedHat Linux AS 4.0
Instant Client Downloads
for Linux x86
Version 10.2.0.2
Instant Client Package - Basic: All files required to run OCI, OCCI,
and JDBC-OCI applications
instantclient-basic-linux32-10.2.0.2-20060331.zip (33,901,074
bytes) (cksum - 2602139346)
*Instant Client Package - SQL*Plus: Additional libraries and
executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-10.2.0.2-20060331.zip (740,155
bytes) (cksum - 3809431917)
*Instant Client Package - SDK: Additional header files and an example
makefile for developing Oracle applications with Instant Client
instantclient-sdk-linux32-10.2.0.2-20060331.zip (602,224 bytes)
(cksum - 3391827328)
I have been trying to find out what cause my app crash.
Here is the compiling and test result.
[LinuxMOne:stang] /home/stang/Desktop/occi/test> make
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/home/stang/Desktop/occi/
include -c -o test1.o test1.cpp
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/home/stang/Desktop/occi/
include -locci -lclntsh -lociei -lnnz10 -locci -lclntsh -lociei -lnnz10 -o
test1 test1.o
/usr/bin/ld: warning: libstdc++.so.5, needed by
/usr/lib/gcc/i386-redhat-linux/4.0.2/../../../libocci.so, may conflict with
libstdc++.so.6
[LinuxMOne:stang] /home/stang/Desktop/occi/test> test1
Enter main ...
Enter login_info ...
====Restriction List====
=name= =ip= =port=
name = www.shaw.ca
ip = 33.33.33.33
Segmentation fault
[LinuxMOne:stang] /home/stang/Desktop/occi/test>
Now I am thinking it must be something to do with the compile warning:
/usr/bin/ld: warning: libstdc++.so.5, needed by
/usr/lib/gcc/i386-redhat-linux/4.0.2/../../../libocci.so, may conflict with
libstdc++.so.6
Any idea and solution?
Thanks,
Steven.Tang@mobidia.com
Now I changed the Linux to be RedHat EL AS 4 and gcc 3.4.5-2, I still got
the program aborted:
*** glibc detected *** free(): invalid pointer: 0x09e557e0 ***
Aborted
See the following info for detail.
Anyone there could help me please advise me what was wrong!!!
Thanks,
Steven
[magdev@magdev test]$ uname -a
Linux magdev 2.6.9-34.EL #1 Fri Feb 24 16:44:51 EST 2006 i686 i686 i386
GNU/Linux
[magdev@magdev test]$ gcc --v
Reading specs from /usr/lib/gcc/i386-redhat-linux/3.4.5/specs
Configured with:
../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info
--enable-shared --enable-threads=posix --disable-checking --with-system-zli
b --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk
--host=i386-redhat-linux
Thread model: posix
gcc version 3.4.5 20051201 (Red Hat 3.4.5-2)
[magdev@magdev test]$ make
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/usr/include/occi -c -o
test1.o test1.cpp
g++ -Wall -DLINUX -D_GNU_SOURCE -D_REENTRANT -g -I/usr/include/occi -locci
-lclntsh -lociei -lnnz10 -locci -lclntsh -lociei -lnnz10 -o test1 test1.o
/usr/bin/ld: warning: libstdc++.so.5, needed by
/usr/lib/gcc/i386-redhat-linux/3.4.5/../../../libocci.so, may conflict with
libstdc++.so.6
[magdev@magdev test]$ test1
-bash: test1: command not found
[magdev@magdev test]$ ./test1
Enter main ...
Enter login_info ...
Enter run() ...
Enter insertRows ...
SCOTT's salary = 60000, commission = 6000
Sleep for awhile to check ...
Enter deleteRows ...
The book table has book:
Book ID = 1
Title = The C++ Programming Language
*** glibc detected *** free(): invalid pointer: 0x09e557e0 ***
Aborted
Steven Tang
|
| | 6 answers | Add comment |
Tuesday, 23 September 2008
|
| Oracle Timestamp Faby 12:35:28 |
| | Hi,
I was wondering how I should convert a timestamp to compare it to
'01-AUG-2006'.
Is any of the following right?
TO_CHAR(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'
TO_DATE(TRUNC(MYTIMESTAMP)) < '01-AUG-2006'
TO_CHAR(MYTIMESTAMP,'DD-MON-YYYY') < '01-AUG-2006'
If you could give a brief explaination of why I am getting a different
result for each of the previous answer, i would really appreciate.
Thank you
Faby
|
| | 5 answers | Add comment |
Monday, 22 September 2008
|
| Time diff Eugene 15:29:29 |
| | Hi all,
I have two columns representing start_datetime and end_datetime. They
look like 1085008980 and 1085009504 respectively. They are stored in
UTC format (number of seconds from '15/12/1970').
How do I calculate difference in hours:minutes:seconds?
Thanks,
Eugene
|
| | 9 answers | Add comment |
Monday, 25 August 2008
|
| Rollup Aggregation Tuning Pawel 11:38:04 |
| | Hi,
I'm working on a data warehouse solution for fact data aggregation.
Short description:
there's base level fact table:
TIME_ID, GEO_ID, PROD_ID, AMOUNT1, AMOUNT2....
Fact data is 3-dimensional with, say ~500 nodes in each of the hierarchies
lowest level (input data).
Rows are distinct. So there's 500^3 rows, with low cardinality for each
separate dimension column.
I also have a flattened time hierarchy with 3 levels.
Flattened with this procedure:
When graph is (text-mode compliant  ...
X (year)
/ \
/ \
P Q (halfs)
/ \ \
/ \ \
A B C (lowest level)
...HIER table rows look like this:
Lvl1, Lvl2, Lvl3
----------------
X P A
X P B
X Q C
FACT table is joined with HIER (WHERE TIME_ID = Lvl3)
Then ROLLUP(Lvl1, Lvl2, Lvl3) is used for full aggregation on time
dimension.
[The lowest level (Lvl3) might be skipped and gotten from FACT table -
it's written here for clarity.]
I'd like to know your opinions about the best way to tune the performance
of this query - or even rewrite it to leverage other Oracle features (e.g.
Dimension objects).
Fact table needs to be FULLy ACCESSed, but when GROUPing, there's sorting
needed as far as I know, so what about bitmap indexes? Or concatenated
bitmap index?
Then PARALLEL - will Oracle use it's advantages here?
Would partitioning help?
Thanks,
Pawel
|
| | 2 answer | Add comment |
Thursday, 31 July 2008
|
| NMO not setuid-root (Unix-only) Howard J. Rogers 08:12:13 |
| | This has probably been asked and answered somewhere before now, but
Google only returns three answers and one of those is in fluent Japanese
(and the other two don't help).
Oracle 10g on Linux, Enterprise Manager, attempting to alter the archive
log mode of the database: it asks me to supply node and database
credentials, and when I do, I get this error:
RemoteOperationException: ERROR: NMO not setuid-root (Unix-only)
Any suggestions? Normally, Enterprise Manager works fine. I can't think
what I've done or haven't done this time around.
Regards
HJR
|
| | 11 answers | Add comment |
Thursday, 29 May 2008
|
| Forms Error in 10g opening 6i PLL Lewis C 07:20:14 |
| | Question for the forms gurus.
A coworker of mine is tying to open a PLL developed in Developer 6i
using Developer 10g. She can open forms, menus, etc but when she
tries to open a PLL, she gets PDE-PL1018, PLL <pllname> does not
exist. The pllname that it lists is the PLL she's opening, not an
attached PLL.
The only references I can to this error are when the attached
libraries are not in the form path registry (FORMSxx_PATH or
ORACLE_PATH) variable. Metalink Note:121346.1.
This doesn't apply in this case since it can't find the PLL she's
opening as opposed to an attached PLL. My next step is a TAR but I
was hoping someone here had seen this.
Thanks,
LewisC
-----------------------------------------------------------
Lewis R Cunningham
Author, ItToolBox Blog: An Expert's Guide to Oracle
http://blogs.ittoolbox.com/oracle/guide/
Topic Editor, Suite101.com: Oracle Database
http://www.suite101.com/welcome.cfm/oracle
Sign up for courses here:
http://www.suite101.com/suiteu/default.cfm/416752
-----------------------------------------------------------
|
| | 2 answer | Add comment |
Wednesday, 28 May 2008
|
| PL SQL Cursor beginner Mrique 21:02:33 |
| | Hi
I'm beginning with PL SQL and try to learn cursors usage
I get ora 920 with this on line "WHERE WHERE_NORME "
What i'm trying to do is to fetch where conditions stored in a table,
and reuse it in dml order in my cursor.. but I must have missed
somethin ? any pl sql killer having one minute for me ? thank's
CREATE OR REPLACE PROCEDURE Feed_Anomalie AS
CURSOR NORMES IS
SELECT ID_NORME, TABLE_NORME, WHERE_NORME FROM QTE_NORMES ORDER BY
ID_NORME;
ID_NORME QTE_NORMES.ID_NORME%TYPE;
TABLE_NORME QTE_NORMES.TABLE_NORME%TYPE;
WHERE_NORME QTE_NORMES.WHERE_NORME%TYPE;
BEGIN
OPEN NORMES;
LOOP
FETCH NORMES INTO ID_NORME , TABLE_NORME , WHERE_NORME ;
EXIT WHEN NORMES%NOTFOUND;
INSERT INTO QTE_ENREGISTREMENT_NC
(NUM_DOSS, DATE_NC, LAST_DATE_NC, REF_NORME)
SELECT DISTINCT CLE_DOSS, SYSDATE, SYSDATE, ID_NORME
FROM (
SELECT
DOSSIER.CLE_DOSS, SYSDATE, SYSDATE, ID_NORME
FROM TABLE_NORME
WHERE WHERE_NORME
MINUS
SELECT QTE_ENREGISTREMENT_NC.NUM_DOSS , SYSDATE, SYSDATE, ID_NORME
FROM QTE_ENREGISTREMENT_NC );
END LOOP;
CLOSE NORMES;
END;
/
|
| | 4 answer | Add comment |
Saturday, 10 May 2008
|
| Oracle Reports, PDF to XML Emece 02:40:21 |
| | Hi. Sorry by my bad english, I speak spanish.
I have a PDF Oracle Report Service (the URL is the usual,
http://server:7779/reports/rwservlet)
I want to get the PDF in XML format, without using the Report Builder.
Something like this:
http://server:7779/reports/rwservlet/getjodib1234?GiveMeTheReportInFormat=XML
Is possible? The parameter DESFORMAT doesn't work in the URL. Thanks
|
| | 3 answer | Add comment |
Wednesday, 7 May 2008
|
| TNSPing 03505 Error Tim Pascoe 11:59:48 |
| | I've looked through the archives of the group, and seen lots of posts
on this, but none have solved my problem yet.
I have the Oracle 9i client installed on a machine, in order to provide
connectivity to a SQL-Server box. I will be creating linked servers in
SQL-Server to several different Oracle instances.
I originally installed the 10g client, but discovered that it will not
connect to one of the legacy Oracle installations (8.1 I believe), so
uninstalled it and installed 9i.
I am able to connect to the Oracle instances using the Net Manager just
fine, but when I try and TNSPING to one of the TNSNAMES entries, I get
the 035050 error. The Linked server in SQL-Server is also unable to
make the cnnection, but provides very little in the way of usable error
message.
The sqlnet and tnsnames files are below:
NAMES.DEFAULT_DOMAIN = ontario.int.ec.gc.ca
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
PYR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = frodo)(PORT = 1522))
)
(CONNECT_DATA = (SERVICE_NAME = as03.pyr.ec.gc.ca))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = drake)(PORT = 1522))
)
(CONNECT_DATA = (SERVICE_NAME = as02.pyr.ec.gc.ca))
)
)
ACBIS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 131.235.28.21)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ATST)
)
)
|
| | 2 answer | Add comment |
Thursday, 20 March 2008
|
| ORA-00036 maximum number of recursive SQL levels (string) exceeded EdStevens 14:01:02 |
| | Platform: Solaris 9, Oracle EE 8.1.7.4, Oracle EE 10.2.0.1
Two databases on the same box, call them eps8pd (8.1.7.4) and epspd
(10.2.0.1)
In eps8pd, I created a db link pointing to epspd:
CREATE PUBLIC DATABASE LINK "LNK_EPSPD" CONNECT TO "NOBELEPS"
IDENTIFIED BY "********"
USING 'EPSPD'
then, connected to eps8pd as NOBELEPS (same user exists on both db's):
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
select count(*) from user_tables@lnk_epspd; select count(*) from user_tables@lnk_epspd
*
ERROR at line 1:
ORA-02068: following severe error from LNK_EPSPD
ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
Searching the ng archives, MetaLink, and Google on ORA-00036 gives a
few hits, all talking about the likelyhood of a recursive trigger. But
as you can see, my example is a simple select that shouldn't generate
much recursive SQL. Linking FROM the 10.2 db TO the 8.1 db causes no
problems. I realize that this may be an un-resolvable problem with 8
-> 10 connections, but am making one last attempt to find a possible
work-around before going to plan 'D'.
Thanks.
|
| | 3 answer | Add comment |
Tuesday, 23 October 2007
|
| Unable to see the contents of only ... Guest 08:22:06 |
| | Unable to see the contents of only one view.
Other views are working properly.
Only oneview is creating some problem and throwing the following error:
ORA-03113: end-of-file on communication channel
Help me please |
| | Add comment |
Thursday, 20 September 2007
|
| Development environment Oradba Linux 18:47:15 |
| | How to really use the alter session set current_schema='APPUSERID' in a devl
env for a set of 20+ developers ?
|
| | 22 answer | Add comment |
Sunday, 15 April 2007
|
| obj_privilege in dba_audit_trail Terry Dykstra 15:32:53 |
| | I'm trying to find out what privilege belongs to each position in the
obj_privilege column in the dba_audit_trail view. For example, position 10
seems to be 'select' privilege, position 7 is 'insert'. Does anyone have a
complete description?
Oracle 9.2.0.5
--
Terry Dykstra
Canadian Forest Oil Ltd.
|
| | 2 answer | Add comment |
Monday, 26 March 2007
|
| XMLType and ClassCastException: oracle.sql.OPAQUE Languy 10:28:53 |
| | Hi There,
I'm trying to create a XMLType using the SELECT XMLTYPE('expr') FROM DUAL.
When I'm trying to fetch the data I'll get an ClassCastException and I'm
wondering why.
java.lang.ClassCastException: oracle.sql.OPAQUE
oracle.xdb.XMLType PA.getXmlType(java.lang.String)
PA.java:100
-- source snip --
sql = "SELECT XMLType('"+ xmlstr +"') FROM DUAL";
System.out.print(sql);
conn = getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if (rs.next()) {
xmlObj = (XMLType)rs.getObject(1); // Line 100
System.out.println(xmlObj.toString());
}
-- source snip --
I hope any one will be helpful with this problem.
Thanks in regards,
Jess
|
| | 2 answer | Add comment |
Saturday, 13 January 2007
|
| trivia: origin of names for UPPER() and LOWER() Mark C. Stock 06:28:56 |
| | it occurred to my that for some whose native tongue is not english, the
names of these two functions might seem a bit odd, as would the phrases
'upper case' and 'lower case'
so, trivia question: what's the derivation (etymology, if you will) of the
terms 'upper case' and 'lower case' from which these functions get their
name?
++ mcs
|
| | 17 answers | Add comment |
|
