| cannot create user account [message #151938] |
Mon, 19 December 2005 23:07  |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
|
Why i login using SYSDBA user account,I cannot create the password and the user account for the client .Why it happend?
|
|
|
|
|
|
|
|
| Re: cannot create user account [message #151974 is a reply to message #151966] |
Tue, 20 December 2005 03:18  |
ramsat
Messages: 49
Registered: November 2005
|
Member |
|
|
Ur error message says that u have lost connection with the database to which u r trying to connect.
Try creating the tnsnames file again using the net configuration assistant.
If it is successful and still then u suffer any problem go to console mode and try giving the followig command
tnsping <tnsnames-- usually instance name> Ok!
in case of any establishing connection werror u can see here.
If u r a client and the database is not installed in ur machine u cannot connect as sysdba and that too special privileges should be given to him.
Check it out and come again if u have any problem
|
|
|
|
| Re: cannot create user account [message #152163 is a reply to message #151974] |
Wed, 21 December 2005 07:57 |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
|
Does i need to delete the existing tnsnames file before i create the new one?I want to use the same SID i have use before. connect matrix02/******@psm2006.I still need to use psm2006.So does i need to delete it before i need to create new one and give the same name?How to delete it?. i can connect the sys user when i on the server side, but when i on the client side, i can't connect the sys user.The password it's ok .I got the error like "this Ora-12560 TNS:protocol adapter error".Why it happend?How to solve it?
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
