I need to take Oracle 10g backup at specific stages.
Here is the detailed requirement.
I have created a blank oracle 10g database. Now I need to do the following
1. Apply DDLs for var...
I have an Oracle database (on Fedora 7) successfully running on a port that isn't the standard 1521, eg it's on port 9999.
I can connect to it OK through SQL*Plus etc from a different machi...
I install the Oracle 10 after that I create database called Test_Db and the SID is TestDb
But when I run the Enterprise Manager I get Database Instance is down and Listener
See the picture
Hi ,
I have 10g oem client installed on my pc and i am trying to do a import as user who has dba priviileges
but I get a message saying: "Use the Enterprise manager 10g Console for Dat...
Oracle Forms 10g(10gDeveloper)the client requirement "PRINT THE REPORT WITHOUT PREVIEW..from FORMS" they don't want to see the out put on browser they just want prints outs. i.e. i am running ...
Dear Experts,
We have a table in a 10g schema which has about 2 mil records. I would like to archive data which is older than 1 year . Can you please give me process (in steps) to do this. ...
HI,
I have a file of this following format
H Client POL start_date 11112008 end_date 04112008 run_date 04042008
A pal 100 2000 dsds 343434
A na 345 4534 gfg 344545
The first recor...
Hi Folks,
I will try to be as descriptive as possible so I pre-apologize if I run-on a bit in my problem description or if my technical terminology (and knowledge) in some areas may be vagu...
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal ...
How to set a oracle 10g database to case-insensitive at database level ?
Does anyone know how to change language of 10g OEM (e.g. from Japanese to English)
How do you obtain the Oracle_SID, listerners.ora and tnsnames.ora of a database?
Have a user complaining that sqlplus is not working for them. When they run it they get the following error
#sqlplus
/usr/lib/pa20_64/dld.sl: Unable to find library 'libsqlplus.sl'.
Kill...
I created a 10g v2 database with ASM on a linux server. Everything was working well. I then attempted to install oracle application server and it hung on disk2 and it also hung on cancel. I h...
As I wanted to connect sqlserver 2000 from Oracle 10g, I followed all the required steps.
1.Configured / tested Sqlserver ODBC( orasql)
2.made a new listener by
a.Creating initorasql fil...
I have the follwing raw devices on a solaris system.
bart.innovapost.ca:oracle:/var/opt/oracle $ ls -l /dev/rdsk/c3t10d0*
lrwxrwxrwx 1 root root 79 Jul 28 14:19 /dev/rdsk/...
I am trying to return a recordset to VB6 from an oracle procedure (in a package using a sys_refcursor -oracle 10g). I am using a connection string based on Provider=MSDAORA.
The procedure h...
I want to have the headers & all output of this query to have a comma after each. I want this so if opened in excel it will not default to just one column.
Here's my query. the TIMEFORSTARTO...
How do I write Oracle SQL expression (using TOAD) that inserts rows into a table from a select statement, ie "Insert into table(field 1, field 2, field 3, etc) values(select field1, field2, fi...
Hi Experts,
I am getting the following error when running an application:
ERROR [JMSContainerInvoker] Reconnect failed: JMS provider failure detected:
javax.naming.NameNotFoundException:...
When I connect to one of my Solaris database servers several of my Oracle environment variables are already set.
ORACLE_BASE=/u01/home/oracle
ORACLE_ADMIN=/u01/home/oracle/admin
ORAENV_A...
Hi,
I am trying to connect Oracle Forms and Reports 6i to my Oracle 10g database which is running the Oracle E-Business Suite 11i.
Initially I installed the 10g DevSuite but I was advise...
I need to use Oracle to query Active Directory, how do I this?
Hi,
I'm trying to find out where is the control file located in my oracle db. But I do not know this is pointing to where? where can I find the folder name +DATA_1/
SQL> select name from v...
I have several remote systems setup with oracle server. I have the client side (because they are dynamic IPs) open an SSH tunnel to the main office and setup a reverse port so I can login to t...
