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

Answer / guest

Cause: The process of starting up a dedicated server process
failed. The executable could not be found or the environment
may be set up incorrectly.

Action: Turn on tracing at the ADMIN level and reexecute the
operation. Verify that the ORACLE Server executable is
present and has execute permissions enabled. Ensure that the
ORACLE environment is specified correctly in LISTENER.ORA.
The Oracle Protocol Adapter that is being called may not be
installed on the local hard drive. Please check that the
correct Protocol Adapter are successfully linked. If error
persists, contact Oracle Customer Support.

Please add more information about this Error

NNO-00268: warning: configuration database is not used, using checkpoint data instead

1 Answers  

---

ORA-07585: spdcr: $PARSE failure

1 Answers  

---

ORA-31070: Invalid database user ID string

1 Answers  

---

ORA-23351: parameter datatype string for procedure string not supported

1 Answers  

---

ORA-02739: osncon: host alias is too long

1 Answers  

---

ORA-29863: warning in the execution of ODCIINDEXCREATE routine

1 Answers  

---

ORA-09956: scgcm: unexpected lock status condition

1 Answers  

---

NNO-00705: warning: cannot open checkpoint file "string", checkpointing disabled

1 Answers  

---

ORA-30765: cannot modify scope for an unscoped REF column

1 Answers  

---

ORA-01649: operation not allowed with a backup controlfile

1 Answers  

---

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

0 Answers   IBM,

---

PLS-00223: paramaterless procedure 'string' used as function

1 Answers  

---