Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

database

0 views
Skip to first unread message

rajesh...@gmail.com

unread,
Jun 5, 2007, 8:48:44 AM6/5/07
to
i Am facing the problem like Oracle Initialization or Shutdown in
Progres. But as per our logic i went to command prompt and typed
sqlplus /nolog
it enter into the SQl prompt,
after,
SQL> connect / as sysdba or connect sys/password as sysdba
for this command, it shows insufficent privileges.

What is the solution for me?? pls let me known as soon as possible

fitzj...@cox.net

unread,
Jun 5, 2007, 10:16:06 AM6/5/07
to

The problem is obvious: you are not using a sufficiently privileged O/
S account. The O/S account must be a member of the 'dba' group on
UNIX/Linux or the ORA_DBA group on Windows, and, on windows, must be a
local administrative account. A quick search of this newsgroup would
have likely produced any number of similar answers.

Since you don't provide the operating system you're using providing a
specific answer is impossible.


David Fitzjarrell

rajesh...@gmail.com

unread,
Jun 5, 2007, 10:58:23 AM6/5/07
to
thanks for help

i am using windows 2000 prof.

sybrandb

unread,
Jun 5, 2007, 10:59:39 AM6/5/07
to

I would recommend
a) bang your head a few times against your desk for being lazy
b) start reading those manuals
c) stop parasiting and abusing Usenet

--
Sybrand Bakker
Senior Oracle DBA

Fact: 99.9 percent of all questions on any Oracle forum have already
been asked and answered over and over again. This is because most
posters think they are the first to run into a problem and
consequently don't search Google.
They are wrong: they are not unique, they are with *too many*

sybrandb

unread,
Jun 5, 2007, 11:23:00 AM6/5/07
to
On Jun 5, 4:58 pm, rajeshdhu...@gmail.com wrote:
> thanks for help
>
> i am using windows 2000 prof.

Wrong answer.
Desupported centuries ago.

fitzj...@cox.net

unread,
Jun 5, 2007, 11:57:53 AM6/5/07
to
On Jun 5, 9:58 am, rajeshdhu...@gmail.com wrote:
> thanks for help
>
> i am using windows 2000 prof.

You follow my WINDOWS advice, then:

1) Ensure the user account is a LOCAL administrative account
2) Ensure this account is a member of the ORA_DBA group
3) Try again


David Fitzjarrell

Frank van Bortel

unread,
Jun 5, 2007, 3:39:11 PM6/5/07
to
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What about sqlnet.authentication_service=NTS?

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGZbvfLw8L4IAs830RAnEoAKCXlIAtjLmMfyUVeBCQBZ3dJoHxOgCgifd3
BiZccsbB1AcdMtBWoO38JBU=
=BTRz
-----END PGP SIGNATURE-----

fitzj...@cox.net

unread,
Jun 6, 2007, 9:07:33 AM6/6/07
to
On Jun 5, 2:39 pm, Frank van Bortel <frank.van.bor...@gmail.com>
wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>

Usually that's already configured by DBCA so I didn't mention it.
Yes, the sqlnet.ora should contain that entry.


David Fitzjarrell

0 new messages