Oracle client is not able to connect to Oracle server
although tnsnames.ora file has
valid enteries. Oracle error message is “ cannot resolve
net service name”.
Mention any three reasons.
I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
Where in the Oracle directory tree structure are audit
traces placed?
159
Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
5
You're getting high "busy buffer waits" - how can you find
what's causing it?
11
How would you begin to troubleshoot an ORA-3113 error?
6
Does any body has ORACLE Certification Dumps or Materials
on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i
to 10g DBA Upgrade, Oracle 11i if any body have it, please
kindly drop an email to: taruni_2k8@yahoo.com
I got an error SQL1042C. An unexpected system error
occurred.
Explanation:
A system error occurred. One possible reason for this error
is that the database manager is not installed correctly or
the environment is not set up correctly.
On OS/2, while trying to start the database manager, a very
common reason for this error is a corrupted NET.ACC file.
The command cannot be processed.
The tables and views would not be opened. What is the way
to open the dataase?
pls help me
382
Draft one mock email requesting your non-technical
management grant you downtime to (provide justification
where applicable) complete the following tasks:
(1) Generate statistics on a large table;
(2) Generate an RDA – if you don't know what an RDA is
please say so.
(3) Rename datafiles.
31
What would you do with an "in-doubt" distributed transaction?
16
You have 4 instances running on the same UNIX box. How can
you determine which shared memory and semaphores are
associated with which instance?
5
How does Oracle guarantee data integrity of data changes?
6
I want to export only structure of the table from oracle
database. In that table to used the some partition.
To export the table in general way then compilation error
was occured i.e-EXP-00003: no storage definition found for
segment(11, 2771). Please tell me the correct export command
parameter to export the partitioned table.
Thanks in Advance..........
836
What is the cache hit ratio, what impact does it have on
performance of an Oracle database and what is involved in
tuning it?
10
Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
5
How would you extract DDL of a table without using a GUI tool?
3
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?
4
What is the recommended interval at which to run statspack
snapshots, and why?
3
. I have my backup RMAN script called "backup_rman.sh". I am
on the target database. My catalog username/password is
rman/rman.
My catalog db is called rman. How would you run this shell
script
from the o/s such that it would run as a background process?
307
What are the ways tablespaces can be managed and how do they
differ?
19
Where would you look for errors from the database engine?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
