Schema Disappear from database
Hi,
I try to set the database date to 01/11/2011 by using
alter system set nls_date_format = ''.
then i restart my database from window services .
suddenly i can't connect to this database.
i have two database the default database orcl and my database
NewDb i got this error.
ORA-12154: TNS:could not resolve the connect identifier specified .
then i try alot to connect to my database but i can't until yesterday.
i change the listener.ora like this :
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc))
(SID_DESC =
(SID_NAME = NewDb)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc))
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc))
)
Then i use alter system set service_name = NewDb.
but when i select username from dba_users; my schema user dosn't exists .
My enviroment
window xp.
db version : 10.1.0.4.2.
I appreciates for help ...............
Regards,