This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / 紧急求助：在Enterprise Manger 里修改了ORACLE 10g SGA 的几个内存配置，ORACLE INSTANCE起来LISTNER连不上了。 没有备份。有办法回复吗？ 几个星期的心血呀，全没了！万分感谢！
-changeit(growing);
2007-1-31
(#3469270@0)
-
在DB服务器上进入SQLPLUS不需要LISTENER,所以你可以进去改参数作备份等。你还可以运行lsnrctl去启动LISTENER
-newkid(newkid);
2007-1-31
(#3469308@0)
-
It looks like that the instance is not right.I can't connect to DB even from the server. When I started it it didn't have any error message and the service status is started. But when I started listner it complained that instance status is unknown. I think I need to change the setting for SGA. Any comments. Thanks a lot.
-changeit(growing);
2007-2-1
{279}
(#3470616@0)
-
检查alert log看里面记载了什么错误；如果仅仅是参数修改还可以用指定的PFILE启动数据库
-newkid(newkid);
2007-2-1
(#3470752@0)
-
I tried PFILE and it didn't work. Can I copy a PFILE from anywhere else? Please provide a PFILE if you have one and I will try . Thanks. It is windows2000.
-changeit(growing);
2007-2-3
(#3476018@0)
-
How can I check Alter log? I am not a DBA. Thanks
-changeit(growing);
2007-2-3
(#3476029@0)
-
what evnironment? you can set hte oracle_sid environment variable first from OS level and then sqlplus as sysdba. then do whatever you want. 10g can do self registration for the listener...
-tootoo(倚老卖老);
2007-2-2
(#3473617@0)
-
post you tnsnames and listner file from DB server, plus1. tnsping service name, and result?
2. what errror message when you try to ster listener
3. what parameter did you changed
4. are you sure the oracle instance is started?
-alan_wang99(东流水);
2007-2-2
{175}
(#3474572@0)
-
Thanks. Please check detail inside
-changeit(growing);
2007-2-3
{608}
(#3475999@0)
-
init.ora
-changeit(growing);
2007-2-3
{7511}
(#3476023@0)
-
tnsnames.ora (server side)
-changeit(growing);
2007-2-3
{539}
(#3476024@0)
-
listner.ora
-changeit(growing);
2007-2-3
{513}
(#3476028@0)
-
is the oem installed on the seperate machine?I find it's too hard to interact like this, why don't we talk on phone? check your PM
-alan_wang99(东流水);
2007-2-5
{87}
(#3478337@0)
-
Instance is up now. Thanks a lot to all of you, especially to 东流水( I sent you an email, please check)
-changeit(growing);
2007-2-6
(#3480244@0)