can not change SID [message #364511] |
Mon, 08 December 2008 23:23 |
meisam
Messages: 14 Registered: August 2008 Location: malaysia
|
Junior Member |
|
|
Hi everybody,
I have created a new database using dbca, but the EM is still connecting the previous SID, how can I change my SID?
the other thins is that I am trying to connect to isqlplus, I am getting this error:
ERROR - ORA-12154: TNS: could not resolve the connect identifier specified.
what should write for connect identifier?
thanks
|
|
|
|
Re: can not change SID [message #364515 is a reply to message #364513] |
Mon, 08 December 2008 23:43 |
meisam
Messages: 14 Registered: August 2008 Location: malaysia
|
Junior Member |
|
|
Hi,
thank you for the reply, oracle DB is on Red hat. actually my tnsnames.ora is located in $ORACLE_HOME/network/admin/samples/
i have checked the tnsnames.ora, that is set properly. but when i aconnecting to the isqlplus, i dun know what to write for connect identifier.
>>net service name or database name
my database name is moon. i mean what i create with dbca is moon, so my connect identifier is moon ?
regards
|
|
|
|
Re: can not change SID [message #364556 is a reply to message #364529] |
Tue, 09 December 2008 01:23 |
meisam
Messages: 14 Registered: August 2008 Location: malaysia
|
Junior Member |
|
|
hi,
can you help me to tell me how to set this to the right location? I am REALLY confused.
when i open this page: http://192.168.0.175:5560/isqlplus
i have to enter 3 things,
user name: will be my database user name = moon
password: the one i set in dbca config while creating db
connect identifier: i enter database name = moon
i receive this:
ERROR - ORA-12154: TNS: could not resolve the connect identifier specified.
then you are telling me my tnsnames.ora is not in the right location.
could you please give me some steps if possible?
really appreciae it.
|
|
|
|