| ramesh |
Posted: Feb 14, 2008 07:06:48 AM |
Total Post: 69
Joined: Dec, 2006
|
i'm not able to connect oracle 9i database with is on linux os
when i try to connect through normal user it shows that no shared memory exists
and when i try through system/sys as sysdba then
it gives err: insufficient privileges.
help me.
|
|
|
 arun |
| Posted: Feb 14, 2008 07:22:15 AM |  |
|
Total Post: 28
Joined: Sep, 2007
|
give details about sqlnet.ora file.
And try like connect / as sysdba
send ur reply
|
|
|
|
|
| ramesh |
| Posted: Feb 14, 2008 08:23:08 AM | |
|
Total Post: 40
Joined: Aug, 2007
|
Hellow Ramesh,
First u check all the parameters in pfile especially increase the size of shared memory because defaulty the share memory size is less that is why u get these type of errors while u r created the Database and also check what ever u r written the script that u made to create the database.
Regards,
Ramesh.M
|
|
|
|
|
| Rohit Chouhan |
| Posted: Feb 15, 2008 04:49:22 AM | |
|
Total Post: 11
Joined: Aug, 2007
|
Hi Ramesh,
Open SQLnet.ora file check for the following :
SQLNET.AUTHENTICATION_SERVICES= (NTS)
Make this parameter comment.
|
|
|
|
|
| Mohammed Taj |
| Posted: Feb 16, 2008 10:04:13 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
recreate password and try to connect with sys as sysdba user.
startup your database.
recreate spfile from pfile.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
