Friday, 13 September 2013
ORA-00018 maximum number of sessions exceeded
ORA-00018 maximum number of sessions exceeded
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.Reference: Oracle Documentation
ORA-00018 comes under "Oracle Database Server Messages". These messages are generated
by the Oracle database server when running any Oracle program.
How to increase SESSION initialization parameter:
1. Login as sysdba
sqlplus / as sysdba
2. Check Current Setting of Parameters
sql> show parameter sessions
sql> show parameter processes
sql> show parameter transactions
3. If you are planning to increase "sessions" parameter you should also plan to increase
"processes and "transactions" parameters.
A basic formula for determining these parameter values is as follows:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1
4. These paramters can't be modified in memory. You have to modify the spfile only
(scope=spfile) and bounce the instance.
sql> alter system set processes=500 scope=spfile;
sql> alter system set sessions=555 scope=spfile;
sql> alter system set transactions=610 scope=spfile;
sql> shutdown abort
sql> startup Related Links:
ORA-00054: resource busy and acquire with NOWAIT specified
http://nimishgarg.blogspot.in/2012/05/ora-00054-resource-busy-and-acquire.html
ORA-00020 maximum number of processes exceeded
http://nimishgarg.blogspot.in/2012/05/ora-00020-maximum-number-of-processes.html
Original Article
Monday, 22 July 2013
OPC text missing the position
There is an interet thing happy since last week.
the "..." control the directiong of the OPC. after I changed it to left. the text missing position.
Put a new one, same thing happed.
Put a new one, same thing happed.
Friday, 15 March 2013
Site Server Permition_SPPID Installation
I finished Whole process of SPPID installation. and it works well. but after I shared my remote computer with my co-workers, I found they can not open the drawings.
After asked the master, I know there is one more step need to do: right click your Site Server. then click the permissions. add your co-worker's name on it. then refresh the role in Engineering Manager. It work!
The logic is clear: your co-worker need permission to access the reference files. Otherwise, they only can connect with server but doing nothing.
After asked the master, I know there is one more step need to do: right click your Site Server. then click the permissions. add your co-worker's name on it. then refresh the role in Engineering Manager. It work!
The logic is clear: your co-worker need permission to access the reference files. Otherwise, they only can connect with server but doing nothing.
Friday, 22 February 2013
How to get remote VM's shared files
There're several method:
1. Access to the VM directly.
Type \\ the name of VM\ driver$. you can directly get into the shared folder. of course, you need to know this computer's user name and password.
2. Map the shared folder to your computer, similiar as above. more convinient for next time.
3. From the VM go to the server, for example: \\ca-cab...., you suppose have your personal folder there. then put the VM file there. After that you can get your files from your personal folder.
1. Access to the VM directly.
Type \\ the name of VM\ driver$. you can directly get into the shared folder. of course, you need to know this computer's user name and password.
2. Map the shared folder to your computer, similiar as above. more convinient for next time.
3. From the VM go to the server, for example: \\ca-cab...., you suppose have your personal folder there. then put the VM file there. After that you can get your files from your personal folder.
How to add your co-worker to your VM
Two point:
1. Add their user name to your VM.
(a) my computer--Manage
2. Add their user name to remote
(a) Contro Panel--System--Remote
1. Add their user name to your VM.
(a) my computer--Manage
(b) groups--users--property
(c) add
(d) check the dormin name first, then enter your co-workers user name.
2. Add their user name to remote
(a) Contro Panel--System--Remote
(b) click select remote users
(c) check domin first, then add user name, then check names
Now, you can tell your co-workers to try.
Friday, 11 January 2013
XenApp more
XenApp, Virtually Everywhere
This post is apart from Smartplant Automation. But is an imortant application used for virtualization of desktop applications. Here I'll discuss about CITRIX XenApp.
Citrix XenApp is an application delivery solution for application managed in the datacenter virtualized and centralised and delivers the service to the user anywhere and on any device.
Now if the upgrades require in upgrade of OS (MS Window), or (very rare case) Hardware of systems running the application tool, and we have around 50-100 computers to be upgraded, then it will definitely be a friction for project time as well as cost.
Citrix here plays a very good role to limit the cost and time. If the Application (here Smartplant Tool) is running on CITRIX XenApp, you'll just need to upgrade one server. That's it. You can fire the applications just in single upgrade.
And the tool amdinistrators will support such environment. On local installed application, if any thing needs to be changed (suppose new ItemTag.dll in case of SPPID), it will be applied on each system. But for CITRTX server, change it for one machine and it will be available on every machine.
Hope that is enough for you to understand the key benifit of virtualized, centralized application management system.
Have a Happy Life...
Citrix XenApp is an application delivery solution for application managed in the datacenter virtualized and centralised and delivers the service to the user anywhere and on any device.
Let us view the benefits of Citrix XenApp with smartplant tools. We all know that any EPC project has a minimum life of 3 years upto plant is built (please ignore my lack of knowledge if it is done in shorter duration). In this duration Intergraph release many upgrades for their tool (Including service packs or version). The clients demands that every thing should be done on updated versions of Smartplant tools. |
Citrix here plays a very good role to limit the cost and time. If the Application (here Smartplant Tool) is running on CITRIX XenApp, you'll just need to upgrade one server. That's it. You can fire the applications just in single upgrade.
And the tool amdinistrators will support such environment. On local installed application, if any thing needs to be changed (suppose new ItemTag.dll in case of SPPID), it will be applied on each system. But for CITRTX server, change it for one machine and it will be available on every machine.
Hope that is enough for you to understand the key benifit of virtualized, centralized application management system.
Have a Happy Life...
Wednesday, 9 January 2013
Subscribe to:
Posts (Atom)