1

Topic: How to learn the administrator oracle

Good afternoon, misters.
Prompt how to learn, please, under what user of Windows has been installed oracle?
Generally, a problem following: I can not come as
sqlplus / as sysdba
Though my current user is included in group ora_dba. Business in the domain can, in which my user is included, and  is installed by any local?
Help, please.

2

Re: How to learn the administrator oracle

Cheeses Crust;
How it is shown "I can not come"?
By an error leading "I can not come", googled?

3

Re: How to learn the administrator oracle

Cheeses Crust;
Sqlnet.ora, what in it?

4

Re: How to learn the administrator oracle

Kind  - Eh;
for water.
Produces:
Ora-01017: invalid username/password; logon denied

5

Re: How to learn the administrator oracle

UDW;
Sqlnet.authentication_services = (none)
names.directory_path = (tnsnames, ezconnect)
The increasing letters.
Whether there can be a business in recent attempts of adjustment of exterior authorization?

6

Re: How to learn the administrator oracle

Try
SQLNET.AUTHENTICATION_SERVICES = (NTS)

7

Re: How to learn the administrator oracle

Cheeses Crust wrote:

whether there Can be a business in recent attempts of adjustment of exterior authorization?

And what hinders to return all as was?

8

Re: How to learn the administrator oracle

Q.Tarantino;
I do not remember, whether came through / as sysdba that attempts of adjustment of exterior authorization.

9

Re: How to learn the administrator oracle

Alex89_NGD;
Stood nts, none. Too did not start up, but there was error TNS, the error text will be recreated tomorrow and I will write.

10

Re: How to learn the administrator oracle

On a local connection "/ as sysdba" - error TNS? You are assured?
...Try for a change "sqlplus/nolog" and already in the sqlplus-console - "conn / as sysdba".
Do not forget to check up/install beforehand in the console correct value ORACLE_SID

11

Re: How to learn the administrator oracle

Cheeses Crust wrote:

How to learn the administrator oracle

On an unshaven physiognomy. Here look on D, for certain had never a shave... I mean a muzzle of the person, remaining places I do not undertake... To state.

12

Re: How to learn the administrator oracle

. wrote:

it is passed...
On an unshaven physiognomy. Here look on D, for certain had never a shave... I mean a muzzle of the person, remaining places I do not undertake... To state.

[youtube=rg9MBCjdH00]

13

Re: How to learn the administrator oracle

andrey_anonymous, Alex89_NGD
Thanks.
Confused . Put was in incorrect  ORACLE_SID more shortly.
Delivered NTS, NONE (it and is logical, simple I in psychosis bursts nts removed)
Further, errors are possible:
> set ORACLE_SID=sid2
Where sid2 - an incorrect name of service
We receive tns, protocol adapter error
> set ORACLE_SID = sid
Where sid - a true name, but pay attention to gaps near to equal
We receive credential retrieval failed.
At the correct spelling all is good. Mine , as they say.
> set ORACLE_SID=sid

14

Re: How to learn the administrator oracle

When read a subject title, solved that the question has such sense: how to learn the administrator of Oracle among crowd.

15

Re: How to learn the administrator oracle

AmKad, consider that this question too the actual. The useful skill)