f



Cannot connect to Oracle 10g database

From SQL PLus, I cannot connect to our Oracle 10g database. The
following errors shows up in the SQL-Plus.

ORA-12514: TNS:listener does not currently know of service requested
in connect
descriptor

The same error comes even after a day, the database had been started.

Database start fine without any errors, when it is started from
Services. The emoms.log shows the following errors.

2008-04-22 17:28:20,234 [HttpRequestHandler-24044524] ERROR
conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
Pool. ERROR = Listener refused the connection with the following
error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))

2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
eml.OMSHandshake getParameterFromDB.563 - Listener refused the
connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))

2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =
http://support-db3.actuate.com:3938/emd/main)(ERROR = INTERNAL_ERROR)
2008-04-22 17:28:20,312 [HttpRequestHandler-20677779] ERROR
conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
Pool. ERROR = Listener refused the connection with the following
error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))

2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
eml.OMSHandshake getParameterFromDB.563 - Listener refused the
connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested
in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=support-
db3.actuate.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl10g)))

2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =
http://support-db3.actuate.com:3938/emd/main)(ERROR = INTERNAL_ERROR)

What could be the problem and how to fix it?

Any help you can provide is greatly appreciated.

Thank you.
Raj
0
jkamaraj (31)
4/23/2008 12:30:44 AM
comp.databases.oracle.server 22978 articles. 1 followers. Post Follow

8 Replies
1169 Views

Similar Articles

[PageSpeed] 17

On Apr 23, 2:30=A0am, Raj <jkama...@gmail.com> wrote:
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
>
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> descriptor
>
> The same error comes even after a day, the database had been started.
>
> Database start fine without any errors, when it is started from
> Services. The emoms.log shows the following errors.
>
> 2008-04-22 17:28:20,234 [HttpRequestHandler-24044524] ERROR
> conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
> Pool. ERROR =3D Listener refused the connection with the following
> error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsupport-=

> db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g)))
>
> 2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
> eml.OMSHandshake getParameterFromDB.563 - Listener refused the
> connection with the following error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsupport-=

> db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g)))
>
> 2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
> eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =3Dht=
tp://support-db3.actuate.com:3938/emd/main)(ERROR=3D INTERNAL_ERROR)
> 2008-04-22 17:28:20,312 [HttpRequestHandler-20677779] ERROR
> conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
> Pool. ERROR =3D Listener refused the connection with the following
> error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsupport-=

> db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g)))
>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> eml.OMSHandshake getParameterFromDB.563 - Listener refused the
> connection with the following error:
> ORA-12514, TNS:listener does not currently know of service requested
> in connect descriptor
> The Connection descriptor used by the client was:
> (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsupport-=

> db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g)))
>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =3Dht=
tp://support-db3.actuate.com:3938/emd/main)(ERROR=3D INTERNAL_ERROR)
>
> What could be the problem and how to fix it?
>
> Any help you can provide is greatly appreciated.
>
> Thank you.
> Raj

The obvious route would have been to
- look up this error in the online documentation
- work from there
- Search Google and/or this forum for this error
  You will find thousands of posts by people, who like you, don't want
to do even the most elementary: Look up the error
  You will find many valid solutions.

What you should not have done is
BE LAZY, AND POST THE ERROR FOR THE UMPTEENTH TIME
AGAIN!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

--
Sybrand Bakker
Senior Oracle DBA
0
sybrandb1 (715)
4/23/2008 8:42:16 AM
Raj wrote,on my timestamp of 23/04/2008 10:30 AM:
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
> 
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> descriptor
 > snippage
> What could be the problem and how to fix it?
> 
> Any help you can provide is greatly appreciated.
> 

The problem is that the description of the service
name in your tnsnames.ora entry does not match the
service names the listener knows about.
The most common case is when for example the
SERVICE_NAME entry is set to the SID in the server,
instead of the fully qualified domain name of the
database.
Try this:
Run the following query in the server logged on as
sys or system:
select * from global_name;
then pick the resulting string and set the SERVICE_NAME
parameter in the corresponding tnsnames.ora entry in the
client to that string. Then try the connect again.
0
wizofoz2k (1386)
4/23/2008 12:40:11 PM
On Apr 22, 5:30=A0pm, Raj <jkama...@gmail.com> wrote:
> From SQL PLus, I cannot connect to our Oracle 10g database. The
> following errors shows up in the SQL-Plus.
>
> ORA-12514: TNS:listener does not currently know of service requested
> in connect
> descriptor
>
=2E..

>
> 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =3Dht=
tp://support-db3.actuate.com:3938/emd/main)(ERROR=3D INTERNAL_ERROR)
>
> What could be the problem and how to fix it?
>
> Any help you can provide is greatly appreciated.
>
> Thank you.
> Raj

You might try running lsnrctl status to see what the listener is
expecting.  It is likely going to be what Noons said.

It is also possible that you are not using a protocol already set up,
if you are on the same machine as the db.  Is there an @ sign in your
connect string from sqlplus?  Try removing that reference, instead of
sqlplus scott/tiger@orcl10g, try sqlplus scott/tiger.

For the agent, you perhaps have the wrong oracle home or something
like that.  Have you reinstalled anything, patched, or otherwise made
more than one install?  Are there errors in your alert log?  Have you
found every tnsnames.ora file everywhere?  Do you have more than one
oracle home?  You may need to simply reconfigure the agent.

Also, remember to state your version, completely, like 10.2.0.4 or
whatever select * from v$version; says.

You should be able to go into a dos box on your server and say sqlplus
"/ as sysdba" to get to sqlplus.

jg
--
@home.com is bogus.
http://translate.google.com/translate?hl=3Den&sl=3Dzh-CN&u=3Dhttp://www.anys=
ql.net/tag/Oracle&sa=3DX&oi=3Dtranslate&resnum=3D9&ct=3Dresult&prev=3D/searc=
h%3Fq%3Dshareplex%2Boracle7%2Bmine%2Bredo%2Blogs%26hl%3Den%26sa%3DG
0
joel-garry (4553)
4/23/2008 6:07:09 PM
On Tue, 22 Apr 2008 17:30:44 -0700, Raj wrote:

> ORA-12514: TNS:listener does not currently know of service requested in
> connect
> descriptor

Stop requesting and ask nicely. Contrary to the claims of certain former
inhabitant of Chicago, IL, nice word can get you quite far, especially if
you know what are you asking for.

-- 
Mladen Gogala
http://mgogala.freehostia.com
0
mgogala1572 (354)
4/24/2008 9:15:27 AM
On Apr 23, 5:40=A0am, Noons <wizofo...@yahoo.com.au> wrote:
> Rajwrote,on my timestamp of 23/04/2008 10:30 AM:
>
> > From SQL PLus, I cannot connect to our Oracle 10g database. The
> > following errors shows up in the SQL-Plus.
>
> > ORA-12514: TNS:listener does not currently know of service requested
> > in connect
> > descriptor
> =A0> snippage
> > What could be the problem and how to fix it?
>
> > Any help you can provide is greatly appreciated.
>
> The problem is that the description of the service
> name in your tnsnames.ora entry does not match the
> service names the listener knows about.
> The most common case is when for example the
> SERVICE_NAME entry is set to the SID in the server,
> instead of the fully qualified domain name of the
> database.
> Try this:
> Run the following query in the server logged on as
> sys or system:
> select * from global_name;
> then pick the resulting string and set the SERVICE_NAME
> parameter in the corresponding tnsnames.ora entry in the
> client to that string. Then try the connect again.

Hello Noon,
When I try to run this SQL, I got an error saying that database  is
not open


SQL> connect sys/admin@orcl10g as sysdba
Connected.
SQL> select * from global_name;
select * from global_name
              *
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views
only


I tried to open the database using the following  alter database open.
It failed with the below message:

SQL> alter database open
  2  /
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'


I ran the lsnrctl status and got the following output:

C:\Documents and Settings\Administrator>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 30-
APR-2008 11:21
:05

Copyright (c) 1991, 2006, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DIPC)(KEY=3DEXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version
10.2.0.3.0 - Produ
ction
Start Date                12-APR-2008 03:11:41
Uptime                    18 days 8 hr. 9 min. 24 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\oracle\product\10.2.0\db_1\network\admin
\listener.o
ra
Listener Log File         C:\oracle\product\10.2.0\db_1\network\log
\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe
\EXTPROC1ipc)))
  (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3Dsupport-db3)(PORT=3D1521=
)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
Service "orcl10g" has 1 instance(s).
  Instance "orcl10g", status READY, has 1 handler(s) for this
service...
Service "orcl10g_XPT" has 1 instance(s).
  Instance "orcl10g", status READY, has 1 handler(s) for this
service...
Service "orcl10ga" has 1 instance(s).
  Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
Service "orcl10gaXDB" has 1 instance(s).
  Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
Service "orcl10ga_XPT" has 1 instance(s).
  Instance "orcl10ga", status READY, has 1 handler(s) for this
service...
The command completed successfully

Here orcl10ga works fine but the orcl10g fails to connect from SQL
Plus with the
ORA-12514: TNS:listener does not currently know of service requested
error.


Here is my tnsnames.ora file contents:
# tnsnames.ora Network Configuration File: C:\oracle\product
\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL10G =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT=

=3D 1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D orcl10g)
    )
  )

AMTRAKMA =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT =
=3D
1521))
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D AmtrakMaximo)
    )
  )

UNILOG =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT =
=3D
1521))
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D UNILOG)
    )
  )

ORCL10GA =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3)(PORT =3D 1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D orcl10ga)
    )
  )

EDGE =3D
  (DESCRIPTION =3D
    (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT =
=3D
1521))
    (CONNECT_DATA =3D
      (SERVER =3D DEDICATED)
      (SERVICE_NAME =3D EDGE)
    )
  )

ORCL10GUC =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT=

=3D 1521))
    )
    (CONNECT_DATA =3D
      (SERVICE_NAME =3D orcl10guc)
    )
  )


and listener.ora # listener.ora  contents

Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin
\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =3D
  (SID_LIST =3D
    (SID_DESC =3D
      (SID_NAME =3D PLSExtProc)
      (ORACLE_HOME =3D C:\oracle\product\10.2.0\db_1)
      (PROGRAM =3D extproc)
    )
  )

LISTENER =3D
  (DESCRIPTION_LIST =3D
    (DESCRIPTION =3D
      (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D EXTPROC1))
      (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.com)(PORT=

=3D 1521))
    )
  )

Thank you for any guidance you may provide.

Regards.
Raj


0
jkamaraj (31)
4/30/2008 6:46:36 PM
On Apr 23, 1:42=A0am, sybrandb <sybra...@gmail.com> wrote:
> On Apr 23, 2:30=A0am,Raj<jkama...@gmail.com> wrote:
>
>
>
>
>
> > From SQL PLus, I cannot connect to our Oracle 10g database. The
> > following errors shows up in the SQL-Plus.
>
> > ORA-12514: TNS:listener does not currently know of service requested
> > in connect
> > descriptor
>
> > The same error comes even after a day, the database had been started.
>
> > Database start fine without any errors, when it is started from
> > Services. The emoms.log shows the following errors.
>
> > 2008-04-22 17:28:20,234 [HttpRequestHandler-24044524] ERROR
> > conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
> > Pool. ERROR =3D Listener refused the connection with the following
> > error:
> > ORA-12514, TNS:listener does not currently know of service requested
> > in connect descriptor
> > The Connection descriptor used by the client was:
> > (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsuppor=
t-
> > db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g))=
)
>
> > 2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
> > eml.OMSHandshake getParameterFromDB.563 - Listener refused the
> > connection with the following error:
> > ORA-12514, TNS:listener does not currently know of service requested
> > in connect descriptor
> > The Connection descriptor used by the client was:
> > (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsuppor=
t-
> > db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g))=
)
>
> > 2008-04-22 17:28:20,250 [HttpRequestHandler-24044524] ERROR
> > eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =3D=
http://support-db3.actuate.com:3938/emd/main)(ERROR=3DINTERNAL_ERROR)
> > 2008-04-22 17:28:20,312 [HttpRequestHandler-20677779] ERROR
> > conn.ConnectionService verifyRepositoryEx.434 - Invalid Connection
> > Pool. ERROR =3D Listener refused the connection with the following
> > error:
> > ORA-12514, TNS:listener does not currently know of service requested
> > in connect descriptor
> > The Connection descriptor used by the client was:
> > (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsuppor=
t-
> > db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g))=
)
>
> > 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> > eml.OMSHandshake getParameterFromDB.563 - Listener refused the
> > connection with the following error:
> > ORA-12514, TNS:listener does not currently know of service requested
> > in connect descriptor
> > The Connection descriptor used by the client was:
> > (DESCRIPTION=3D(ADDRESS_LIST=3D(ADDRESS=3D(PROTOCOL=3DTCP)(HOST=3Dsuppor=
t-
> > db3.actuate.com)(PORT=3D1521)))(CONNECT_DATA=3D(SERVICE_NAME=3Dorcl10g))=
)
>
> > 2008-04-22 17:28:20,328 [HttpRequestHandler-20677779] ERROR
> > eml.OMSHandshake processFailure.780 - OMSHandshake failed.(AGENT URL =3D=
http://support-db3.actuate.com:3938/emd/main)(ERROR=3DINTERNAL_ERROR)
>
> > What could be the problem and how to fix it?
>
> > Any help you can provide is greatly appreciated.
>
> > Thank you.
> >Raj
>
> The obvious route would have been to
> - look up this error in the online documentation
> - work from there
> - Search Google and/or this forum for this error
> =A0 You will find thousands of posts by people, who like you, don't want
> to do even the most elementary: Look up the error
> =A0 You will find many valid solutions.
>
> What you should not have done is
> BE LAZY, AND POST THE ERROR FOR THE UMPTEENTH TIME
> AGAIN!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

May be ignorant but not lazy. I tried by myself for two days but could
not get anywhere.

Regards.
Raj
0
jkamaraj (31)
4/30/2008 6:49:51 PM
On Apr 30, 11:46=A0am, Raj <jkama...@gmail.com> wrote:

>
> SQL> alter database open
> =A0 2 =A0/
> alter database open
> *
> ERROR at line 1:
> ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
> ORA-01110: data file 7:
> 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'

Does this file exist?  Is it being locked by a virus scanner or backup
program or editor or something?

>
> I ran the lsnrctl status and got the following output:
>
> C:\Documents and Settings\Administrator>lsnrctl status
>
> LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 30-
> APR-2008 11:21
> :05
>
> Copyright (c) 1991, 2006, Oracle. =A0All rights reserved.
>
> Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DIPC)(KEY=3DEXTPROC1)))=

> STATUS of the LISTENER
> ------------------------
> Alias =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 LISTENER
> Version =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 TNSLSNR for 32-bit Windows: Ve=
rsion
> 10.2.0.3.0 - Produ
> ction
> Start Date =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A012-APR-2008 03:11:41
> Uptime =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A018 days 8 hr. 9 min. 24 sec
> Trace Level =A0 =A0 =A0 =A0 =A0 =A0 =A0 off
> Security =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ON: Local OS Authentication
> SNMP =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0OFF
> Listener Parameter File =A0 C:\oracle\product\10.2.0\db_1\network\admin
> \listener.o
> ra
> Listener Log File =A0 =A0 =A0 =A0 C:\oracle\product\10.2.0\db_1\network\lo=
g
> \listener.log
>
> Listening Endpoints Summary...
> =A0 (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe
> \EXTPROC1ipc)))
> =A0 (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3Dsupport-db3)(PORT=3D=
1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> =A0 Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Service "orcl10g" has 1 instance(s).
> =A0 Instance "orcl10g", status READY, has 1 handler(s) for this
> service...

> # Generated by Oracle configuration tools.
>
> ORCL10G =3D
> =A0 (DESCRIPTION =3D
> =A0 =A0 (ADDRESS_LIST =3D
> =A0 =A0 =A0 (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate.c=
om)(PORT
> =3D 1521))
> =A0 =A0 )
> =A0 =A0 (CONNECT_DATA =3D
> =A0 =A0 =A0 (SERVICE_NAME =3D orcl10g)
> =A0 =A0 )
> =A0 )
>

Maybe a mismatch between your hostname and your fully qualified
hostname?  Try briefly renaming your listener.ora to something else
(or comment out the parts that refer to this db) and reload your
listener and let your db register itself, see if the host is different
with lsnrctl status.  That is, if you can get your db open.  I'm not
sure whether you've ever had it open?  What does your alert log say
about that?  Do you have a listener.trc file?  What is the last TNS-
error in your listener.log?  Are there blocking errors?

jg
--
@home.com is bogus.
Let the stupidity begin!  http://www.signonsandiego.com/news/metro/20080429-=
1514-bn29videogam.html
0
joel-garry (4553)
4/30/2008 8:38:12 PM
On 30 Apr, 21:38, joel garry <joel-ga...@home.com> wrote:
> On Apr 30, 11:46=A0am, Raj <jkama...@gmail.com> wrote:
>
>
>
> > SQL> alter database open
> > =A0 2 =A0/
> > alter database open
> > *
> > ERROR at line 1:
> > ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
> > ORA-01110: data file 7:
> > 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\EMEA\STAHOP_DATA01.DBF'
>
> Does this file exist? =A0Is it being locked by a virus scanner or backup
> program or editor or something?
>
>
>
>
>
>
>
> > I ran the lsnrctl status and got the following output:
>
> > C:\Documents and Settings\Administrator>lsnrctl status
>
> > LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 30-
> > APR-2008 11:21
> > :05
>
> > Copyright (c) 1991, 2006, Oracle. =A0All rights reserved.
>
> > Connecting to (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3DIPC)(KEY=3DEXTPROC1)=
))
> > STATUS of the LISTENER
> > ------------------------
> > Alias =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 LISTENER
> > Version =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 TNSLSNR for 32-bit Windows: =
Version
> > 10.2.0.3.0 - Produ
> > ction
> > Start Date =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A012-APR-2008 03:11:41
> > Uptime =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A018 days 8 hr. 9 min. 24 se=
c
> > Trace Level =A0 =A0 =A0 =A0 =A0 =A0 =A0 off
> > Security =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0ON: Local OS Authentication
> > SNMP =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0OFF
> > Listener Parameter File =A0 C:\oracle\product\10.2.0\db_1\network\admin
> > \listener.o
> > ra
> > Listener Log File =A0 =A0 =A0 =A0 C:\oracle\product\10.2.0\db_1\network\=
log
> > \listener.log
>
> > Listening Endpoints Summary...
> > =A0 (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dipc)(PIPENAME=3D\\.\pipe
> > \EXTPROC1ipc)))
> > =A0 (DESCRIPTION=3D(ADDRESS=3D(PROTOCOL=3Dtcp)(HOST=3Dsupport-db3)(PORT=
=3D1521)))
> > Services Summary...
> > Service "PLSExtProc" has 1 instance(s).
> > =A0 Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> > service...
> > Service "orcl10g" has 1 instance(s).
> > =A0 Instance "orcl10g", status READY, has 1 handler(s) for this
> > service...
> > # Generated by Oracle configuration tools.
>
> > ORCL10G =3D
> > =A0 (DESCRIPTION =3D
> > =A0 =A0 (ADDRESS_LIST =3D
> > =A0 =A0 =A0 (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D support-db3.actuate=
..com)(PORT
> > =3D 1521))
> > =A0 =A0 )
> > =A0 =A0 (CONNECT_DATA =3D
> > =A0 =A0 =A0 (SERVICE_NAME =3D orcl10g)
> > =A0 =A0 )
> > =A0 )
>
> Maybe a mismatch between your hostname and your fully qualified
> hostname? =A0Try briefly renaming your listener.ora to something else
> (or comment out the parts that refer to this db) and reload your
> listener and let your db register itself, see if the host is different
> with lsnrctl status. =A0That is, if you can get your db open. =A0I'm not
> sure whether you've ever had it open? =A0What does your alert log say
> about that? =A0Do you have a listener.trc file? =A0What is the last TNS-
> error in your listener.log? =A0Are there blocking errors?
>
> jg
> --
> @home.com is bogus.
> Let the stupidity begin! =A0http://www.signonsandiego.com/news/metro/20080=
429-1514-bn29videogam.html- Hide quoted text -
>

Er... is there a DBA handy?

HTH

-g
0
gareth2106 (865)
5/1/2008 9:24:29 AM
Reply:

Similar Artilces:

SN#12788 Java[TM] DataBase Connectivity API Features in Oracle 10g Database
SYSTEM NEWS FOR SUN USERS Vol 74 Issue 2 2004-04-12 Article 12788 from section "Developer's Section" Tutorial on Concepts and Usage The Oracle Technology Network provides a tutorial that outlines the features of Java[TM] DataBase Connectivity (JDBC[TM]) technology in relation to the new enhancements that they bring to the Oracle 10g database. The tutorial evaluates Web RowSets, Connection Cache, and Named Parameters, IEEE datatypes -- BINARY_DOUBLE and BINARY_FLOAT, and PL/SQL Index-by Tables. Each section in the tutorial covers topics such as concepts, design, required software, setup and application usage. Details at http://sun.systemnews.com/74/2/opt-dev/?12788#12788 Have a custom version of 'System News for Sun Users' delivered to you via email each week in PDF, text or HTML. Only the sections that you select will be included in your copy of the news magazine. Subscribe at http://sun.systemnews.com/subscribe (c) 2004 System News, Inc. http://www.systemnews.com ...

Using the DBI to connect to an Oracle server w/o connecting to a database
I've searched for the answer to this problem and have not seen it (which suggests what the answer might be ;-) ). Is it possible to use DBI (and DBD::Oracle) to connect to an Oracle server without connecting to a database? This would be the DBI equivalent of: sqlplus /nolog SQL> connect user/passwd@database; or, more similarly: sqlplus /nolog @my.sql where my.sql might be: connect user/passwd@database; select ... etc. I'm thinking this is not possible, but I hope it is. Thanks. Quoth Tim <google@hoodfamily.org>: > I've searched for the answer to this problem and...

Connectivity Between two saperate Database (oracle 8 and oracle 9i)
Dear Sir, We Would like to migrate to oracle 9i from oracle 8. Presently We are on oracle 8 (live) . Can anyone suggest a way by which we can phase out the migration process. We intend to migrate User-wise. We have aprx 10 live users.(e.g. finance, payroll, production etc..). My problem is inter-connectivity between diff. users. like 'Payroll' select/update rows in 'Finance'. If I migrate Finance from oracle 8 to Oracle 9i How to ensure that these select/update does not fail. Kishan Thakker kishanthakker@gmail.com wrote: > Dear Sir, > > We Would like to migrate to oracle 9i from oracle 8. Presently We are > on oracle 8 (live) . Can anyone suggest a way by which we can phase out > the migration process. We intend to migrate User-wise. We have aprx 10 > live users.(e.g. finance, payroll, production etc..). My problem is > inter-connectivity between diff. users. like 'Payroll' select/update > rows in 'Finance'. If I migrate Finance from oracle 8 to Oracle 9i How > to ensure that these select/update does not fail. > > Kishan Thakker How much data? Which version of 9i? Which version of 8? How much downtime is possible? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org ...

it's compatible oracle 8i client, compatible whith oracle 9i server (or oracle 10g server)
Hi all, I have a client/server application that work on the client with oracle 8i client connected to oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) , and I wonder if the client will work fine without upgrade version. Thanks Angel R. wrote: > Hi all, > I have a client/server application that work on the client with oracle 8i > client connected to > oracle 8i server, Im going to upgrade the server to oracle 9i (or oracle10g) > , and > I wonder if the client will work fine without upgrade version. > > Thanks If you have access to the metalink then check the connect matrix at http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=207303.1 Regards /Rauf ...

Unable to connect to Oracle 9i database via Oracle 6i Developer
I've successfully installed Oracle 9i Release 9.2.0.1.0 and Oracle Forms Developer and Forms Server 6i (Patch 2) on a stand-alone PC running on Windows XP Pro but cannot connect to my Oracle databases via Developer's various functions -- Graphics Builder, Query Builder, Schema Builder, Procedure Builder, and Translation Builder. As you know, these functions want to connect to a database but I get this error at the Connect screen: ORA-12154: TNS:could not resolve service name As info, the user name and password are fine for both Oracle 9i and Developer. Oracle 9i works fine. I can connect to my databases (Demo and OpsData) with no problem in 9i's SQLPlus window. It's the connections via Developer that's the problem. (In case you need to know, Oracle 9i reside in the C:\Oracle\ora92 directory with ora92 as the HOME. Developer 6i resides in the C:\Oracle\ora9i directory with ora9i as its HOME.) The TNSNAMES.ORA file for Oracle 9i reads as follows: # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora # Generated by Oracle configuration tools. OPSDATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = jgyk801)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OpsData.jgyk801) ) ) INST1_HTTP = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = jgyk801)(PORT = 1521)) ) (CON...

Oracle 10g 10.0.2 client, to connect oracle 8 server
Dear Group members, I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and 8i it is working very good with the 9i and 10g.. when i trying to connect 8i server ./. it giving error <b> "ORA-03134: Connections to this server version are no longer supported." </b> Can i install, 2 or more version of oracle clients in same system, becoz .. currently using client software is well configured for some SQL server BI agents, if i un-install current 10g client, it will infect my software .. process.. if, it can be possible, what kind of things i take care, before installation .. What is the best oracle client software can suitable for most of the server's On Jul 27, 11:58=A0pm, ranganadh <ranganadhkod...@gmail.com> wrote: > Dear Group members, > > =A0I am using Oracle 10 g 10.0.2 client software to connect 9i,10g and > 8i > > it is working very good with the 9i and 10g.. > when i trying to connect 8i server ./. it giving error > > <b> =A0"ORA-03134: Connections to this server version are no longer > supported." </b> > > Can i install, 2 or more =A0version of oracle clients in same system, > becoz .. currently using client software is well configured for some > SQL server BI agents, if i un-install current 10g client, it will > infect my software .. process.. > > if, it can be possible, what kind of things i take care, ...

username and password on Oracle connection string (jdbc:oracle:thin:@host:Port:dataBase)
Hi, Can an Oracle JDBC connection string take a username and password? The plain version of an Oracle connection string is jdbc:oracle:thin:@host:Port:dataBase If it's possible to add username/password to that string, what is the prorper syntax? Thanks for your help. Wolfgang. Wolfgang wrote: > > Can an Oracle JDBC connection string take a username and password? > The plain version of an Oracle connection string is > jdbc:oracle:thin:@host:Port:dataBase > > If it's possible to add username/password to that string, what is the > p...

Oracle database works properly but from designers tools I can't connect to database
I've installed Oracle 10G on my computer. I can log in using system account. by plsql. I've installed designer and tried to log from designers plsql to the same databse also using sys account - I could not't, I got ora-1017 error. What I'm doing wrong, why plsql from database installation connects me and one from designer installation disallow me from connecting ? I need databse just to run designer for entity and processes diagrams. I need Barkers notation so I can only use Oracle Designer because it's the only tool with Barkers notation. Hope to get some help from You, J...

username and password on Oracle connection string (jdbc:oracle:thin:@host:Port:dataBase)
Hi, Can an Oracle JDBC connection string take a username and password? The plain version of an Oracle connection string is username and password on Oracle connection string jdbc:oracle:thin:@host:Port:dataBase If it's possible to add username/password to that string, what is the prorper syntax? Thanks for your help. Wolfgang. "Wolfgang" <Mott@nospam.UNM.edu> wrote in message news:3f8330a6.24586984@nntp.ucsb.edu... > Hi, > > Can an Oracle JDBC connection string take a username and password? > The plain version of an Oracle connection string is username and > password on Oracle connection string > jdbc:oracle:thin:@host:Port:dataBase > > If it's possible to add username/password to that string, what is the > prorper syntax? Try to use: jdbc:oracle:thin:username/password@host:Port:dataBase > > Thanks for your help. > > Wolfgang. -- WBR, Andrey Vakhnin Try: DriverManager.getConnection ("jdbc:oracle:thin:@" + dbmsHost + ":" + dbmsPortNumber + ":" + dbmsName, userName, passWord); Frank. "Wolfgang" <Mott@nospam.UNM.edu> wrote in message news:3f8330a6.24586984@nntp.ucsb.edu... > Hi, > > Can an Oracle JDBC connection string take a username and password? > The plain version of an Oracle connection string is username and > password on Oracle connection string > jdbc:oracle:thin:@hos...

Oracle Database 10g. When ?
Hi I want to know when we could download Oracle Database 10g Thanks Javier Villegas wrote: >Hi > >I want to know when we could download Oracle Database 10g > >Thanks > > > If you were in the Beta program months ago. As you are not ... after it is released. And given that no software company is going to stick its neck out and commit to a specific date in advance ... you'll just have to learn patience. About all I can tell you is that from my experience it blows 9i away and when compared with its competition from other vensors is amazing. Especially if...

Oracle databases on a server
I have Oracle installation on a SUN UNIX server. I tappears that it is running Oracle 10.2 and Solaris 8. I want to find out how many databases are installed on this server. Would it be true to say that all databases installed on this server are listed in tnsnames.ora where the 'HOST' entry points to this server? On Feb 20, 9:00=A0am, p...@qantas.com.au wrote: > I have Oracle installation on a SUN UNIX server. I tappears that it is > running Oracle 10.2 and Solaris 8. > > I want to find out how many databases are installed on this server. > > Would it be true to s...

Dump Database / Porting Database to Oracle
Hi, I do not know much about informix. I have no running instance here, but its my job to transfer data from informix to oracle. - Is there a tool to dump a whoole database into an ASCII file? - In mysql there is a tool called "mysqldump" which dumps the whole database and create a file with sql statements (create, insert , insert ...), so you can transfer the whole database with mysqldump >file.sql and mysql <file.sql. Is there such a tool in informix? (I have seen that there is a infdump direcorty) - Is there a good way or a (cheap) tool to transfer a database from infomix to oracle? Best Regards Sven Anders, Digitec GmbH Sven Anders wrote: > Hi, > I do not know much about informix. I have no running instance here, > but its my job to transfer data from informix to oracle. > > - Is there a tool to dump a whoole database into an ASCII file? > > - In mysql there is a tool called "mysqldump" which dumps the whole > database and create a file with sql statements (create, insert , > insert ...), so > you can transfer the whole database with mysqldump >file.sql and mysql > <file.sql. Is there such a tool in informix? (I have seen that there > is a > infdump direcorty) dbexport > - Is there a good way or a (cheap) tool to transfer a database from > infomix to oracle? dbexport? -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi ...

What's a quick simple way to test Oracle connectivity between client and database server?
Gurus, Just learning Oracle. With help from a guru, installed 10g database on one server and 10g client on another. What's a quick simple way to test Oracle connectivity between these two servers at this point? -- Spin On Nov 1, 11:53=A0pm, "Spin" <S...@invalid.com> wrote: > Gurus, > > Just learning Oracle. =A0With help from a guru, installed 10g database on= one > server and 10g client on another. =A0What's a quick simple way to test Or= acle > connectivity between these two servers at this point? > > -- > Spin Try the tnsping utility: tnsping service_name The utility sends a message to listener specified by the tnsnames.ora file entry for the service_name listed on the command line and responds with ping type information. HTH -- Mark D Powell -- "Mark D Powell" <Mark.Powell@eds.com> wrote in message news:ce947e1a-0877-4e46-a638-91d48e92e403@u29g2000pro.googlegroups.com... On Nov 1, 11:53 pm, "Spin" <S...@invalid.com> wrote: Try the tnsping utility: tnsping service_name The utility sends a message to listener specified by the tnsnames.ora file entry for the service_name listed on the command line and responds with ping type information. HTH -- Mark D Powell -- Is service_name a placeholder for something or do I literally type "service_name"? Spin says... > "Mark D Powell" <Mark.Powell@eds.com> wrote in ...

Oracle 9i Database Server on Windows 2003 Server
I am wondering if we can install this Server on Windows 2003 Server without any problems. Is there anybody that did that before? Thanks in advance if someone know the answer. Yvon Bouchard, B. Sc. Computer Science Teacher http://info.cegepat.qc.ca/siteyvon I've installed it on windows 2003 enterprise ed. about 1 month ago without any problem. I've installed the version 9.2.0.1 with the patch to 9.2.0.3. 9.2.0.3 is the only version certified by oracle for win 2003. Ciao "Yvon Bouchard" <yvon.bouchard@cablevision.qc.ca> ha scritto nel messaggio news:QCLvb.21605$ZF1.2102185@news20.bellglobal.com... > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > > Yvon Bouchard, B. Sc. Computer Science > Teacher > http://info.cegepat.qc.ca/siteyvon > > > Yvon Bouchard wrote: > > I am wondering if we can install this Server on Windows 2003 Server without > any problems. > Is there anybody that did that before? > Thanks in advance if someone know the answer. > Although I have not installed on Windows 2003 myself, I know of several such installations and all occurred without issue. I do note that Oracle has a separate download (CD set) for the WIndows 2003 compared to NT/2000/XP, so I suspect the install for the latter may not be ...

Oracle Database 10g R2 RAC Installation On Red Hat Linux Using VMware Server
Hi, Does any one have the install doc for Oracle Database 10g R2 RAC Installation On Red Hat Linux Using VMware Server. I googled, I searched on OTN and also searched on Metalink but no luck. Thank you RA On May 29, 5:54 pm, RA <ang...@gmail.com> wrote: > Hi, > > Does any one have the install doc for Oracle Database 10g R2 RAC > Installation On Red Hat Linux Using VMware Server. I googled, I > searched on OTN and also searched on Metalink but no luck. > > Thank you > RA Wow you must have missed all the good spots. Try Jeffery Hunters site over at http://ww...

Oracle(r) Database 10g Release 2 Outperforms Microsoft SQL Server 2005 in Head-to-Head Comparison
Third Party Study Proves Oracle Database Can Deliver Substantial Savings Over Microsoft SQL Server 2005 Read Full Detail at http://technology-post.com/tech/?p=516 ...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100617.6f7b9f3e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? > > > Thanks for your help > &...

How to copy table from oracle database to sqlserver database ?
Hello, I need to copy a table from an 8i oracle database to a sqlserver 2000 database. Is it possible to use the command "COPY FROM ... TO ..." ? So, what is the correct syntax ? Thanks for your help Cyril On 10 Aug 2004, jewelk@free.fr wrote: > Hello, > > I need to copy a table from an 8i oracle database to a > sqlserver 2000 database. A few options exist. If this is one-off, just use sqlldr to drop the data to a file and then bcp to get it into SQLServer. > Is it possible to use the command "COPY FROM ... TO ..." ? > So, what is the correct syntax ? Well, I'm sure SQLServer has connectivity to Oracle? If you want to go this route, use that and do this from SQLServer. -- Galen Boyer On 10 Aug 2004 07:15:16 -0700, jewelk@free.fr (Cyril) wrote: >Hello, > >I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > >Is it possible to use the command "COPY FROM ... TO ..." ? >So, what is the correct syntax ? > > >Thanks for your help > >Cyril Read up on using the Heterogeneous Gateway to Sqlserver. -- Sybrand Bakker, Senior Oracle DBA "Cyril" <jewelk@free.fr> wrote in message news:cd38c3d6.0408100615.6371b40e@posting.google.com... > Hello, > > I need to copy a table from an 8i oracle database to a sqlserver 2000 database. > > Is it possible to use the command "...

tcl database connection for Oracle MySQL PostgreSQL Sybase "Microsoft SQL Server 2000 Desktop Engine" DB2 Interbase/Firebird SQLite Microsoft Access
Hello everyone, There are many people that are looking for/missing the support for their database within TCL. Somehow this was overlooked: http://sqlrelay.sourceforge.net/index.html It has native TCL API and supports most popular databases. One problem: It doesn't have production ready support on Windows, but for the lucky people who use Linux/Unix, it seems to be an excellent solution, while TDBC is being developed. One small correction, the TCL part of the db connection will work just fine on Windows connecting to sqlrelay running on Linux/Unix (which, in turn, can connect to the database running on Windows :) ). What doesn't have production ready support (according to developers) is sqlrelay running on Windows. ...

How i connect a ORACLE DataBase from sqlplus ?
Hei all, i want to connect to ORACLE Database( this run in Windows) from UNIX through sqlplus ?? I need to update any file in UNIX ? What ? Hugod@clix.pt Thnaks copy content from ORAHOME/network/admin/tnsnames.ora from windows into unix. That's all. Jiri ip wrote: > Hei all, > i want to connect to ORACLE Database( this run in Windows) from UNIX through > sqlplus ?? > > I need to update any file in UNIX ? What ? > > > > > Hugod@clix.pt > > Thnaks > > You need to modify your TNSNAMES.ORA file to create an alias to connect to the remote database. Use the Net Manager GUI tool to create your entry for you. HTH, Brian ip wrote: > > Hei all, > i want to connect to ORACLE Database( this run in Windows) from UNIX through > sqlplus ?? > > I need to update any file in UNIX ? What ? > > Hugod@clix.pt > > Thnaks -- =================================================================== Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" ...

problem connecting to oracle database
hello I hava a small Perl and a small Python CGI Skript. I have Python 2.3.3 and the newest cx_Oracle module. this is the error in my httpd_error.log RuntimeError: Unable to acquire Oracle environment handle at the start of the skript I set os.environ["ORACLE_HOME"] = "/opt/oracle/OraHome1/" this is the same as in the Perl skript and there it works. this is the code how I connect: try: connection = cx_Oracle.connect(user, passwd, "host.of.db.server") cursor = connection.cursor() except cx_Oracle.Error, e: print "Error %s" % e sys...

Attach a database in Oracle 10g
Hi, I have been sent a copy of a database and would like to be able to access it. I copied it to a subdirectory under the oradata directory. I'm using WinXP and Oracle 10g. How do I go about attaching to this database? I can use the Database Configuration Assistant to create a new database, but I can't find a way to attach to an existing one. Thanks, - Greg Greg Doherty wrote: > Hi, > > I have been sent a copy of a database and would like to be able to access > it. I copied it to a subdirectory under the oradata directory. I'm using > WinXP and Oracle 10g...

How to connect to Oracle database from SAS
Hi All, I have to connect to SQL server production database and convert the SQL data into SAS readable data. Can somebody tell/give me basic dummy code on how to convert some xyz file in oracle server to SAS work directory with same xyz name. Earlier is used to ask the systems team to convert it into txt file from which i used to import it into SAS readable format. What all things are needed for it. I connect to the development server like this sqlplus client/client@churndev and I know the following info about the location of the server (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.67.81)(PORT = ...

connecting to an oracle database... errors...
Im having a little bit of difficulty solving this simple error... I konw I have the URL correct, however I cannot connect to the Oracle 9 database. The error occurs on the line that I assign the connection (ConDB), Im a little lost, any help is appreciated! Thanks! ---- strURL = "jdbc:oracle:thin:@oradev.xxx.com:1521:dev.xxx.com"; strUser = "user" strPass = "pass" try { //register oracle driver DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); // DB logon ConDB = DriverManager.getConnection (strURL , strUser, strPass); } ------- java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334) at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3678) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:547) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:347) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at PhoneLookup.main(PhoneLooku...

Web resources about - Cannot connect to Oracle 10g database - comp.databases.oracle.server

Database - Wikipedia, the free encyclopedia
A database is an organized collection of data . The data are typically organized to model aspects of reality in a way that supports processes ...

Database - Wikipedia, the free encyclopedia
... requiring information. For example, modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. Database ...

Oracle: Fear Not, ’12c’ Database Nearing Its Breakout, Says Credit Suisse
... from cloud computing applications in 2016, along with the adoption by customers of the its “ 12c ” version of its flagship relational database ...

Open source database improves protection and performance
Most enterprises rely on databases in some form or another, but they can be vulnerable to attack from people looking to steal information. They ...

Seattle’s Tableau Software snaps up database-computing startup in Germany
Seattle’s Tableau Software has acquired HyPer, a database-computing startup that spun out of research at a university in Munich, Germany. As ...

NTTC's Liquid Products Database making steady progress
NTTC's Liquid Products Database making steady progress Modern Bulk Transporter NTTC is asking carriers to suggest “proprietary blends” for ...

TransGrid Switches Oracle Database Support to Rimini Street
TransGrid Switches Oracle Database Support to Rimini Street

Herbalife sinks on database error report
Herbalife said it had overstated growth in the number of "active new members" in some instances in the past three quarters due to database errors. ...

Taiwan launches database on areas vulnerable to quake damage
BEIJING (AP) — Earthquake-prone Taiwan is launching a database to inform residents which areas might be susceptible to creating potentially catastrophic ...

Microsoft's SQL database software now runs on Linux
Remember when Steve Ballmer likened Linux to cancer, and the notion of Microsoft courting the open source crowd was virtually unimaginable? The ...

Resources last updated: 3/15/2016 2:33:42 AM