ORA-12514 with 10g Install

#81

Scout wrote:

Quote:

Thanks Frank.

You should be able to start the service either from the
services panel (My Computer->Right Mouse, Manage, iirc, or
via Control Panel). Start OracleServiceORCL (capitalization
is mine. Even from a DOS-box: net start OracleServiceORCL
should either report the service is already started, or start
it.
Yes, I know that.But would you know why the listener doesnt start?

Currently - no. Let's take it one step at the time.

Quote:

I think you should not use the listener at all (and for local
sessions you do not need the listener); just set the correct
environment (set ORACLE_SID=ORCL, %ORACLE_HOME%/bin is in
your path, %ORACLE_HOME% is set, etc), and you're done.
Can I connect to this DB using Toad without the listener? Or add
tables etc to the database without ever starting the listener?

But do you know why the listener doesnt start?

I think all problems are from the fact you sometimes are
logged on to a domain, and when you are, you are not a local administrator.
When you logon to your computer (using your computer's name
for a "domain"), you are local admin.
That, or vice versa.
In that case, should it not run flawlessly if I install when I am
logged in as the local administrator? I did already try installing XE
when I was logged onto the local box, and that caused the same issue.

XE has another issue (catching the hostname while installing);
I demonstrated that and reproduced your errors (see thread).
This version does not use an internal mechanism, but a freely
configurable listener (which we can't get to work).

Quote:

You should be able to logon to your default domain, even when
you are not connected to it - Windows uses a cache mechanism
that still allows you to login, even though your credentials
cannot be verified.
Sorr, I didnt get that. Are you implying that I should log on to the
network domain, or the local computer? Does Windows cache the login
when I try to connect to the local computer, or the domain? How can I
log in such that it will make it work?

You should be able to "log on" to your domain, while the network
cable is unplugged, that is what I meant.
Yes, MS Windows caches the domain credentials, I have been using
that mechanism for years. No longer than a week, I believe.

Quote:

Just give it a try, and let us know when things do work.
Thanks. Thsi time I logged onto the local box as admin, and tried the
same exercise you recommended.
Here are the results
---------------------
C:\oracle\product\10.2.0\db\BIN>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

?!??!? Beyond me...

Quote:

C:\oracle\product\10.2.0\db\BIN>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
on 23-JAN-2
008 21:59:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Message 3511 not found; No message file for product=NETWORK,
facility=TNSTNS-035
05: Message 3505 not found; No message file for product=NETWORK,
facility=TNS

Do you know whats going on now? I did recheck the ORACLE_HOME and the
Path. Is it that the settings have been installed for my network user
and not the local user, as a result, missing some setup?
Would this be solved if I installed while logged in as the local user?
(note that I have tried this with XE unsuccessfully)

I'd be happy if you got an ORA-01031, ORA-01034 or 1107.
Why is that?

That are repsonses by the instance - meaning we'd reach the
database itself. Network issues resolved...

Quote:

Again - do not worry about the listener - local access does
not need one! It just needs a correct environment!
Again, dont I need I listener to be able to create tables etc?

No.

Quote:

Also, the service OracleDBConsoleorcl doesnt start either. Isnt that
the one that links to the Enterprise Manager? I cant access the web
based enterprise manager either (http://localhost:1158/em)

Hmm.. You may have a point there.

Quote:

BTW how did you create an instance (the ORCL thing)?!?

When I installed it, there were options for 2 kinds of images - 1.
basic install with no basic DB and 2-install with an instance.
I picked the second one.

Fine - were you logged on to the domain, or locally? Try to

repeat the exercise similar to install time.
And how do you open a command line interface ("DOS box")
anyway? I cannot explain why your environment gets ruined every
time - because that is what your errors mean: I cannot get a decent
error message, because I don't know where to find it...
Start, Run, "cmd" would do it (no quotes..

)

Inline...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

#82

Scout wrote:

Quote:

Thanks Frank.

You should be able to start the service either from the
services panel (My Computer->Right Mouse, Manage, iirc, or
via Control Panel). Start OracleServiceORCL (capitalization
is mine. Even from a DOS-box: net start OracleServiceORCL
should either report the service is already started, or start
it.
Yes, I know that.But would you know why the listener doesnt start?

Currently - no. Let's take it one step at the time.

Quote:

I think you should not use the listener at all (and for local
sessions you do not need the listener); just set the correct
environment (set ORACLE_SID=ORCL, %ORACLE_HOME%/bin is in
your path, %ORACLE_HOME% is set, etc), and you're done.
Can I connect to this DB using Toad without the listener? Or add
tables etc to the database without ever starting the listener?

But do you know why the listener doesnt start?

I think all problems are from the fact you sometimes are
logged on to a domain, and when you are, you are not a local administrator.
When you logon to your computer (using your computer's name
for a "domain"), you are local admin.
That, or vice versa.
In that case, should it not run flawlessly if I install when I am
logged in as the local administrator? I did already try installing XE
when I was logged onto the local box, and that caused the same issue.

XE has another issue (catching the hostname while installing);
I demonstrated that and reproduced your errors (see thread).
This version does not use an internal mechanism, but a freely
configurable listener (which we can't get to work).

Quote:

You should be able to logon to your default domain, even when
you are not connected to it - Windows uses a cache mechanism
that still allows you to login, even though your credentials
cannot be verified.
Sorr, I didnt get that. Are you implying that I should log on to the
network domain, or the local computer? Does Windows cache the login
when I try to connect to the local computer, or the domain? How can I
log in such that it will make it work?

You should be able to "log on" to your domain, while the network
cable is unplugged, that is what I meant.
Yes, MS Windows caches the domain credentials, I have been using
that mechanism for years. No longer than a week, I believe.

Quote:

Just give it a try, and let us know when things do work.
Thanks. Thsi time I logged onto the local box as admin, and tried the
same exercise you recommended.
Here are the results
---------------------
C:\oracle\product\10.2.0\db\BIN>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

?!??!? Beyond me...

Quote:

C:\oracle\product\10.2.0\db\BIN>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
on 23-JAN-2
008 21:59:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Message 3511 not found; No message file for product=NETWORK,
facility=TNSTNS-035
05: Message 3505 not found; No message file for product=NETWORK,
facility=TNS

Do you know whats going on now? I did recheck the ORACLE_HOME and the
Path. Is it that the settings have been installed for my network user
and not the local user, as a result, missing some setup?
Would this be solved if I installed while logged in as the local user?
(note that I have tried this with XE unsuccessfully)

I'd be happy if you got an ORA-01031, ORA-01034 or 1107.
Why is that?

That are repsonses by the instance - meaning we'd reach the
database itself. Network issues resolved...

Quote:

Again - do not worry about the listener - local access does
not need one! It just needs a correct environment!
Again, dont I need I listener to be able to create tables etc?

No.

Quote:

Also, the service OracleDBConsoleorcl doesnt start either. Isnt that
the one that links to the Enterprise Manager? I cant access the web
based enterprise manager either (http://localhost:1158/em)

Hmm.. You may have a point there.

Quote:

BTW how did you create an instance (the ORCL thing)?!?

When I installed it, there were options for 2 kinds of images - 1.
basic install with no basic DB and 2-install with an instance.
I picked the second one.

Fine - were you logged on to the domain, or locally? Try to

repeat the exercise similar to install time.
And how do you open a command line interface ("DOS box")
anyway? I cannot explain why your environment gets ruined every
time - because that is what your errors mean: I cannot get a decent
error message, because I don't know where to find it...
Start, Run, "cmd" would do it (no quotes..

)

Inline...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

#83

Scout wrote:

Quote:

Thanks Frank.

You should be able to start the service either from the
services panel (My Computer->Right Mouse, Manage, iirc, or
via Control Panel). Start OracleServiceORCL (capitalization
is mine. Even from a DOS-box: net start OracleServiceORCL
should either report the service is already started, or start
it.
Yes, I know that.But would you know why the listener doesnt start?

Currently - no. Let's take it one step at the time.

Quote:

I think you should not use the listener at all (and for local
sessions you do not need the listener); just set the correct
environment (set ORACLE_SID=ORCL, %ORACLE_HOME%/bin is in
your path, %ORACLE_HOME% is set, etc), and you're done.
Can I connect to this DB using Toad without the listener? Or add
tables etc to the database without ever starting the listener?

But do you know why the listener doesnt start?

I think all problems are from the fact you sometimes are
logged on to a domain, and when you are, you are not a local administrator.
When you logon to your computer (using your computer's name
for a "domain"), you are local admin.
That, or vice versa.
In that case, should it not run flawlessly if I install when I am
logged in as the local administrator? I did already try installing XE
when I was logged onto the local box, and that caused the same issue.

XE has another issue (catching the hostname while installing);
I demonstrated that and reproduced your errors (see thread).
This version does not use an internal mechanism, but a freely
configurable listener (which we can't get to work).

Quote:

You should be able to logon to your default domain, even when
you are not connected to it - Windows uses a cache mechanism
that still allows you to login, even though your credentials
cannot be verified.
Sorr, I didnt get that. Are you implying that I should log on to the
network domain, or the local computer? Does Windows cache the login
when I try to connect to the local computer, or the domain? How can I
log in such that it will make it work?

You should be able to "log on" to your domain, while the network
cable is unplugged, that is what I meant.
Yes, MS Windows caches the domain credentials, I have been using
that mechanism for years. No longer than a week, I believe.

Quote:

Just give it a try, and let us know when things do work.
Thanks. Thsi time I logged onto the local box as admin, and tried the
same exercise you recommended.
Here are the results
---------------------
C:\oracle\product\10.2.0\db\BIN>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

?!??!? Beyond me...

Quote:

C:\oracle\product\10.2.0\db\BIN>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
on 23-JAN-2
008 21:59:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Message 3511 not found; No message file for product=NETWORK,
facility=TNSTNS-035
05: Message 3505 not found; No message file for product=NETWORK,
facility=TNS

Do you know whats going on now? I did recheck the ORACLE_HOME and the
Path. Is it that the settings have been installed for my network user
and not the local user, as a result, missing some setup?
Would this be solved if I installed while logged in as the local user?
(note that I have tried this with XE unsuccessfully)

I'd be happy if you got an ORA-01031, ORA-01034 or 1107.
Why is that?

That are repsonses by the instance - meaning we'd reach the
database itself. Network issues resolved...

Quote:

Again - do not worry about the listener - local access does
not need one! It just needs a correct environment!
Again, dont I need I listener to be able to create tables etc?

No.

Quote:

Also, the service OracleDBConsoleorcl doesnt start either. Isnt that
the one that links to the Enterprise Manager? I cant access the web
based enterprise manager either (http://localhost:1158/em)

Hmm.. You may have a point there.

Quote:

BTW how did you create an instance (the ORCL thing)?!?

When I installed it, there were options for 2 kinds of images - 1.
basic install with no basic DB and 2-install with an instance.
I picked the second one.

Fine - were you logged on to the domain, or locally? Try to

repeat the exercise similar to install time.
And how do you open a command line interface ("DOS box")
anyway? I cannot explain why your environment gets ruined every
time - because that is what your errors mean: I cannot get a decent
error message, because I don't know where to find it...
Start, Run, "cmd" would do it (no quotes..

)

Inline...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

#84

Scout wrote:

Quote:

Thanks Frank.

You should be able to start the service either from the
services panel (My Computer->Right Mouse, Manage, iirc, or
via Control Panel). Start OracleServiceORCL (capitalization
is mine. Even from a DOS-box: net start OracleServiceORCL
should either report the service is already started, or start
it.
Yes, I know that.But would you know why the listener doesnt start?

Currently - no. Let's take it one step at the time.

Quote:

I think you should not use the listener at all (and for local
sessions you do not need the listener); just set the correct
environment (set ORACLE_SID=ORCL, %ORACLE_HOME%/bin is in
your path, %ORACLE_HOME% is set, etc), and you're done.
Can I connect to this DB using Toad without the listener? Or add
tables etc to the database without ever starting the listener?

But do you know why the listener doesnt start?

I think all problems are from the fact you sometimes are
logged on to a domain, and when you are, you are not a local administrator.
When you logon to your computer (using your computer's name
for a "domain"), you are local admin.
That, or vice versa.
In that case, should it not run flawlessly if I install when I am
logged in as the local administrator? I did already try installing XE
when I was logged onto the local box, and that caused the same issue.

XE has another issue (catching the hostname while installing);
I demonstrated that and reproduced your errors (see thread).
This version does not use an internal mechanism, but a freely
configurable listener (which we can't get to work).

Quote:

You should be able to logon to your default domain, even when
you are not connected to it - Windows uses a cache mechanism
that still allows you to login, even though your credentials
cannot be verified.
Sorr, I didnt get that. Are you implying that I should log on to the
network domain, or the local computer? Does Windows cache the login
when I try to connect to the local computer, or the domain? How can I
log in such that it will make it work?

You should be able to "log on" to your domain, while the network
cable is unplugged, that is what I meant.
Yes, MS Windows caches the domain credentials, I have been using
that mechanism for years. No longer than a week, I believe.

Quote:

Just give it a try, and let us know when things do work.
Thanks. Thsi time I logged onto the local box as admin, and tried the
same exercise you recommended.
Here are the results
---------------------
C:\oracle\product\10.2.0\db\BIN>sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software
directory

?!??!? Beyond me...

Quote:

C:\oracle\product\10.2.0\db\BIN>tnsping ORCL

TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production
on 23-JAN-2
008 21:59:18

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Message 3511 not found; No message file for product=NETWORK,
facility=TNSTNS-035
05: Message 3505 not found; No message file for product=NETWORK,
facility=TNS

Do you know whats going on now? I did recheck the ORACLE_HOME and the
Path. Is it that the settings have been installed for my network user
and not the local user, as a result, missing some setup?
Would this be solved if I installed while logged in as the local user?
(note that I have tried this with XE unsuccessfully)

I'd be happy if you got an ORA-01031, ORA-01034 or 1107.
Why is that?

That are repsonses by the instance - meaning we'd reach the
database itself. Network issues resolved...

Quote:

Again - do not worry about the listener - local access does
not need one! It just needs a correct environment!
Again, dont I need I listener to be able to create tables etc?

No.

Quote:

Also, the service OracleDBConsoleorcl doesnt start either. Isnt that
the one that links to the Enterprise Manager? I cant access the web
based enterprise manager either (http://localhost:1158/em)

Hmm.. You may have a point there.

Quote:

BTW how did you create an instance (the ORCL thing)?!?

When I installed it, there were options for 2 kinds of images - 1.
basic install with no basic DB and 2-install with an instance.
I picked the second one.

Fine - were you logged on to the domain, or locally? Try to

repeat the exercise similar to install time.
And how do you open a command line interface ("DOS box")
anyway? I cannot explain why your environment gets ruined every
time - because that is what your errors mean: I cannot get a decent
error message, because I don't know where to find it...
Start, Run, "cmd" would do it (no quotes..

)

Inline...

--

Regards,
Frank van Bortel

Top-posting in UseNet newsgroups is one way to shut me up

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

ORA-12514 with 10g Install

comp.databases.oracle.misc comp.databases.oracle.misc

Re: ORA-12514 with 10g Install (LONG...) - 01-24-2008 , 02:04 PM

Re: ORA-12514 with 10g Install (LONG...) - 01-24-2008 , 02:04 PM

Re: ORA-12514 with 10g Install (LONG...) - 01-24-2008 , 02:04 PM

Re: ORA-12514 with 10g Install (LONG...) - 01-24-2008 , 02:04 PM