I have installed 10.1.0.2 and updated to 10.1.0.4 on AIX 5.3 5300-02 . This is the error from the $ORACLE_HOME/edidev_GIS/sysman/log/emagent.trc and I am unable to bring up EM
2006-06-22 ...
Hi,
I have just inherited a number of Oracle packages that I need to maintain.
All the packages make reference to DBMS_REPCAT_INTERNAL_PACKAGE
I could not find any reference to this in t...
What is the meanning of this error?
ORA-00600: internal error code, arguments: [17099], [], [], [], [], [], [], []
Tue Oct 19 14:09:15 2004
found dead shared server 'S000', pid = (10, 1...
Hi ,
Restored an entire Oracle 9.0.1.4 database from tape . The database mounts but will not open and allow any login .
All the dbf files .. control files , logs were lost and recovered ...
I have oracle 9i client installed on my windows 2000 server. I am trying to establish a data transfer from sql server to oracle server on another machine. So I modified the tnsnames.ora file b...
Hello,
Have any one gotten this error loading data utilizing SQLLOADER on a UNIX machine: SQL*Loader-566: partial record found at end of datafile
SQL*Loader-2026: the load was aborted beca...
When I try to import I get the following errors:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining opt...
I recently got a new laptop and it is running windows xp sp2. I installed Oracle 9i and moved everything off my old one to this one. All settings look identical. The only difference is the ...
We have an Oracle 9.0.1.4 database on hpux 11i. What is the simplest or best way to restrict having regular clients accessing the database via tools such as TOAD, Excel, MS Access, ODBC etc. ...
Using Java to execute unix from sql - i get this when trying to execute a script on unix - its works in devlopment but not in production enviroments - any ides - please help
I am fairly new to Oracle...having said that....
I currently have Oracle 8.1.6 installed on a unix server. I would like to install oracle 10g database on the same server.
Will there be ...
HELP
I need to know how to remove the flat files from the directory after Oracle has completed the transfer? How will I know that oracle is done processinh them and how can I notify another...
In a particular routine, on a referential integrity error, I am wanting the procedure to terminate execution but I do not want the procedure that called it to terminate.
I have set this up ...
I have just rebuilt an Oracle 9i database using UTF8 character set. I get the ora-03106 fatal two-task error when trying to connect with sqlplus 8.1.5 from a windows workstation. But I have an...
Hi
Platform : Oracle 9.2 / Windows 2000
I'd like to export a table with 40 million rows to a flat file. If I SPOOL data into a regular text file it grinds to a crawl after around 4 mill...
I need to revoke execution privileges from public on the following packages:
UTL_FILE
UTL_TCP
UTL_SMTP
UTL_HTTP
DBMS_SQL
DBMS_JOB
DBMS_LOB
DBMS_RANDOM
DBMS_OBFUSCATION_TOOLKIT
but ...
Hi everyone,
I have installed a Oracle EE 8.1.7.0 database in windows 2000 server. I also run an Oracle EE 8.1.5 database. One of the main reasons for install 8.1.7 on a new server was to t...
If I am logged on to the Database Server I can connect a different user to the database as sysdba.
Problem If a different user is logged on to the database server no one can connect to the ...
I have read the certification books about RMAN but it is not clear what are the signficant steps to creating a backup script using RMAN first in 8.1.7 and 9.2.0.4. I want to be able to fluentl...
I have been noticing this recently in my computer: Eventhough I'm not running any application or program related to ORACLE, oracle.exe gives me high number of memory and virtual memory size.
...
Hi, I have been working in the IT field for about 3 years now. I do a myriad of things for this company from building applications (mostly in PHP and I am also getting some hands-on Java expe...
I am trying to write a SQL query that will obtain data from a table based on the sysdate month and day. I have the following:
SELECT firstname, lastname FROM tb_birthday WHERE upper(month)...
Greetings,
When I execute this procedure, it use to return normal values but now it returns a 0 or -1. What would have cause this procedure to behave in this manner now? It there a database...
What is the good way to learn HTML DB/Application Express. I went through Oracle tutorial and I don't like it. Is there any good book or good site?
Two Oracle databases (10.2.0.3) defined under the same home are runiing on the same server (OS -AIX5L, maint.level -07). Two listeners are defined in the listener.ora file - one for each data...
