OraFAQ Forum: Server Administration » Connecting through enterprise manager

Home » RDBMS Server » Server Administration » Connecting through enterprise manager

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting through enterprise manager [message #209362]

Thu, 14 December 2006 07:50

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

i created a user in oracle and when I connects to database through EM, I gets error

"insufficient privileges"

in CONNECT AS, i tried NORMAL,SYSOPER,SYSDBA ..but no luck .

any clue ?

Report message to a moderator

Re: Connecting through enterprise manager [message #209364 is a reply to message #209362]

Thu, 14 December 2006 07:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi

are you able to connect on "sqlplus"

reply...

Taj

Report message to a moderator

Re: Connecting through enterprise manager [message #209366 is a reply to message #209362]

Thu, 14 December 2006 07:56

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

yes from SQLplus i can connect .

conn username/password
it works.

Report message to a moderator

Re: Connecting through enterprise manager [message #209370 is a reply to message #209366]

Thu, 14 December 2006 08:03

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

you can connect with tns_entry "usrid/pwd@tns_entry".

if yes then check ur sqlnet.ora file
sqlnet.authentication.services= ? ( none or nts)

regards
Taj

Report message to a moderator

Re: Connecting through enterprise manager [message #209376 is a reply to message #209362]

Thu, 14 December 2006 08:19

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

but i have another username ,with which i can connect from EM.
CONNECT as NORMAL.
i think then i shouldnt be a pbm with tns,right ?

Report message to a moderator

Re: Connecting through enterprise manager [message #209384 is a reply to message #209376]

Thu, 14 December 2006 08:44

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

are you getting

invalid username or password / insufficient priviliges.

invalid username or password then add ur OS "log on as a batch job"

start >>> settings >>> control panel >>> administrative tools >>>

local security policy >>> user right assignment >>> "log on as a batch job"

then try to connect.
regards
Taj

Report message to a moderator

Re: Connecting through enterprise manager [message #209386 is a reply to message #209362]

Thu, 14 December 2006 08:45

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

On server,i dont see any sqlnet.ora file under $ORACLE_HOME/network/admin .

Report message to a moderator

Re: Connecting through enterprise manager [message #209388 is a reply to message #209362]

Thu, 14 December 2006 08:52

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Taj,for your information i will give more details.
my Oracle DB is running on UNIX.
and I am connecting from WINDOWS using EM.

windows i loged in as WINUSER.
and i use orauser1 to connect to oracle database.connect as NORMAL.it WORKS!!!!!
then i try connect as orauser2.then i get "insufficient privileges"

Report message to a moderator

Re: Connecting through enterprise manager [message #209390 is a reply to message #209388]

Thu, 14 December 2006 09:02

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

Through orauser2 you connect "NORMAL" or "SYSDBA".

check on ur server. sqlnet.ora file.
sqlnet.authentication.services = [NONE,NTS]
or
User member of ORA_DBA group.

then you can connect "SYSDBA".

regards
Taj

Report message to a moderator

Previous Topic:	Error with OCI8 Driver
Next Topic:	difference between dba_registry_log and dba_server_registry views.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:31:19 CDT 2024