| SYS account is locked (merged) [message #264927] |
Wed, 05 September 2007 01:10  |
KBalu12
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
Hi,
We installed Oracle 10g in our system. Then we installed Oracle SQL Developer(V1.2.1) to connect the database. While installing itself the user name created by default as SYSTEM. Then we tried to connect to connect the database using that user name , we given correct pwd only eventhough the system account is locked. We don't have DBA role and how to unlock the account. Kindly let me know soon, waiting for your reply at the earliest.
Regards,
Balu.
|
|
|
|
|
|
|
|
|
|
| Re: Sys Acct is locked [message #264942 is a reply to message #264940] |
Wed, 05 September 2007 01:38  |
KBalu12
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
Hi,
I tried that also that time also its giving same error that account is locked.
we given like this
connection : sys
username : SYSTEM
password : ORCLogin12
We selected role as default.
Suppose we are selecting role as SYSDBA means its giving invalid username/password.
What could be the problem and how to solve it. Kindly let me know soon.
Regards,
Balu.
|
|
|
|
|
|
|
|
|
|
| Re: Sys Acct is locked [message #264958 is a reply to message #264956] |
Wed, 05 September 2007 02:05 |
KBalu12
Messages: 4
Registered: September 2007
|
Junior Member |
|
|
Hi,
I said we don't have SYSDBA role, while installing the SQL Developer by default its created the username / pwd like SYSTEM / ORCLogin12. What to do now?
Regards,
Balu.
|
|
|
|
| Re: Sys Acct is locked [message #265147 is a reply to message #264958] |
Wed, 05 September 2007 09:45 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| KBalu12 wrote on Wed, 05 September 2007 01:05 | Hi,
I said we don't have SYSDBA role, while installing the SQL Developer by default its created the username / pwd like SYSTEM / ORCLogin12. What to do now?
Regards,
Balu.
|
Check the PLSQL developer manual.
Try to connect with your database USER,actually its providing you the interface to connect with your
database so try SCOTT or HR and may be it ask for service as well.And one more
thing you will need client as well if database server is not running at your pc.
[Updated on: Wed, 05 September 2007 09:49] Report message to a moderator |
|
|
|
| Re: Sys Acct is locked [message #265920 is a reply to message #265147] |
Fri, 07 September 2007 20:49 |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello KBalu12,
1) You have oracle database 10g installed;
2) You have oracle sql developer v1.2.1 installed;
3) You want to establish a connection from sql developer 1.2.1 onto oracle database 10g;
So you open sql developer tool and this tool offers to you a screen to register a new connection. Then you should provide:
connection = <your database SID, for example... any identifier>
username = SYS
password = <your SYS password>
role = SYSDBA
hostname = <ip of your 10g server>
port = <1521 for example>
SID = <your database SID>
or
connection = <your database SID, for example... any identifier>
username = SYSTEM
password = <your SYSTEM password>
role = default
hostname = <ip of your 10g server>
port = <1521 for example>
SID = <your database SID>
Once you filled out this connection register screen... you have options to "test", to "save" and to "login" as your convenience.
Regards
mson77
[Updated on: Fri, 07 September 2007 21:59] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: SYS account is locked (merged) [message #266210 is a reply to message #264927] |
Mon, 10 September 2007 03:52 |
tanveer40
Messages: 2
Registered: September 2007
|
Junior Member |
|
|
|
we have changed the name of computer and also changed from TNSnames.ORA file and brought this PC on domain. now we are logged onto by the domain user and the database is running ok and the normal system id of the oracle is also running but scott/tiger and sys dba is not working. kindly give me a solution for this.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
