Oracle administration Questions


Oracle 10g error message – DIM 00019
Hi During the installing of Oracle 10g 10.1.0 on server 2003 r2, i have the following error message : DIM – 00019: Create service error O/S Error: (OS 1388) a new member could not be added to a local group because the member has the wrong account type. Can someone help me to resolve this [...]

Answer Question   |  April 13, 2010  5:39 AM
DIM 00019, Oracle 10g error messages, Oracle administration
asked by:
105 pts.

Privilage in oracle 10g database
Hi everybody, I am developing a relational database using oracle 10g. It is a centralized database. I do have four groups going to use the database. They are doing same tasks on their own part. How could I restrict them only they do have access on their own part? I am waiting for your help. [...]

Answer Question   |  March 19, 2010  1:38 PM
Oracle, Oracle 10g, Oracle administration, Oracle Database 10g
asked by:
30 pts.

Business Impact or plus using Oracle 11g RAC over 10g
Business Impact or plus using Oracle 11g RAC over 10g

Answer Question   |  December 8, 2009  10:51 AM
Oracle 10g, Oracle 11g, Oracle administration, RAC
asked by:
610 pts.

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

Answer Question   |  April 14, 2011  8:57 AM
Linux, Oracle 10g, Oracle administration
asked by:
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 [...]

Answer Question   |  August 5, 2009  8:29 AM
Oracle 10g, Oracle administration, Oracle migration
asked by:
610 pts.

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

Answer Question   |  July 30, 2009  6:01 PM
Oracle administration, Oracle hostname
asked by:
6,580 pts.

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 the two machines communicate and ship logs [...]

Answer Question   |  July 16, 2009  5:59 PM
Oracle administration, Oracle Data Guard, Physical Standby Database
asked by:
6,580 pts.

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 [...]

Answer Question   |  July 31, 2009  11:55 AM
Legacy applications, Oracle administration, Oracle connectivity, Single sign-on, SQLPlus
asked by:
15 pts.

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   |  July 2, 2009  8:40 PM
Firewalls, IPNAT.SYS, Oracle administration, Oracle error messages, Oracle remote access, Remote access, Windows Server 2003
asked by:
6,580 pts.

Jobs not geeting executed
After migrating Oracle version my jobs are not getting executed

Answer Question   |  June 29, 2009  9:25 AM
Oracle administration
asked by:
10 pts.

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

Answer Question   |  July 15, 2011  7:24 AM
Oracle administration, Oracle Forms, Oracle Reports
asked by:
5 pts.

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

Answer Question   |  June 9, 2009  9:31 AM
Linux databases, Oracle administration, Oracle installation, Oracle migration, Oracle on Linux
asked by:
610 pts.

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 [...]

Answer Question   |  May 19, 2009  6:56 AM
Oracle 9i, Oracle administration
asked by:
15 pts.

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

Answer Question   |  May 15, 2009  8:27 PM
Oracle 9i, Oracle administration, Temp Tablespace
asked by:
6,580 pts.

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

Answer Question   |  May 20, 2009  5:34 AM
Oracle administration, Oracle Internet Directory, Oracle User Profiles
asked by:
105 pts.

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
Oracle administration, Oracle connectivity, Oracle ERP, Oracle User Profiles
asked by:
Neh
5 pts.

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

Answer Question   |  July 30, 2009  4:16 PM
Oracle administration, Oracle Tablespaces
asked by:
5 pts.

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

Answer Question   |  March 23, 2009  6:59 AM
Oracle administration, Oracle memory usage, Oracle queries
asked by:
15 pts.

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?

Answer Question   |  February 25, 2009  7:41 AM
Oracle administration, Oracle v$ Views, Oracle Views
asked by:
5 pts.

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

Answer Question   |  January 23, 2009  3:53 AM
DELETE statement, Oracle administration, Oracle Complex View, Oracle development
asked by:
10 pts.