?
Solved

Oracle

Posted on 2003-03-15
8
Medium Priority
?
227 Views
Last Modified: 2012-05-04
I succeeded to log onto sql_plus 3.1 using username: scott and password: tiger and left the hoststring blank. But later on when I tried again I failed. The message:
ERROR: ORA-03121: (Cnct err, can't get err txt.  See Servr Msgs & Codes Manual)
ERROR: ORA-09354: (Cnct err, can't get err txt.  See Servr Msgs & Codes Manual)

Help me!!!
0
Comment
Question by:poobalan18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 5

Expert Comment

by:DrJekyll
ID: 8146050
When you tried the 2nd time did you do it with host string.
It appears you need to install/configure sql*net again.
Can you get connected without host string. I assume you
are doing this locally from the server. What is OS and Oracle version?
0
 
LVL 21

Expert Comment

by:oleggold
ID: 8146811
Look for Your question at:
http://otn.oracle.com/pls/db92/db92.error_search?search='Your Error here'

ORA-03121 no interface driver connected - function not performed
This is the only what I found:
If you are using an Oracle V6 based application you will get an ORA-03121 when  trying to connect via SQL*Net V2 if you don't use the "tns:" net prefix in the  connect string.  An Oracle V6 based application means that the application is  linked to use ORA6WIN.DLL.  If the application is linked to use ORA7WIN.DLL,  the "tns:" prefix is not needed.      
0
 

Expert Comment

by:ameenavasim
ID: 8148136
u can try shutting down oracle database,restarting it and then trying again. this error sometimes comes if the oracle task dies unexpectedly
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

Expert Comment

by:AspireDBA
ID: 8150454
Hi Poobalan18,

Reinstalling would help, I suppose some DLLs are missing or have gone corrupt.

Regards,

Suresh

www.aspiredba.com

0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 8152671
Don't re-install anything yet.  Please give us some more information.

1. Did you only succeed in logging in to SQL*Plus just one time, and every other attempt failed?

2.  Where is the database, on your PC, on a network server, etc?

3. Which Oracle software do you have installed on the machine you are using SQL*Plus on?  Oracle client software only (which version)?  Also Oracle database software (which version)?
0
 
LVL 1

Expert Comment

by:jim144
ID: 8171005
You need to set your $ORACLE_HOME .... your environment does not know where it is ....
0
 

Accepted Solution

by:
amp072397 earned 0 total points
ID: 10636860
PAQed - no points refunded (of 250)

Thanks very much!
amp, ee admin, amp*at*experts-exchange.com
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question