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
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
5 pts.
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
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
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...
View Answer
| Jul 16 2009 5:59 PM GMT
Oracle Data Guard, Physical Standby Database, Oracle administration
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...
View Answer
| Jul 16 2009 5:59 PM GMTOracle Data Guard, Physical Standby Database, Oracle administration
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...
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.
Answer Question
| Jul 2 2009 8:40 PM GMT
Oracle error messages, Oracle remote access, Oracle administration
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.
Answer Question
| Jul 2 2009 8:40 PM GMTOracle error messages, Oracle remote access, Oracle administration
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
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
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 .
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
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?
View Answer
| May 14 2009 5:34 AM GMT
Oracle administration, Oracle Internet Directory, Oracle User Profiles
i have to change the user password cn=orcladmin for internet oracle directory how?
View Answer
| May 14 2009 5:34 AM GMTOracle administration, Oracle Internet Directory, Oracle User Profiles
User Access to Oracle
how to access Oracle ERP? Like SAP does oracle also has T-codes?
Answer Question
| May 12 2009 9:52 AM GMT
Oracle administration, Oracle connectivity, Oracle User Profiles
how to access Oracle ERP? Like SAP does oracle also has T-codes?
Answer Question
| May 12 2009 9:52 AM GMTOracle administration, Oracle connectivity, Oracle User Profiles
Oracle table space
how do we purge the old data in the table space of the the segment in oracle 10g?
how do we purge the old data in the table space of the the segment in oracle 10g?
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?
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
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...
Answer Question
| Jan 16 2009 5:05 AM GMT
Oracle Enterprise Manager, Windows Server 2003, Oracle 11g
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...
Answer Question
| Jan 16 2009 5:05 AM GMTOracle Enterprise Manager, Windows Server 2003, Oracle 11g
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...
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.
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.
