Oracle Database Discussions

Can you post the error details?

Its static parameter, you have to bounce if this value you want to be in effect.

can u kindly let me know where to change, i have issued alter command to change but it showing it cant able to change and ora error

"ORA-02095 ",

my database version is 8.0.4

regards
hamid

Hamid, I do not have a version 8 Reference manual but the 9.2 manual states you can set this parameter up to 255, but I would question why any one session needs 100 open database links at one time. This is a per session parameter so what are you doing that needs one session to have so many open links? Couldn't you just close links after you are done with them before referencing another distributed system?
- -
The parameter OPEN_LINKS_PER_INSTANCE may be of interest if you have a database wide issue, though again I am looking at a newer Reference manual that your version so check your version's (Oracle version# Reference) manual.
- -
HTH -- Mark D Powell --

Are you using PFILE or SPFILE?
If you are using PFILE, then edit the changes in PFILE and bounce it.

If you are using SPFILE then, alter system set open_links=100 scope=spfile, and then bounce.

Check this document for 8.0 OPEN_LINKS parameter
http://docs.oracle.com/cd/A58617_01/server.804/a58242/ch1.htm#1481

Dear CKPT,

Yes i have done the same,. in my oracle 8.0.4 database i have try to create pfile from spfile , but while issuing this command the sql error says create command is unknown. then from where i have to create this pfile,, but i found ebnameinit.ora file,, in that i need to add this open_links=100 as u said, then i have to save this init file. then i have to bounce the database right, ok kindly tell me how to bounce because i am not able to shutdown command in sql prompt,,

or can i stop the service and start it again. !!!


my os is Windows NT 4.0,, its no more in this world,, i dont know what is happening inside this 8.0.4 in this NT.. kindly help me to troubleshoot this,,

Dear MArk,

from an application there are so many columns are continue sly connected to this instance for a single transaction, by this dummy database it will direct to the correct database via db links. this is the process of my 8.0.4 database..

Regards
Hamid

Have you edited that value & started instance with the right PFILE?
What is the error? post here. Even if you restart service still it will perform shutdown as per service configuration.

When i try to shutdown this is the error msg am getting in 8.0.4 database.
there is no sys user used in this db, system have all the privileges in this, another user is "internal"

Regards
Hamid

For V8.0.4 sqlplus can not be used to start or shutdown the DB.
You must use
svrmgrl
connect internal
startup | shutdown

This the result i am getting while log into SVRMGRL
Regards
Hamid

I can't fix or resolve your deficient environment & system

http://www.orafaq.com/wiki/Svrmgrl

Yes i can able to log in

in 8.0.4 i have to connect with "SVRMGR30"

then i connect with user internal

SVRMGR>connect internal@sid
password:password
connected.

SVRMGR>shutdown


i have given shutdown, but its taking much time,, can u tell me is it take long time for shutdown ?!?! or any other options like shutdown immediate ?

Regards
Hamid

SVRMGR>shutdown abort

And given that it is 8.0.4 I'd leave it there and walk away. ;-)

Surely there must be a job somewhere with a version of the product supported during the current century.

Thank you gentle man,

i have done shutdown immediate,

my task is to add few parameters in init.ora file. i believe the same way we have to start the database using parameter file we using for current database is init..
Is this above statement is correct ?

and kindly let me know how to find the spfile location i have issued "SHOW PARAMETER SPFILE" but the db replies as unknown parameter.. even i am not able to create pfile from spfile?? i hope in 8.0.4 there may be some different way i have to follow.

Kindly suggest me..

Regards
Hamid

There is no such thing as an spfile with version 8. The spfile should have never been mentioned since you posted the version is 8.0.4, but it is unfortunately easy to overlook or forget posted information as you read through a thread.

HTH -- Mark D Powell --

Hamid, as a general rule you should backup then edit the init.ora file prior to shutting down the database to make a change that requires bouncing the database. Once you correctly issue a shutdown command to Oracle then Oracle will not accept any additional shutdown or shutdown immediate commands except for shutdown abort.

HTH -- Mark D Powell --