issue admin login [message #616701] |
Thu, 19 June 2014 15:54 |
|
tedinho123
Messages: 32 Registered: June 2014
|
Member |
|
|
Hi everyone,
My DBA administrator does not give me access to the Oracle 11g DB, when i try to login to SQLplus i get prompted to username and password but i dont have any sys or sysdba password, i need to create my user, please help??????
[MERGED by LF]
[Updated on: Fri, 27 June 2014 03:56] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
Re: issue admin login [message #616712 is a reply to message #616711] |
Thu, 19 June 2014 19:12 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
1) It appears that COPY & PASTE are broken for you.
2) the OS USER needs to be a member of the OS GROUP "ORA_DBA"
3) error free functionality can require proper values in the Windows Registry or some environmental variables being SET to correct values.
BTW - he, I, me & other indefinite pronouns are devoid of meaningful specifics since I am not standing behind you & can't see you or what you type.
Please post only actual OS username or Oracle schema names.
It appears are not qualified on either OS or Oracle to successfully use the back door to gain "/ as sysdba" access.
[Updated on: Thu, 19 June 2014 19:12] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: issue admin login [message #616759 is a reply to message #616701] |
Fri, 20 June 2014 08:05 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
tedinho123 wrote on Fri, 20 June 2014 02:24
My DBA administrator does not give me access to the Oracle 11g DB, when i try to login to SQLplus i get prompted to username and password but i dont have any sys or sysdba password, i need to create my user, please help??????
Are you a DBA? If not then you should NOT have sys or sysdba privilege. Read this for better understanding, SYS/SYSDBA is special.
|
|
|
Re: issue admin login [message #616760 is a reply to message #616744] |
Fri, 20 June 2014 08:06 |
|
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
tedinho123 wrote on Fri, 20 June 2014 04:59When i open oracle sqlplus it asks for a username, as i vdont know the username and password it gives me the error "ORA-12638:Extraction des préférences utilisateurs impossible"
Let me guess.
You are running sqlplus from your desktop.
The database is on another machine.
When you try to connect to the database, you don't actually specify a database name (actually a net service name).
So ... the client software assumes there is a database on your local machine, with the name specified by the current setting of ORACLE_SID. There is no such database, hence the error.
Frankly, if you are having this much trouble connecting to the database and not understanding why, I - as a DBA - would not allow you to be able to create a user account in the database. I would not allow you to connect with the kind of power that would allow such a thing. This is the kind of thing that if you can't work it out within your own staff, there is probably a reason that goes beyond the technical ....
[Updated on: Fri, 20 June 2014 08:10] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: issue admin login [message #616787 is a reply to message #616782] |
Fri, 20 June 2014 12:10 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
tedinho123 wrote on Fri, 20 June 2014 22:19I have been asked to create my user by my boss, but the DBA is away and won't give his passwords even though my boss asked him to do so...well he told to find a way to connect to the database
Hope your boss understands the consequences. Show him this thread. He might change his mind.
[Updated on: Fri, 20 June 2014 12:11] Report message to a moderator
|
|
|
|
|
Re: issue admin login [message #616799 is a reply to message #616795] |
Fri, 20 June 2014 12:26 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Why? Ask your boss why? Was it told to you about your role when your were hired? Just forget about it and wait for your DBA to come back.
What if somethimg gets screwed up and then Boss might take you for a ride. Can you justify it?
|
|
|
|
|
Re: issue admin login [message #616852 is a reply to message #616779] |
Sat, 21 June 2014 10:54 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
tedinho123 wrote on Fri, 20 June 2014 17:39lol its not, its a customs company in africa that manage statistics data Well, I know a bit about Africa. The usual rules do not apply.
I've just tested exactly the syntax you quoted above: Quote:when i use the connect sys /as sysdba it still asks for a password I get prompted for a password, but just hit RETURN and get connected:orcla>
orcla> conn sys /as sysdba
Enter password:
Connected.
orcla>
orcla> sho user
USER is "SYS"
orcla> I most definitely did NOT enter any password. That is not a syntax that I would usually use, but it works.
|
|
|
Re: issue admin login [message #616853 is a reply to message #616852] |
Sat, 21 June 2014 11:00 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
Kind of hacking Just kidding, but OP shouldn't get such ideas as he is not supposed to do that in anyway. At least, I would never want such thing to happen in my application, lest it should be a nightmare.
P.S. I have a client based out of Africa, basically telecom domain. Always eager to switch to latest release, but at the same time extrememly concerned about roles and privileges. I came to know about a junior DBA being fired because of using FLASHBAK DATABASE faeture in production without the project manager's concent. Hope he learnt a leaaon and would take utmost care in future.
[Updated on: Sat, 21 June 2014 11:09] Report message to a moderator
|
|
|
|
|
|
|
|