ORA-24314

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

RE: ORA-24314 -- Solution Found

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

RE: MIGRATION FROM Oracle 8.1.6 to 8.1.7 - Invalid Table Partitions

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

cannot allocate new log

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

RE: cannot allocate new log

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:

RE: cannot allocate new log --> Problem Solved

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

COMMIT's within cursor for loops

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

Oracle Instances not starting up via services

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

RE: Oracle Instances not starting up via 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 containing: UNSUB ORACLE-L :->(or the

RE: Oracle Instances not starting up via services

"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

RE: Oracle Instances not starting up via services

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

RE: Oracle Instances not starting up via services

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

RE: sqlnet.expire_time

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

RE: MTS v$session

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

RE: [Q] SQL Help!! How to make select left justify and fill space??

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

Inactive Sessions/Java

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

RE: Inactive Sessions/Java

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

RE: Inactive Sessions/Java

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

Shutting down Oracle servers

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

Server Shutdown

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

Trigger Question

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

RE: Trigger Question - Thanks for all the help

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) :-> :->