-
ORA-01031: insufficient privileges
can someone help please? i have just run sqlplus /nolog and i am trying to connect to an existing database with the command
SQl> connect sys as sysdba
Enter Password: here i gave change_on_install
and it gives me
ORA-01031: insufficient privileges
another problem...
i executed the following..
SQL> connect
Enter user_name: system
password: manager
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: no such file or Directory
whats the cause of this problem and how do i fix it?
please help.
-
Originally Posted by bjayaram
SQl> connect sys as sysdba
Enter Password: here i gave change_on_install
and it gives me
ORA-01031: insufficient privileges
AFAIK, this can only be due to the fact that you are not connected as the correct OS user ("oracle" in general), because the "as sysdba" connection uses OS authentification (under UNIX-like OS, the user has to belong to the "dba" group).
Originally Posted by bjayaram
SQL> connect
Enter user_name: system
password: manager
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: no such file or Directory
whats the cause of this problem and how do i fix it?
please help.
You cannot connect as another user than sys because Oracle is not started yet . This is because users other than sys do connect via the listener and Oracle authentification, not via local OS authentification.
HTH & Regards,
rbaraer
-
The second part is wrong, he isnt connecting via the listener is the second connection attempt
-
Hey Davey what do you want to bet he's on a Windoz box?
Hence his connection problems.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
im on a linux 9.5 os system...
-
and what is a linux 9.5 system?
-
ok.. i had doubts myself if the problem was with the user.. now i had a user called oracles user previously with which i used to login. but i took a break for a month on vacations and my sys admin i guess made some changes...
so now i want to create a user who can have access to the database and can connect using the sys as sysdba command..
how do i do this?
-
you need a user in the dba group
-
ok
ill check if the user exists. i doubt the sys admin has mapped my user login to the server. i will also try to unmap it and check out if my username is correct. possibilities exist tht i have forgotten my username.
tnks for the suggestion. if nothing works, ill create a new user. is it possible to create one now????
thnks in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|