Answer / priya reddy

show error;
This is the command used to view the errors..

Answer / santo

Sometimes 'Show error' won't display the required
info...then check dba_errors table

select text from dba_errors where name='****';

Answer / santosh

show error package <package name>
to check the compilation errors
similarly for functions

show error function <function name>

and for procedures

show error procedure <procedure name>

Where would you look for errors from the database engine?

0 Answers   IBM,

---

What is the dataguard background process??

1 Answers   iGate,

---

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

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

1 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---