473,782 Members | 2,494 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem when using SQLPlus in Oracle 9i

Hi Everybody,

I am new to Oracle.
I just installed the Oracle9i (personal edition) on my Window XP
system. I am trying to simply run some basic SQL commands using
SQLPlus. After entering userid (system) password(manage r) and Host
String (my global database name), I am getting the following error and
it does not logme in:
can not run the service.

Would you please help me? Is default user name and password are
correct?

Sincerely,
AlexSM
Jul 19 '05 #1
2 8271
Sound like the Instance your trying to connect isn't started...
Check for Services into the "Computer management consol" if you can see it.
Otherwise you can startt it manually with the following command

z:\your_oracle_ home\ORACLE.EXE <global database name>

"Alex" <al****@eudoram ail.com> wrote in message
news:29******** *************** ***@posting.goo gle.com...
Hi Everybody,

I am new to Oracle.
I just installed the Oracle9i (personal edition) on my Window XP
system. I am trying to simply run some basic SQL commands using
SQLPlus. After entering userid (system) password(manage r) and Host
String (my global database name), I am getting the following error and
it does not logme in:
can not run the service.

Would you please help me? Is default user name and password are
correct?

Sincerely,
AlexSM

Jul 19 '05 #2
al****@eudorama il.com (Alex) wrote in message news:<29******* *************** ****@posting.go ogle.com>...
I tried that and I am still getting the following error when I try to
login to SQL PLUS:

Error:
ORA-12560: TNS: Protocol Adaptor Error

Any idea?

Sincerely,
Alex
"Nicolas Payre" <nicpayre[junk]@sympatico.ca> wrote in message news:<O9******* **********@news 20.bellglobal.c om>...
Sound like the Instance your trying to connect isn't started...
Check for Services into the "Computer management consol" if you can see it.
Otherwise you can startt it manually with the following command

z:\your_oracle_ home\ORACLE.EXE <global database name>

"Alex" <al****@eudoram ail.com> wrote in message
news:29******** *************** ***@posting.goo gle.com...
Hi Everybody,

I am new to Oracle.
I just installed the Oracle9i (personal edition) on my Window XP
system. I am trying to simply run some basic SQL commands using
SQLPlus. After entering userid (system) password(manage r) and Host
String (my global database name), I am getting the following error and
it does not logme in:
can not run the service.

Would you please help me? Is default user name and password are
correct?

Sincerely,
AlexSM


A 12560 error would indicate that Oranet (sqlnet, net8) either is not
installed or not configured correctly. First if you have not already
done so re-boot the machine. Then if the problem still exists open
the Oracle Net Configuration Assistent and look at the settings. The
ID used to install Oracle on your PC should have almost full
administration privileges.

HTH -- Mark D Powell --
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
11659
by: Jan Bols | last post by:
Whenever I execute TRIM(' ')in a stored procedure or trigger, I get an ORA-03113 error. I have an oracle db 8.1.7.0.1 Enterprise edition installed on a linux-Mandrake 9.1. EXEMPLE: I created the function IS_NULL which returns 1 or 0 if the parameter is empty or not:
2
2087
by: kantg | last post by:
Dear all, I am trying to install the oracle 9i on my laptop. I am not able to connect the sqlplus to the database. it says tns name resolution error or no listener. I configured using net configuration assitant and it automatically creats the tnsname.ora and listener.ora. the entries in both the files match i mean the protocol addressing and connect descritors. the naming method i choose was "local" and i choose the name service which was...
2
19451
by: massimo874 | last post by:
Please some one can tell me wich is the SQLPlus default script directory an how I can set it. I tryed by 'Define' but SQLPlus don't find the scripts I give it in input. WinXP, ORACLE 9i.
2
10515
by: Chris | last post by:
A weird issue...though hopefully not for everyone... I am trying to connect to a 10g database on a Red Hat Linux server from my 9i client on a XP pc. Both are on my local home network, behind a router. I can ping the linux server from my XP box successfully: C:\>ping 192.168.1.101
0
2395
by: tyousaf | last post by:
Hi i am new to mysql and mysql++, i have installed mysql server, it is running fine. i also installed "mysql++-1.7.9gcc3.2-2.i386.rpm" (i have gcc 3.3) , first of all as the readme file says to do automake, if i do that in the proper director it says "automake: 'configure.ac' or 'configure.in' is required" i dont know where to bring those files. secondly if i only compile simple1.cc using gcc proving all the link flags to libraries and...
5
5394
by: Michael Rudolph | last post by:
Hi newsgroup, I have an issue with the configuration of a DB2 federated database (WebSphere Information Integrator) in conjunction with the relational wrapper for Oracle on AIX. DB2 seems to not use the existing tnsnames.ora. The Oracle client is installed and the connection to the Oracle database using tnsping and sqlplus is possible (for the db2instance user). For that I changed the environment for the db2instanceuser and added the...
3
2645
by: Geoff Muldoon | last post by:
Cross-posted to comp.databases.oracle.misc and comp.lang.php ... Using PHP 4.3.11 on Linux and ADODB data abstraction library. Oracle client version is 10.1. Can successfully connect to remote database (version 9.2.0.6 on Linux NLS_LANG=AL32UTF8). When doing a simple select from a view:
0
2151
by: manir | last post by:
Hi, It would really be of great help if you could suggest a solution for me. Program: I need to execute a stored procedure from an Oracle server through a C++ program using oci.h (Oracle Call Interface) libraries of C. #include <oci.h> #define FMT "DAY, MONTH DD, YYYY"
2
213
by: Alex | last post by:
Hi Everybody, I am new to Oracle. I just installed the Oracle9i (personal edition) on my Window XP system. I am trying to simply run some basic SQL commands using SQLPlus. After entering userid (system) password(manager) and Host String (my global database name), I am getting the following error and it does not logme in: can not run the service.
0
10311
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10080
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8967
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7492
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6733
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5378
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4043
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3639
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2874
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.