Hello All,
I've been connecting to a customers server via VPN.
I've been able to connect to the database on the server via SQLPLUS & Toad
but when I try to do an import or connect via SQLPLUS /NOLOG I get an
ORA-24314 error (no service handler).
I've tried looking for an answer on the web but
t and web hosting services
:->-
:->To REMOVE yourself from this mailing list, send an E-Mail message
:->to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
:->the message BODY, include a line cont
n (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California--
pace is not an issue.
Thanks - all advice appreciated,
N.
(developer/part-time DBA)
___
Nuala Cullen
Catlogic
30 Park Gate
Milton Park
Abingdon
Oxfordshire
OX14 4SH
Phone: +44 (0) 1235 838151
Fax:+44 (0) 1235 838160
Direct Line: +44 (0) 1235 838147
___
<>
he archive
:->logs and make sure that drive hasn't filled. For the logs
:->themselves, check
:->the paths and permissions.
:->
:->Dennis Williams
:->DBA, 80%OCP, 100% DBA
:->Lifetouch, Inc.
:->[EMAIL PROTECTED]
:->
:->
:->-Original Message-
:->From:
ve read the archive files regarding this error but
:->thought that the
:->above set-up was sufficient.
:->Can anybody *please* give me some idea of what other areas I
:->should be
:->looking at in order to prevent the error from occurring.
:->Would writing smaller files help? Disk sp
RACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To R
Hi All,
I have inherited a couple of databases on one of the servers here. The
server was taken down for hardware repairs during the week and when it came
back up the databases did not start. (They are set to start automatically
via the services)
I have done some research via the internet and I
---
:->To REMOVE yourself from this mailing list, send an E-Mail message
:->to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
:->the message BODY, include a line containing: UNSUB ORACLE-L
:->(or the
"LRM-00109 can not open parameter file
'%oracle_home%/database/init%oracle_sid%.ora"
is as it appeared on the screen.
N.
:->-Original Message-
:->From: Jared Still [mailto:[EMAIL PROTECTED]
:->Sent: 16 July 2003 14:31
:->To: [EMAIL PROTECTED]; Nuala Cullen
:-&g
t City Network Services-- 858-538-5051 http://www.fatcity.com
:->San Diego, California-- Mailing list and web hosting services
:->-
:->To REMOVE yourself from this mailing list, send an E-Mail message
:->t
1.- can you send your environment variables? (my_pc ->
:->properties -> advanced -> environment variables)
:->
:->2.- can you send your Oracle registry values?
:->
:->JL
:->
:->--- Nuala Cullen <[EMAIL PROTECTED]> wrote:
:->>
:->> Hi Jared,
:->>
:->> T
sage BODY, include a line containing: UNSUB ORACLE-L
:->(or the name of mailing list you want to be removed from). You may
:->also send the HELP command for other information (like subscribing).
:->
:->
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Au
Title: MTS v$session
Hi
Kurt,
Have
you set the sqlnet.expire_time in the sqlnet.ora file?
N.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand,
KurtSent: 01 August 2003 16:19To: Multiple recipients of
list ORACLE-LSubject: MTS v$ses
UB ORACLE-L
:->(or the name of mailing list you want to be removed from). You may
:->also send the HELP command for other information (like subscribing).
:->
:->
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
Hi All,
I have a problem with inactive sessions (despite having set the
sqlnet.expire parameter)
Some of the users connect to the database via a java process - when I stop
this process from running the number of sessions just shots right down.
Short of scheduling a start and restart of this
PROTECTED] (note EXACT spelling of 'ListGuru') and in
:->the message BODY, include a line containing: UNSUB ORACLE-L
:->(or the name of mailing list you want to be removed from). You may
:->also send the HELP command for other information (like subscribing).
:->
:->
--
Please
.orafaq.net
:->:->--
:->:->Author: Tanel Poder
:->:-> INET: [EMAIL PROTECTED]
:->:->
:->:->Fat City Network Services-- 858-538-5051
http://www.fatcity.com
:->San Diego, California-- Mailing list and web hosting services
:->--
on a regular basis is good - but I need proof before I
schedule such a job.
Thanks,
N.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif
ave a JAVA service running on the server that is responsible for
loading data into the database.
Thanks,
N.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nuala Cullen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
Hi All,
Firstly my apologies if this seems like a very *stupid* question but I'm a
tad confused (and it's late in the evening)
When an AFTER INSERT trigger is fired (row level) has the row been committed
to the database at this stage?
If so is it ok to call a package in the trigger that selects
RACLE-L
:->Subject: Re: Trigger Question
:->
:->
:->Ok. Here you go.
:->
:->http://osi.oracle.com/~tkyte/Mutate/index.html
:->
:->Let me know if you find this useful.
:->
:->HTH
:->
:->GovindanK
:->OCP 8,8i
:->Brainbench Certified Master DBA(8)
:->
:->
22 matches
Mail list logo