Answer Posted / st holy

Hi,

I was facing the same kind of dreaded error , for a few
days., until now..
There could be only three reasons for which this error is
splashed across your screen, :

1. Your db is down, so in this case u need to pester
ur dba to do the performance tuning so that the instance
running can serve as a dedicated server for the incoming
requests.

It can be done , with a small tweak on ur tnsnames.ora file,
Just add SERVER = DEDICATED to the line after the
CONNECT_DATA PARAMETER.

The worst case is that the dba would have to figure out the
prob by him self.

2. The parameters representing your tnsnames.ora and
the listener.ora files are not assigned properly
3. This is the most exceptional and possible cause of
this error,
Well, its your darn antyi-virus, which can’t keep its hands
of the innocent oracle processes which are : the RDBM
executable and the intelligent agent module.

If they are held at point blank range by your crappy anti –
virus, then, its time you spring into action. These two
process are must for the connectivity for DB tools such as
Toad.,as it references many of these agents and oracle
specific files to estb. A connection.

So, just make sure its not blocked or something.

In case, you find the anti virus to be the culprit, then
simply run this line at your prompt. :

Oradim –shutdown –sid -<your instance name>

U might get an error if the RDBMS module is fortunatly not
blocked.

Next, find yourself into c:/oracle/ora09/bin/ and execute
agntsrvc executabe.
It should not throw any error. If not, then its your lucky
day, after all.

Now check the status of your listener.
Type, lsnrctl, then u get an intro by the listener,
Lsnrctl>
Type, status…
You will find the name of your instance, with the status
as “READY” ,,,

That’s its your done,,, Now fire up the tool your using,,,,
Voila…,ITS CONNECTED.

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1243

---

IMP-00064: Definition of LOB was truncated by export

5893

---

NZE-28890: Entrust Login Failed

1411

---

ORA-26079: file "string" is not part of table string.string

1524

---

IMP-00070: Lob definitions in dump file are inconsistent with database.

1290

---

---

ORA-16516: The current state is invalid for the attempted operation.

8075

---

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2325

---

Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2141

---

ORA-16626: failed to enable specified object

1778

---

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2331

---

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2321

---

NZE-28868: Peer certificate chain check failed.

2267

---

ORA-26030: index string.string had string partitions made unusable due to:

1564

---

ORA-26032: index string.string loading aborted after string keys

1655

---

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2236

---