Oracle Administration

regarding networking oracle 10g on linux

hi, this is regarding how to configure listener.ora and tnsnames.ora .can any body pls help me     thank u Software/Hardware used: oracle on linux

oracle 10g database migration

Hi Exprts, we migrated a database in terabytes in size in Oracle 10 g using data pump it took 10 hrs for export and 46 hrs to import i am sure this is not the efficient method can you please suggest wat possiblities there to improve the export/import to happen fast for such huge sized databases

How to change Oracle hostname

My Oracle database control is pointing at the wrong hostname. Where do I change that? Thank you. Moderator Note: This is a submitted question

Sending logs using Oracle Data Guard

We have configured primary and physical standby databases on two different machines. We want to ship the logs using Oracle Data Guard from primary to physical standby databases so that the two databases are always in sync. Please inform what are the minimum network permissions required to allow...

How to implement oracle single sign-on with a legacy application

I have set up a user for external authentication in the database. I am able to login to the oracle database sqlplus /@dbname and it uses my windows account. But when I try to login to the application I get an error of a null password. Are there any other applications/tools that are necessary to...

Oracle remote login results in IPNAT.SYS error

Attempts at remote login to Oracle database throws an IPNAT.SYS error. Is this a firewall issue with Windows Server 2003? Or is this Oracle configuration problem? What is the best secure way to handle an IPNAT.SYS error? Thank you. Moderator Note: This is a submitted question.

Jobs not geeting executed

After migrating Oracle version my jobs are not getting executed

How to pass parameters from Oracle Form to Oracle Report?

how we can run oracle repoert from Oracle form and passing parameters from form to oracle report by Clicking Button

Oracle installation and migration between versions in Linux

Hi Experts, I need some useful doc links or step by step procedure to perform oracle installation and migration in Linux environment I surfed thru net ,cud not find any good docs or pdf on this As i am new to explore this role,can any one provide me some useful related links

Extracting data from multiple tables in Oracle 9i

I HAVE 18 TABLES AND I NEED TO EXTRACT DATA FROM THESE TABLES AND STORE IT IN A SINGLE TABLE..THE PROBLEM I S THAT THESE TABLES DO NOT HAVE ANY COMMON FEILDS AND A SINGLE PRIMARY KEY. PRESENCE OF REDUNDANT DATA IS VERY MUCH . HOW TO COME OUT WITH THIS. I AM USING ORACLE9I .

Size of temp tablespace in Oracle 9i

We have a temporary tablespace in Oracle 9i. The temp datafile shows 0 bytes as its storage. But on D:ORACLEORADATAORCLTEMP01.DBF, (where this file is stored), the size of this file is shown as 1.2 MB. Is there any reason for this? Moderator Note: This is a submitted question

Change user password for Oracle Internet Directory

i have to change the user password cn=orcladmin for internet oracle directory how?

User Access to Oracle

how to access Oracle ERP? Like SAP does oracle also has T-codes?

Oracle table space

how do we purge the old data in the table space of the the segment in oracle 10g?

Query to find Oracle memory space

how to find out the memmory space in oracle using queries?

Oracle v$ view that dynamically has the names of procedures

Is there a v$ view where I may find just the names of all the procedures that are currently running in an Oracle database?

Oracle - Deleting a row from a complex view

why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

Oracle Enterprise Manager login password error

We have windows 2003 server and we are running 2 oracle databases in version 11g. We were successfully configured EM for one database and when we were tried for the other database we encountered configuration errors and we were able to sort by searching on "google", solution was "ocijdbc10 file has...

oracle log for table update infimation

I am a system Administrator, I am having Oracle 10g database server on windows 2000 server in my office LAN network front end is forms & reports 6i. in last 10days 1 user connected to oracle database other than regular forms 6i program and modified one table record column value by update. How...

How to insert an image file into an Oracle 8i database?

Hi Experts, I am using forms&reports6i with the oracle 8i database. Now i want to insert a image file into the database and i want to access that in reports. I tried the insert statement but i couldn't. can anyone help me for inserting.