After server was recycled I cant bring up oracle, nothing was changed
only a reboot
ERROR:
ORA-12545: Connect failed because target host or object does not exist

Please pardon me if this is the wrong newsgroup for this posting; I'd
thought .marketplace would be right, but judging by current contents,
that doesn't seem to make sense.
Anyway.  I'm trying to make what amounts to a career change; after

I shutdown the database with the abort option (shutdown abort).
Following this, I do the following:
1)start the instance
2)execute SQL to mount the database

I know a little about Oracle but not enough about client versioning,
I'm guessing this is a fairly common question, but I've had no faqing
joy ;-P
We're using a now end-of-line closed source application linked against

I have to perform a VERY difficult task. I need to create a TEMP table
dinamically that will load and external file. The definition of that
TEMP table is loaded in another table. So fo example:
Desc Table_Definitions

i am sucuessfully running oracle 10g in winxp service  pack2 in my pentium IV
machines........
but when i tried to install same thing in pentium III machine and in same OS,
the installer so no response

Anyone got any experience of running offline instantiation over a
high-latency network?  My organisation is trying to do online instantiation
over a satellite link but it's proving to be a real drama.  The dataset
isn't really that large, so I'm not sure if we'd solve anything.

there is a query in our app:
"select * from table_name where rownum = 1"
that is very quick when run against a table with a small number of rows
( < 100 ) but very slow when run against a table with a large number

I'm using TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS')
very often. So if I want to change the format I a have to
change it very often. What is the best way to save the format
at only one place?

I have the following Stored Procedure, adapted from several examples:
CREATE OR REPLACE PROCEDURE "TEST_ENCRYPT" (input_string in VARCHAR2)
as
  input_string2              VARCHAR2(16) :=

We have backed-up the Oracle DB data existing on a server using RMAN
utility. The server uses Veritas volumes. After performing scratch
installation on this server, we want to restore the data onto this
server back, using RMAN. As part of the scratch installation, we have

In the Certification Matrix (
http://www.oracle.com/technology/support/metalink/index.html ), Oracle
publishes that 10g R1 is certified on Solaris 10 (with patchset 10.1.0.4).
So, I get 10.1.0.4.  I read the included Patch Set Notes (Document 263719.1,

I am getting "ORA-00060: deadlock detected while waiting for resource"
oracle error message when some on my users are savings their data.
Sounds like some kind of contention problem.
I have a number of tables that are being updated on this update script

  Dear Experts,
Could you please explain me the behavior of the following codes?
.... Declaration section ...........
volume number := NULL;

I have an oracle table and the names of the fields are a little
mis-leading for the average user.
I'd like to show the user an alias and when the user chooses the alias,
then I'd like to use that field in the query.