Hello,
When I try to connect to my Oracle instance on the W2K server that it
is installed on, using SQLPLUS (ie, SQLPLUS user/password@instan ce), I
get:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
If I try again at the "Enter user-name:" prompt with "user/password",
I then get:
ERROR:
ORA-12560: TNS:Protocol adapter error
On the server, the OracleOraHome92 TNSListener service and the
OracleServiceIn stance service are both running.
The TNSNAMES.ORA is pointing to the localhost and port 1521 (and TCP),
and the Listener.ora seems to be OK because it has TCP as a protocol,
the machinename as the host, and 1521 as the port. It also has a
second address as IPC with a key of EXTPROC0.
I didn't have a variable set for the oracle_sid, so I set this
manually (set oracle_sid=inst ance from a commandline) but there was no
change on that.
Oracle is 9.2.0.1.0, and it is running W2K service pack 4.
Not being an expert, I am not really sure what else to check so any
hints would be most welcome. I hope I haven't missed any vital piece
of info!
Cheers 8 12378
The CQMMAN wrote: Hello,
When I try to connect to my Oracle instance on the W2K server that it is installed on, using SQLPLUS (ie, SQLPLUS user/password@instan ce), I get:
ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
If I try again at the "Enter user-name:" prompt with "user/password", I then get:
ERROR: ORA-12560: TNS:Protocol adapter error
On the server, the OracleOraHome92 TNSListener service and the OracleServiceIn stance service are both running.
The TNSNAMES.ORA is pointing to the localhost and port 1521 (and TCP), and the Listener.ora seems to be OK because it has TCP as a protocol, the machinename as the host, and 1521 as the port. It also has a second address as IPC with a key of EXTPROC0.
I didn't have a variable set for the oracle_sid, so I set this manually (set oracle_sid=inst ance from a commandline) but there was no change on that.
Oracle is 9.2.0.1.0, and it is running W2K service pack 4.
Not being an expert, I am not really sure what else to check so any hints would be most welcome. I hope I haven't missed any vital piece of info!
Cheers
Try some real values; "instance" is not a valid SID name.
Check your services; it's the one called oracleserviceXX XX; the XXXX
is your SID.
Then issue -in a command line window-
set oracle_sid=XXXX and retry your start operation.
Alternatively, start the oracleserviceXX XX; if set up correctly,
it will also mount and open the database. Id oracleserviceXX XX
is already started, but you still get the 1034, follow procedure
as above.
--
Regards,
Frank van Bortel
Frank van Bortel <fv********@net scape.net> wrote in message news:<cb******* ***@news1.tilbu 1.nb.home.nl>.. . Try some real values; "instance" is not a valid SID name. Check your services; it's the one called oracleserviceXX XX; the XXXX is your SID. Then issue -in a command line window- set oracle_sid=XXXX and retry your start operation.
Alternatively, start the oracleserviceXX XX; if set up correctly, it will also mount and open the database. Id oracleserviceXX XX is already started, but you still get the 1034, follow procedure as above.
Ah, I did.. Sorry, just wrote "instance" instead of the actual
instance name..
Anyway it looks like it is up. Basically the database is not set to
start automatically so I needed to connect with SQLPLUS and the /nolog
switch and was then able to start it, and then connect.
Cheers
Frank van Bortel <fv********@net scape.net> wrote in message news:<cb******* ***@news1.tilbu 1.nb.home.nl>.. . Try some real values; "instance" is not a valid SID name. Check your services; it's the one called oracleserviceXX XX; the XXXX is your SID. Then issue -in a command line window- set oracle_sid=XXXX and retry your start operation.
Alternatively, start the oracleserviceXX XX; if set up correctly, it will also mount and open the database. Id oracleserviceXX XX is already started, but you still get the 1034, follow procedure as above.
Actually, if I can tack on to the end of this thread with another
question, I can now connect when logged on as the domain admin (the
user who installed Oracle), but when I logon as a domain user with
local admin rights on that W2K box, I get "insufficie nt privileges".
The "domain user/local admin" account is a member of the ORA_DBA group
on the local server, and in fact, I have created a domain group called
"Oracle admins", added the "domain user/local admin" account to it,
and added the group to the ORA_DBA group.
I have also looked in SQLNET.ORA and the line says:
SQLNET.AUTHENTI CATION_SERVICES = (NTS)
So, not sure what else I need to change to get that W2KAD account to
be able to start the database.
BTW, the Oracle services are running using the localsystem account...
Cheers
You have a basic set up problem.
Assuming you are trying to access a database for learning or just getting
started, the easiest way to get around this is to look at the Step By Step
instructions on how to install and access available at http://otn.oracle.com/obe
Follow the links for Oracle9i database, and look at Installation tutorial
/Hans cq****@yahoo.co .uk (The CQMMAN) wrote in message news:<65******* *************** ****@posting.go ogle.com>... Frank van Bortel <fv********@net scape.net> wrote in message news:<cb******* ***@news1.tilbu 1.nb.home.nl>.. .
Try some real values; "instance" is not a valid SID name. Check your services; it's the one called oracleserviceXX XX; the XXXX is your SID. Then issue -in a command line window- set oracle_sid=XXXX and retry your start operation.
Alternatively, start the oracleserviceXX XX; if set up correctly, it will also mount and open the database. Id oracleserviceXX XX is already started, but you still get the 1034, follow procedure as above.
Actually, if I can tack on to the end of this thread with another question, I can now connect when logged on as the domain admin (the user who installed Oracle), but when I logon as a domain user with local admin rights on that W2K box, I get "insufficie nt privileges".
The "domain user/local admin" account is a member of the ORA_DBA group on the local server, and in fact, I have created a domain group called "Oracle admins", added the "domain user/local admin" account to it, and added the group to the ORA_DBA group.
I have also looked in SQLNET.ORA and the line says:
SQLNET.AUTHENTI CATION_SERVICES = (NTS)
So, not sure what else I need to change to get that W2KAD account to be able to start the database.
BTW, the Oracle services are running using the localsystem account...
Cheers
Where in the installation instructions does Oracle recommend you
should be connected as the *domain* administrator when installing?
Answer: nowhere! You should install Oracle as *local* administrator
Sybrand Bakker
Senior Oracle DBA
Hi,
Have you change the password of windows administrator after oracle
installation.If yes then please follow the following steps.
1). In control panal windows services
2). open the property of "OracleServiceO RCL"
3). click on log on account tab
4). Clock on This account redio button
5). Mention the username and password you have change
6). Restart the services again or restart the computer
7). Try to connect through sqlplus
Enjoy.
regards,
Oracle sysman sy******@yahoo. com wrote in message news:<a1******* *************** ****@posting.go ogle.com>... cq****@yahoo.co .uk (The CQMMAN) wrote in message news:<65******* *************** ****@posting.go ogle.com>... Frank van Bortel <fv********@net scape.net> wrote in message news:<cb******* ***@news1.tilbu 1.nb.home.nl>.. .
Try some real values; "instance" is not a valid SID name. Check your services; it's the one called oracleserviceXX XX; the XXXX is your SID. Then issue -in a command line window- set oracle_sid=XXXX and retry your start operation.
Alternatively, start the oracleserviceXX XX; if set up correctly, it will also mount and open the database. Id oracleserviceXX XX is already started, but you still get the 1034, follow procedure as above.
Actually, if I can tack on to the end of this thread with another question, I can now connect when logged on as the domain admin (the user who installed Oracle), but when I logon as a domain user with local admin rights on that W2K box, I get "insufficie nt privileges".
The "domain user/local admin" account is a member of the ORA_DBA group on the local server, and in fact, I have created a domain group called "Oracle admins", added the "domain user/local admin" account to it, and added the group to the ORA_DBA group.
I have also looked in SQLNET.ORA and the line says:
SQLNET.AUTHENTI CATION_SERVICES = (NTS)
So, not sure what else I need to change to get that W2KAD account to be able to start the database.
BTW, the Oracle services are running using the localsystem account...
Cheers
Where in the installation instructions does Oracle recommend you should be connected as the *domain* administrator when installing? Answer: nowhere! You should install Oracle as *local* administrator
Sybrand Bakker Senior Oracle DBA
I never said anything about the installation instructions recommending
that I should be connected as the domain admin to do the install.
My question was, if I want to start the Oracle database while logged
on with a different account, what do I need to do to get it to work? I
thought I have been quite thorough in what I tried/checked, but I must
be missing something somewhere. or**********@ya hoo.com (Sajid Noor) wrote in message news:<78******* *************** ****@posting.go ogle.com>... Hi, Have you change the password of windows administrator after oracle installation.If yes then please follow the following steps. 1). In control panal windows services 2). open the property of "OracleServiceO RCL" 3). click on log on account tab 4). Clock on This account redio button 5). Mention the username and password you have change 6). Restart the services again or restart the computer 7). Try to connect through sqlplus
Enjoy.
regards, Oracle sysman
Thanks, but it is not quite the same problem. The services are running
fine, but when I connect with SQLPLUS, I cannot start the database
connected as SYSDBA unless I am logged on to the server with a
specific W2KAD account. So something is not quite right somewhere.
Thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Berthold Hoellmann |
last post by:
Hello,
When I use
./configure --with-thread --with-fpectl --with-signal-module \
--with-pymalloc --enable-shared --with-cxx=g++
make test
on 2.3.3 I get
|
by: santa19992000 |
last post by:
Confusing th eword with "library", "shared library" and how to use
these things in real C project, is there any small example I can take a
look. Thanks.
|
by: Jenna Schmidt |
last post by:
I know that one of the benefits of using "Shared" methods
is you do not explicitly have to Dim as New object to
access the method.
Are there some other implications with memory and
concurrency issues with lets say 25-50 concurrent users?
What are the pros and cons of using this type of method?
Thanks so much,
|
by: Ross |
last post by:
MyWebProject.MyWebForm1.someset.somedata is a datatable
within a dataset. Displays quite nicely, too. Now I want
to use the same data in MyWebProject.MyWebForm2. Being a
old, er, experienced Java programmer, I thought I could
write this as a member of MyWebForm1:
Public Shared Function getSomeData() As DataTable
getSomeData = somedata
End Function
|
by: John Granade |
last post by:
I'm looking for the best way to make a dataset available from multiple
Windows forms. The dataset is created from
an XML file. I have a main form (frmMain) that loads the dataset and reads
the data but then I have other forms that give the ability to add, modify,
and delete rows. This of course changes the dataset and I need that
reflected in the main form. At first I was actually passing a reference of
the dataset to the "modify" form...
| |
by: Carsten H. Pedersen |
last post by:
Hello
I want to create a kind of shared object. I have created a class,
Counter, which you can then import. Through the Counter class, i would
like to have access to a shared object.
Lets say that Counter contains only an int, initialised to 1. Each
time a class importing Counter would do Counter.getNextNumber(), the
getNextNumber() method would increase the local int, and return the
next number.
|
by: jbeteta |
last post by:
Hello,
I have a problem declaring variables. I need to create an object oRpte
as ReportClass on WebForm1.aspx and be able to use its value on
WebForm2.aspx.
For declaring the property oRpte() on WebForm1.aspx, I use "Public
Property" and I declare variable _oRpte as Friend Shared. That's my
problem. If I don't declare _oRpte as Friend Shared, I can't use
WebForm1.oRpte() on other webpage. If I declare _oRpte as Friend
Shared, I can use...
|
by: Morgan Cheng |
last post by:
To add HTTP Basic/Digest authentication to HttpWebRequest, I can use
NetworkCredential,
HttpWebRequest request =
(HttpWebRequest)WebRequest.Create("https://api.del.icio.us/v1/tags/
get");
request.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; .NET CLR 1.0.3";
request.Credentials = new NetworkCredential(username,
password);
|
by: The CQMMAN |
last post by:
Hello,
When I try to connect to my Oracle instance on the W2K server that it
is installed on, using SQLPLUS (ie, SQLPLUS user/password@instance), I
get:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
If I try again at the "Enter user-name:" prompt with "user/password",
|
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...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
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,...
|
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...
|
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...
|
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...
|
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
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| | |