Grudzień « 2015 « Różności …

Różności …

11 grudnia 2015

oracle em agent unreachable

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 18:20

– To implement the solution, please execute the following steps::
1. Stop the agent
2. Remove all the files from AGENT_HOME/sysman/log/ directory.
3. Backup and edit AGENT_HOME/sysman/config/emd.properties.
4. Add this line:
NMUPM_TIMEOUT=120
5. Uncomment: ThreadPoolModel = LARGE
6. start the agent
7. Monitor the performance of the server

https://community.oracle.com/message/2558818#2558818

10 grudnia 2015

report schema

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 21:25

http://www.dba-oracle.com/t_rman_46_schema_report.htm

9 grudnia 2015

srvctl

Zaszufladkowany do: Oracle — Tagi: — Jacek @ 21:59

https://oracleexamples.wordpress.com/2010/01/22/most-used-srvctl-commands/

What is srvctl? it is the Server Control Utility, we use SRVCTL to start and stop the database and instances, manage configuration information, and to add, move or remove instances and services.

These are some of the srvctl commands I frequently use, this is not a complete reference guide.

I organized the commands as follow:

  • To start a rac database
  • To stop a rac database
  • To check status and configurations
  • To start and stop instances
  • To start, stop and manage services

Start a rac database (order: nodeapps – asm – database)

srvctl start nodeapps -n nodename
srvctl start asm -n nodename
srvctl start database -d dbname
options are: srvctl start database -d dbname -o open | -o mount | -o nomount

Stop a rac database (order: database – asm – nodeapps)
srvctl stop database -d dbname -o immediate
options are: srvctl stop database -d dbname -o normal | -o transactional | -o immediate | -o abort

srvctl stop asm -n nodename
options are: srvctl stop asm -n nodename -o immediate

srvctl stop nodeapps -n nodename

To check status and configurations
Nodeapps:
srvctl status nodeapps -n nodename

srvctl config nodeapps -n nodename

ASM:
srvctl status asm -n nodename
srvctl config asm -n nodename

Database:
srvctl status database -d dbname
srvctl config database -d dbname (shows instances name, node and oracle home)

Instance:
srvctl status instance -d dbname -i instancename

Services:
srvctl status service -d dbname

To start and stop instances

srvctl start instance -d dbname -i instancename
srvctl stop instance -d dbname -i instancename

To start, stop and manage services
srvctl status service -d dbname
srvctl config service -d dbname
srvctl start service -d dbname -s servicename
srvctl stop service -d dbname -s servicename

srvctl relocate service -d dbname -s servicename -i instancename -t newinstancename [-f]

Solution: Oracle VM Server Reboots

Zaszufladkowany do: Informatyka - pozostałe — Tagi: — Jacek @ 10:59

http://mokumsolutions.com/solution-oracle-vm-server-reboots

Strona startowa: www.jaceksen.pl