ORA-00119: invalid specification for system parameter string
Cause: The syntax for the specified parameter is incorrect.
Action: Refer to the Oracle Reference Manual for the correct syntax.
Conexoes de Rede - Blog oracle error ,net work, ora code, pl sql for, security it, firebird, mysql,router and switch cisco, linux,windows server, wireless, how to, open source, performance oracle, tunning, switching, realtek, certification, ccna
oracle error - ORA-00119: invalid specification for system parameter string
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
ORA-00118: Only one of PROTOCOL, ADDRESS or DESCRIPTION may be specified
Cause: More than one of PROTOCOL, ADDRESS or DESCRIPTION was specified.
Action: Use only one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.
Cause: More than one of PROTOCOL, ADDRESS or DESCRIPTION was specified.
Action: Use only one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
ORA-00117: PROTOCOL, ADDRESS or DESCRIPTION must be specified
Cause: PROTOCOL, ADDRESS or DESCRIPTION was not specified.
Action: Use one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.
Cause: PROTOCOL, ADDRESS or DESCRIPTION was not specified.
Action: Use one of the attributes: PROTOCOL, ADDRESS or DESCRIPTION to specify the listening address for dispatchers.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00097: use of Oracle SQL feature not in SQL92 string Level
ORA-00097: use of Oracle SQL feature not in SQL92 string Level
Cause: Usage of Oracle's SQL extensions.
Action: none
Cause: Usage of Oracle's SQL extensions.
Action: none
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00096: invalid value string for parameter string, must be from among string
ORA-00096: invalid value string for parameter string, must be from among string
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00094: %s requires an integer value
ORA-00094: %s requires an integer value
Cause: The parameter value is not an integer.
Action: Modify the parameter value to be an integer.
Cause: The parameter value is not an integer.
Action: Modify the parameter value to be an integer.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00093: %s must be between string and string
ORA-00093: %s must be between string and string
Cause: The parameter value is not in a valid range.
Action: Modify the parameter value to be within the specified range.
Cause: The parameter value is not in a valid range.
Action: Modify the parameter value to be within the specified range.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
ORA-00092: LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
Cause: The value of LARGE_POOL_SIZE is less than the value of LARGE_POOL_MIN_ALLOC.
Action: Increase the value of LARGE_POOL_SIZE past the value of LARGE_POOL_MIN_ALLOC.
Cause: The value of LARGE_POOL_SIZE is less than the value of LARGE_POOL_MIN_ALLOC.
Action: Increase the value of LARGE_POOL_SIZE past the value of LARGE_POOL_MIN_ALLOC.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00091: LARGE_POOL_SIZE must be at least string
ORA-00091: LARGE_POOL_SIZE must be at least string
Cause: The value of LARGE_POOL_SIZE is below the minimum size.
Action: Increase the value of LARGE_POOL_SIZE past the minimum size.
Cause: The value of LARGE_POOL_SIZE is below the minimum size.
Action: Increase the value of LARGE_POOL_SIZE past the minimum size.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
ORA-00090: failed to allocate memory for cluster database ORADEBUG command
ORA-00090: failed to allocate memory for cluster database ORADEBUG command
Cause: Could not allocate memory needed to execute cluster database oradebug.
Action: Reissue the command on each instance with single-instance oradebug.
Cause: Could not allocate memory needed to execute cluster database oradebug.
Action: Reissue the command on each instance with single-instance oradebug.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
Download antispyware- Windows defender
O Windows Defender, é o Antispyware da Microsoft, garante proteção em tempo real e facilita a vida do usuário.
Assim que termina a instalação o programa faz a primeira varredura em busca de programas espiões, mostra uma descrição explicando o que é cada spyware ou adware encontrado e também mostra o grau de perigo que os arquivos detectados representam para o seu computador.
Possui versão para windows vista, xp e 7.
Download nesse link: http://download.microsoft.com/download/3/5/9/359b3edd-560d-4b82-9d07-54f69e267413/WindowsDefender.msi
Assim que termina a instalação o programa faz a primeira varredura em busca de programas espiões, mostra uma descrição explicando o que é cada spyware ou adware encontrado e também mostra o grau de perigo que os arquivos detectados representam para o seu computador.
Possui versão para windows vista, xp e 7.
Download nesse link: http://download.microsoft.com/download/3/5/9/359b3edd-560d-4b82-9d07-54f69e267413/WindowsDefender.msi
Marcadores:
antispy,
antispyware,
antispyware download free,
malwares,
microsoft antispyware,
remover spyware removedor de virus gratis,
windows defender download
ORA-00089: invalid instance number in ORADEBUG command
ORA-00089: invalid instance number in ORADEBUG command
Cause: An invalid instance number was specified in a cluster database ORADEBUG command.
Action: Reissue the command with valid instance numbers.
Cause: An invalid instance number was specified in a cluster database ORADEBUG command.
Action: Reissue the command with valid instance numbers.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
ORA-00088: command cannot be executed by shared server
ORA-00088: command cannot be executed by shared server
Cause: Debug command issued on shared server.
Action: Reissue the command using a dedicated server.
Cause: Debug command issued on shared server.
Action: Reissue the command using a dedicated server.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
Política de privacidade
"Este site pode utilizar cookies e/ou web beacons quando um usuário tem acesso às páginas. Os cookies que podem ser utilizados associam-se (se for o caso) unicamente com o navegador de um determinado computador.
Os cookies que são utilizados neste site podem ser instalados pelo mesmo, os quais são originados dos distintos servidores operados por este, ou a partir dos servidores de terceiros que prestam serviços e instalam cookies e/ou web beacons (por exemplo, os cookies que são empregados para prover serviços de publicidade ou certos conteúdos através dos quais o usuário visualiza a publicidade ou conteúdos em tempo pré determinados). O usuário poderá pesquisar o disco rígido de seu computador conforme instruções do próprio navegador. O Google, como fornecedor de terceiros, utiliza cookies para exibir anúncios neste site.
Com o cookie DART, o Google pode exibir anúncios para seus usuários com base nas visitas feitas a este site.
Você pode desativar o cookie DART visitando a Política de privacidade da rede de conteúdo e dos anúncios do Google.
Usuário tem a possibilidade de configurar seu navegador para ser avisado, na tela do computador, sobre a recepção dos cookies e para impedir a sua instalação no disco rígido. As informações pertinentes a esta configuração estão disponíveis em instruções e manuais do próprio navegador".
Este site respeita e procura responder todos os e-mails enviados.
Após a leitura este site apaga todos os endereços de e-mail enviados.
Este site se reserva no direito de utilizar emails cadastrado nas promoçoes para envio de newsletter do nosso site e parceiros nas promocoes, mediante aceite do usuário, reservando o direito do usuário excluir seu email do cadastro.
Os cookies que são utilizados neste site podem ser instalados pelo mesmo, os quais são originados dos distintos servidores operados por este, ou a partir dos servidores de terceiros que prestam serviços e instalam cookies e/ou web beacons (por exemplo, os cookies que são empregados para prover serviços de publicidade ou certos conteúdos através dos quais o usuário visualiza a publicidade ou conteúdos em tempo pré determinados). O usuário poderá pesquisar o disco rígido de seu computador conforme instruções do próprio navegador. O Google, como fornecedor de terceiros, utiliza cookies para exibir anúncios neste site.
Com o cookie DART, o Google pode exibir anúncios para seus usuários com base nas visitas feitas a este site.
Você pode desativar o cookie DART visitando a Política de privacidade da rede de conteúdo e dos anúncios do Google.
Usuário tem a possibilidade de configurar seu navegador para ser avisado, na tela do computador, sobre a recepção dos cookies e para impedir a sua instalação no disco rígido. As informações pertinentes a esta configuração estão disponíveis em instruções e manuais do próprio navegador".
Este site respeita e procura responder todos os e-mails enviados.
Após a leitura este site apaga todos os endereços de e-mail enviados.
Este site se reserva no direito de utilizar emails cadastrado nas promoçoes para envio de newsletter do nosso site e parceiros nas promocoes, mediante aceite do usuário, reservando o direito do usuário excluir seu email do cadastro.
oracle error - ORA-00087: command cannot be executed on remote instance
ORA-00087: command cannot be executed on remote instance
Cause: Cluster database command issued for non cluster database ORADEBUG command.
Action: Issue the command without the cluster database syntax.
Cause: Cluster database command issued for non cluster database ORADEBUG command.
Action: Issue the command without the cluster database syntax.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00086: user call does not exist
ORA-00086: user call does not exist
Cause: An invalid attempt was made to dump the user call heap.
Action: Wait until the process starts a call.
Cause: An invalid attempt was made to dump the user call heap.
Action: Wait until the process starts a call.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00085: current call does not exist
ORA-00085: current call does not exist
Cause: An invalid attempt was made to dump the current call heap.
Action: Wait until the process starts a call.
Cause: An invalid attempt was made to dump the current call heap.
Action: Wait until the process starts a call.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00084: global area must be PGA, SGA, or UGA
ORA-00084: global area must be PGA, SGA, or UGA
Cause: An attempt was made to dump an invalid global area.
Action: Specify either PGA, SGA, or UGA.
Cause: An attempt was made to dump an invalid global area.
Action: Specify either PGA, SGA, or UGA.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
Download antispyware- Spybot - Search & Destroy
O Spybot Search & Destroy é um otimo removedor de spyware utiliza várias ferramentas de análise e verificação de código para descobrir as ameaças que existem nos seus arquivos e depois eliminá-las.
Possui uma interface básica, e tem foco na funcionalidade e não no visual.
Esta disponível em portugues, é gratuito e possui a versão para os windows vista e xp.
Download neste link: http://www.spybotupdates.com/files/spybotsd162.exe
Possui uma interface básica, e tem foco na funcionalidade e não no visual.
Esta disponível em portugues, é gratuito e possui a versão para os windows vista e xp.
Download neste link: http://www.spybotupdates.com/files/spybotsd162.exe
Marcadores:
antispy,
antispyware,
antispyware download free,
malwares,
remover spyware removedor de virus gratis,
spybot download
oracle error - ORA-00083: warning: possibly corrupt SGA mapped
ORA-00083: warning: possibly corrupt SGA mapped
Cause: Even though there may be SGA corruptions, the SGA was mapped.
Action: Use the DUMPSGA command to dump the SGA.
Cause: Even though there may be SGA corruptions, the SGA was mapped.
Action: Use the DUMPSGA command to dump the SGA.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00081: address range [string, string) is not readable
ORA-00081: address range [string, string) is not readable
Cause: An attempt was made to read/write an invalid memory address range.
Action: Try another address or length.
Cause: An attempt was made to read/write an invalid memory address range.
Action: Try another address or length.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00080: invalid global area specified by level string
ORA-00080: invalid global area specified by level string
Cause: An attempt was made to dump an invalid global area.
Action: Use level 1 for the PGA, 2 for the SGA, and 3 for the UGA. Use <extra + level> to dump global area <level> as well as <extra> bytes for every pointer; <extra> must be a multiple of 4.
Cause: An attempt was made to dump an invalid global area.
Action: Use level 1 for the PGA, 2 for the SGA, and 3 for the UGA. Use <extra + level> to dump global area <level> as well as <extra> bytes for every pointer; <extra> must be a multiple of 4.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00079: variable string not found
ORA-00079: variable string not found
Cause: An attempt was made to dump a variable that does not exist.
Action: Use a valid variable name.
Cause: An attempt was made to dump a variable that does not exist.
Action: Use a valid variable name.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00076: dump string not found
ORA-00076: dump string not found
Cause: An attempt was made to invoke a dump that does not exist.
Action: Type DUMPLIST to see the list of available dumps.
Cause: An attempt was made to invoke a dump that does not exist.
Action: Type DUMPLIST to see the list of available dumps.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00078: cannot dump variables by name
ORA-00078: cannot dump variables by name
Cause: An attempt was made to dump a variable by name on a system that does not support this feature.
Action: Try the PEEK command.
Cause: An attempt was made to dump a variable by name on a system that does not support this feature.
Action: Try the PEEK command.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00075: process "string" not found in this instance
ORA-00075: process "string" not found in this instance
Cause: The specified process was not logged on to the current instance.
Action: Specify a valid process.
Cause: The specified process was not logged on to the current instance.
Action: Specify a valid process.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00074: no process has been specified
ORA-00074: no process has been specified
Cause: No debug process has been specified.
Action: Specify a valid process.
Cause: No debug process has been specified.
Action: Specify a valid process.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00073: command string takes between string and string argument(s)
ORA-00073: command string takes between string and string argument(s)
Cause: An incorrect number of arguments was specified.
Action: Specify the correct number of arguments. Type HELP to see the list of commands and their syntax.
Cause: An incorrect number of arguments was specified.
Action: Specify the correct number of arguments. Type HELP to see the list of commands and their syntax.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00072: process "string" is not active
ORA-00072: process "string" is not active
Cause: An invalid process was specified.
Action: Specify a valid process.
Cause: An invalid process was specified.
Action: Specify a valid process.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00071: process number must be between 1 and string
ORA-00071: process number must be between 1 and string
Cause: An invalid process number was specified.
Action: Specify a valid process number.
Cause: An invalid process number was specified.
Action: Specify a valid process number.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00070: command string is not valid
ORA-00070: command string is not valid
Cause: An invalid debugger command was specified.
Action: Type HELP to see the list of available commands.
Cause: An invalid debugger command was specified.
Action: Type HELP to see the list of available commands.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00069: cannot acquire lock -- table locks disabled for string
ORA-00069: cannot acquire lock -- table locks disabled for string
Cause: A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD (...), and so on.
Action: Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command.
Cause: A command was issued that tried to lock the table indicated in the message. Examples of commands that can lock tables are: LOCK TABLE, ALTER TABLE ... ADD (...), and so on.
Action: Use the ALTER TABLE ... ENABLE TABLE LOCK command, and retry the command.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00068: invalid value string for parameter string, must be between string and string
ORA-00068: invalid value string for parameter string, must be between string and string
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00067: invalid value string for parameter string; must be at least string
ORA-00067: invalid value string for parameter string; must be at least string
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Cause: The value for the initialization parameter is invalid.
Action: Choose a value as indicated by the message.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00066: LOG_FILES is string but needs to be string to be compatible
ORA-00066: LOG_FILES is string but needs to be string to be compatible
Cause: The maximum number of log files supported by this instance is not the same as for the other instances. All instances must be able to open all the files any instance can open.
Action: Change the value of the LOG_FILES initialization parameter to be compatible.
Cause: The maximum number of log files supported by this instance is not the same as for the other instances. All instances must be able to open all the files any instance can open.
Action: Change the value of the LOG_FILES initialization parameter to be compatible.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00065: initialization of FIXED_DATE failed
ORA-00065: initialization of FIXED_DATE failed
Cause: The FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss.
Action: Make sure the initialization parameter is in the correct date format.
Cause: The FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss.
Action: Make sure the initialization parameter is in the correct date format.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00064: object is too large to allocate on this O/S (string,string)
ORA-00064: object is too large to allocate on this O/S (string,string)
Cause: An initialization parameter was set to a value that required allocating more contiguous space than can be allocated on this operating system.
Action: Reduce the value of the initialization parameter.
Cause: An initialization parameter was set to a value that required allocating more contiguous space than can be allocated on this operating system.
Action: Reduce the value of the initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00063: maximum number of log files exceeded string
ORA-00063: maximum number of log files exceeded string
Cause: The number of log files specificied exceeded the maximum number of log files supported in this release.
Action: Re-create the control file with the highest number of log files no greater than the maximum supported in this release.
Cause: The number of log files specificied exceeded the maximum number of log files supported in this release.
Action: Re-create the control file with the highest number of log files no greater than the maximum supported in this release.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
Cause: The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).
Action: Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement.
Cause: The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).
Action: Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00061: another instance has a different DML_LOCKS setting
ORA-00061: another instance has a different DML_LOCKS setting
Cause: The shared instance being started is using DML locks, and the running instances are not, or vice-versa.
Action: Ensure that all instances' INIT.ORA files specify the DML_LOCKS parameter as 0 or all as non-zero.
Cause: The shared instance being started is using DML locks, and the running instances are not, or vice-versa.
Action: Ensure that all instances' INIT.ORA files specify the DML_LOCKS parameter as 0 or all as non-zero.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00060: deadlock detected while waiting for resource
ORA-00060: deadlock detected while waiting for resource
Cause: Transactions deadlocked one another while waiting for resources.
Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.
Cause: Transactions deadlocked one another while waiting for resources.
Action: Look at the trace file to see the transactions and resources involved. Retry if necessary.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00059: maximum number of DB_FILES exceeded
ORA-00059: maximum number of DB_FILES exceeded
Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and warm start.
Cause: The value of the DB_FILES initialization parameter was exceeded.
Action: Increase the value of the DB_FILES parameter and warm start.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)
ORA-00058: DB_BLOCK_SIZE must be string to mount this database (not string)
Cause: DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database.
Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value.
Cause: DB_BLOCK_SIZE initialization parameter is wrong for the database being mounted. It does not match the value used to create the database.
Action: Fix the value of the DB_BLOCK_SIZE parameter or mount a database that matches the value.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
Download anti malware- Comodo Internet Security
O Comodo Internet security é um dos melhores exemplos gratuitos do gênero. Com funções de antivírus, firewall e diversos tipos de proteção em tempo real é otima solução para proteger o seu windows, possui antivirus firewall, antispyware e outras funcionalidades.
Até o presente momento so esta disponível em inglês, mas pode ser instalado nas versões do windows vista, xp e 7.
clique aqui para o download: http://eu5.download.comodo.com/cis/download/installs/1000/standalone/cispremium_installer_x86.exe
Até o presente momento so esta disponível em inglês, mas pode ser instalado nas versões do windows vista, xp e 7.
clique aqui para o download: http://eu5.download.comodo.com/cis/download/installs/1000/standalone/cispremium_installer_x86.exe
Marcadores:
anti malware,
comodo internet security,
malware anti malware,
malwares,
removedor de virus gratis
oracle error- ORA-00055: maximum number of DML locks exceeded
ORA-00055: maximum number of DML locks exceeded
Cause: Ran out of DML lock state objects.
Action: Increase the value of the DML_LOCKS initialization parameter and warm
start.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00053: maximum number of enqueues exceeded
ORA-00053: maximum number of enqueues exceeded
Cause: Ran out of enqueue state objects.
Action: Increase the value of the ENQUEUES initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
SPFILE: Criando um arquivo de inicialização
O SPFILE é uma arquivo binário mantido pelo servidor, que possibilita alterações persistentes.
Algumas características do SPFILE:
Reside sempre do lado servdior;
Pode auto ajustar parametros;
Possibilita suporte ao recovery manager o backup dos arquivos de parametros;
Pode ser craido a partir de um arquivo PFILE.
Pode ser executado antes ou depois da inicialização da instância.
Ex: Criando um arquivo SPILE a partir de um PFILE:
create SPILE='$oracle_home/dbs/spfileoracledba01.ora' from PFILE ='$oracle_home/dbs/initoracledba01.ora';
Exemplo de arquivo SPFILE:
*.background_dump_dest='/home/brasil01/ADMIN/BDUMP'
*.compatible='9.2.0'
*.control_files='/home/brasil01/ORADATA/u01/ctrl01.ctl'
*.core_dump_dest='/home/brasil01/ADMIN/CDUMP'
*.db_block_size=4096
*.db_name='dba01'
*.db_domain='world'
*.global_names=TRUE
*.instance_name='brasil01'
*.remote_login_passwordfile='exclusive'
*.java_pool_size=50000000
*.shared_pool_size=50000000
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
Algumas características do SPFILE:
Reside sempre do lado servdior;
Pode auto ajustar parametros;
Possibilita suporte ao recovery manager o backup dos arquivos de parametros;
Pode ser craido a partir de um arquivo PFILE.
Pode ser executado antes ou depois da inicialização da instância.
Ex: Criando um arquivo SPILE a partir de um PFILE:
create SPILE='$oracle_home/dbs/spfileoracledba01.ora' from PFILE ='$oracle_home/dbs/initoracledba01.ora';
Exemplo de arquivo SPFILE:
*.background_dump_dest='/home/brasil01/ADMIN/BDUMP'
*.compatible='9.2.0'
*.control_files='/home/brasil01/ORADATA/u01/ctrl01.ctl'
*.core_dump_dest='/home/brasil01/ADMIN/CDUMP'
*.db_block_size=4096
*.db_name='dba01'
*.db_domain='world'
*.global_names=TRUE
*.instance_name='brasil01'
*.remote_login_passwordfile='exclusive'
*.java_pool_size=50000000
*.shared_pool_size=50000000
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
Marcadores:
arquivos,
banco de dados,
database,
init oracle,
oracle9i,
pfile
oracle error- ORA-00051: timeout occurred while waiting for a resource
ORA-00051: timeout occurred while waiting for a resource
Cause: Usually due to a dead instance.
Action: Check for any dead, unrecovered instances and recover them.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00050: operating system error occurred while obtaining an enqueue
ORA-00050: operating system error occurred while obtaining an enqueue
Cause: Could not obtain the operating system resources necessary to cover an oracle enqueue.
This is normally the result of an operating system user quota that is too low.
Action: Look up the operating system error in your system documentation and perform
the needed action.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00041: active time limit exceeded - session terminated
ORA-00041: active time limit exceeded - session terminated
Cause: The Resource Manager SWITCH_TIME limit was exceeded.
Action: Reduce the complexity of the update or query, or contact your database
administrator for more information.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00040: active time limit exceeded - call aborted
ORA-00040: active time limit exceeded - call aborted
Cause: The Resource Manager SWITCH_TIME limit was exceeded.
Action: Reduce the complexity of the update or query, or contact your database
administrator for more information.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00042: Unknown Service name string
ORA-00042: Unknown Service name string
Cause: An attempt was made to use an invalid application service.
Action: Use a valid service name from SERVICE$ or add a new service using the
DBMS_SERVICE package.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error - ORA-00082: memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
ORA-00082: memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
Cause: An invalid length was specified for the POKE command.
Action: Use a valid length (either 1, 2, 4, or possibly 8).
Cause: An invalid length was specified for the POKE command.
Action: Use a valid length (either 1, 2, 4, or possibly 8).
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00057: maximum number of temporary table locks exceeded
ORA-00057: maximum number of temporary table locks exceeded
Cause: The number of temporary tables equals or exceeds the number of temporary table locks.
Temporary tables are often created by large sorts.
Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter
and warm start.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode
ORA-00056: DDL lock on object 'string.string' is already held in an incompatible mode
Cause: An attempt was made to acquire a DDL lock that is already locked.
Action: This happens if you attempt to drop a table that has parse locks on it.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00054: resource busy and acquire with NOWAIT specified
Cause: Resource interested is busy.
Action: Retry if necessary.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00052: maximum number of enqueue resources (string) exceeded
ORA-00052: maximum number of enqueue resources (string) exceeded
Cause: Ran out of enqueue resources.
Action: Increase the value of the ENQUEUE_RESOURCES initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00029: session is not a user session
ORA-00029: session is not a user session
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user
session (for example, recursive, etc.).
Action: Retry with a user session ID.
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user
session (for example, recursive, etc.).
Action: Retry with a user session ID.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00038: Cannot create session: server group belongs to another user
ORA-00038: Cannot create session: server group belongs to another user
Cause: An attempt was made to create a non-migratable session in a server group that
is owned by a different user.
Action: A server group is owned by the first user who logs into a server in the server
group in non-migratable mode. All subsequent non-migratable mode logins must be made by the
user who owns the server group. To have a different user login in non-migratable mode,
the ownership of the server group will have to be changed. This can be done by logging off all
current sessions and detaching from all existing servers in the server group and then
having the new user login to become the new owner.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
ORA-00037: cannot switch to a session belonging to a different server group
ORA-00037: cannot switch to a session belonging to a different server group
Cause: An attempt was made to switch to a session in a different server group. This is
not allowed.
Action: Make sure the server switches to a session that belongs to its server group.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00036: maximum number of recursive SQL levels (string) exceeded
ORA-00036: maximum number of recursive SQL levels (string) exceeded
Cause: An attempt was made to go more than the specified number of recursive SQL levels.
Action: Remove the recursive SQL, possibly a recursive trigger.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00034: Cannot string in current PL/SQL session
ORA-00034: Cannot string in current PL/SQL session
Cause: An attempt was made to issue a commit or rollback from a PL/SQL object (procedure,
function, package) in a session that has this disabled (by 'alter session disable commit in
procedure')
Action: Enable commits from PL/SQL in this session, or do not attempt to use commit or
rollback in PL/SQL when they are disabled in the current session.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00033: current session has empty migration password
ORA-00033: current session has empty migration password
Cause: An attempt was made to detach or clone the current session and it has an empty
migration password. This is not allowed.
Action: Create the session with a non-empty migration password.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00032: invalid session migration password
ORA-00032: invalid session migration password
Cause: The session migration password specified in a session creation call was invalid (probably too long).
Action: Retry with a valid password (less than 30 chars).
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00031: session marked for kill
ORA-00031: session marked for kill
Cause: The session specified in an ALTER SYSTEM KILL SESSION command cannot be killed
immediately (because it is rolling back or blocked on a network operation), but it has been marked for kill. This means it will be killed as soon as possible after its current uninterruptable operation is done.
Action: No action is required for the session to be killed, but further executions of the ALTER SYSTEM KILL SESSION command on this session may cause the session to be killed sooner.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00030: User session ID does not exist.
ORA-00030: User session ID does not exist.
Cause: The user session ID no longer exists, probably because the session was logged out.
Action: Use a valid session ID.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00029: session is not a user session
ORA-00029: session is not a user session
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user
session (for example, recursive, etc.).
Action: Retry with a user session ID.
Cause: The session ID specified in an ALTER SYSTEM KILL SESSION command was not a user
session (for example, recursive, etc.).
Action: Retry with a user session ID.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00028: your session has been killed
ORA-00028: your session has been killed
Cause: A privileged user has killed your session and you are no longer logged on to the
database.
Action: Login again if you wish to continue working.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00027: cannot kill current session
ORA-00027: cannot kill current session
Cause: Attempted to use ALTER SYSTEM KILL SESSION to kill the current session.
Action: None.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00026: missing or invalid session ID
ORA-00026: missing or invalid session ID
Cause: Missing or invalid session ID string for ALTER SYSTEM KILL SESSION.
Action: Retry with a valid session ID.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00025: failed to allocate string
ORA-00025: failed to allocate string
Cause: Out of memory.
Action: Restart with larger sga heap.
Cause: Out of memory.
Action: Restart with larger sga heap.
Marcadores:
banco de dados,
database,
error oracle,
oracle error
oracle error- ORA-00024: logins from more than one process not allowed in single-process mode
ORA-00024: logins from more than one process not allowed in single-process mode
Cause: Trying to login more than once from different processes for ORACLE started in
single-process mode.
Action: Logoff from the other process.
Cause: Trying to login more than once from different processes for ORACLE started in
single-process mode.
Action: Logoff from the other process.
Marcadores:
banco de dados,
database,
error oracle,
oracle
oracle error- ORA-00023: session references process private memory; cannot detach session
ORA-00023: session references process private memory; cannot detach session
Cause: An attempt was made to detach the current session when it contains references to
process private memory.
Action: A session may contain references to process memory (PGA) if it has an
open network connection, a very large context area, or operating system privileges. To allow
the detach, it may be necessary to close the session's database links and/or cursors.
Detaching a session with operating system privileges is always disallowed.
process private memory.
Action: A session may contain references to process memory (PGA) if it has an
open network connection, a very large context area, or operating system privileges. To allow
the detach, it may be necessary to close the session's database links and/or cursors.
Detaching a session with operating system privileges is always disallowed.
Marcadores:
banco de dados,
database,
error oracle,
oracle
ORA-00022: invalid session ID; access denied
ORA-00022: invalid session ID; access denied
Cause: Either the session specified does not exist or the caller does not have the privilege
to access it.
Action: Specify a valid session ID that you have privilege to access, that is either
you own it or you have the CHANGE_USER privilege.
Cause: Either the session specified does not exist or the caller does not have the privilege
to access it.
Action: Specify a valid session ID that you have privilege to access, that is either
you own it or you have the CHANGE_USER privilege.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Show routing table cisco
MyRouter>en
MyRouter#show ip route
Codes: C - connected, S - static, I - IGRP, R - RIP, M - mobile, B - BGP
D - EIGRP, EX - EIGRP external, O - OSPF, IA - OSPF inter area
N1 - OSPF NSSA external type 1, N2 - OSPF NSSA external type 2
E1 - OSPF external type 1, E2 - OSPF external type 2, E - EGP
i - IS-IS, L1 - IS-IS level-1, L2 - IS-IS level-2, ia - IS-IS inter area
* - candidate default, U - per-user static route, o - ODR
P - periodic downloaded static route
Gateway of last resort is not set
172.16.0.0/24 is subnetted, 2 subnets
C 172.16.10.0 is directly connected, FastEthernet0/0
S 172.16.20.0 [1/0] via 192.168.2.2
192.168.2.0/30 is subnetted, 1 subnets
C 192.168.2.0 is directly connected, Serial0/1/0
MyRouter#show ip route
Codes: C - connected, S - static, I - IGRP, R - RIP, M - mobile, B - BGP
D - EIGRP, EX - EIGRP external, O - OSPF, IA - OSPF inter area
N1 - OSPF NSSA external type 1, N2 - OSPF NSSA external type 2
E1 - OSPF external type 1, E2 - OSPF external type 2, E - EGP
i - IS-IS, L1 - IS-IS level-1, L2 - IS-IS level-2, ia - IS-IS inter area
* - candidate default, U - per-user static route, o - ODR
P - periodic downloaded static route
Gateway of last resort is not set
172.16.0.0/24 is subnetted, 2 subnets
C 172.16.10.0 is directly connected, FastEthernet0/0
S 172.16.20.0 [1/0] via 192.168.2.2
192.168.2.0/30 is subnetted, 1 subnets
C 192.168.2.0 is directly connected, Serial0/1/0
Marcadores:
cisco,
como configurar um roteador,
ip route cisco,
show routing table,
tabela de roteamento
Download anti malware- Malwarebytes
O Malwarebytes é um Anti-Malware que ajuda você a manter sua máquina livre de ameaças e serve como complemento ao seu antivirus.
Assim como qualquer outro anti-malware remove pragas que os antivirus nao encontram mas não dispensa o uso do antivirus por nao fazer uma proteção direta.
Totalmente em portugues e de tamanho pequeno.
Gratuito e pode ser baixado nesse link: http://data-cdn.mbamupdates.com/v0/program/data/mbam-setup-1.50.1.1100.exe
Marcadores:
anti malware,
antimalware,
malware anti malware,
malwarebytes,
malwares,
removedor de virus gratis
Mostrar tabela de roteamento em router da cisco
Mostrar a tabela de roteamento em um router cisco é muito simples basta digitar o comando show ip route ou sh ip route no modo privilegiado como no exemplo abaixo:
MyRouter>en
MyRouter#show ip route
Codes: C - connected, S - static, I - IGRP, R - RIP, M - mobile, B - BGP
D - EIGRP, EX - EIGRP external, O - OSPF, IA - OSPF inter area
N1 - OSPF NSSA external type 1, N2 - OSPF NSSA external type 2
E1 - OSPF external type 1, E2 - OSPF external type 2, E - EGP
i - IS-IS, L1 - IS-IS level-1, L2 - IS-IS level-2, ia - IS-IS inter area
* - candidate default, U - per-user static route, o - ODR
P - periodic downloaded static route
Gateway of last resort is not set
172.16.0.0/24 is subnetted, 2 subnets
C 172.16.10.0 is directly connected, FastEthernet0/0
S 172.16.20.0 [1/0] via 192.168.2.2
192.168.2.0/30 is subnetted, 1 subnets
C 192.168.2.0 is directly connected, Serial0/1/0
MyRouter>en
MyRouter#show ip route
Codes: C - connected, S - static, I - IGRP, R - RIP, M - mobile, B - BGP
D - EIGRP, EX - EIGRP external, O - OSPF, IA - OSPF inter area
N1 - OSPF NSSA external type 1, N2 - OSPF NSSA external type 2
E1 - OSPF external type 1, E2 - OSPF external type 2, E - EGP
i - IS-IS, L1 - IS-IS level-1, L2 - IS-IS level-2, ia - IS-IS inter area
* - candidate default, U - per-user static route, o - ODR
P - periodic downloaded static route
Gateway of last resort is not set
172.16.0.0/24 is subnetted, 2 subnets
C 172.16.10.0 is directly connected, FastEthernet0/0
S 172.16.20.0 [1/0] via 192.168.2.2
192.168.2.0/30 is subnetted, 1 subnets
C 192.168.2.0 is directly connected, Serial0/1/0
Marcadores:
cisco,
como configurar um roteador,
ip route cisco,
show routing table,
tabela de roteamento
Error oracle- ORA-00021: session attached to some other process; cannot switch session
ORA-00021: session attached to some other process; cannot switch session
Cause: The user session is currently used by others.
Action: Do not switch to a session attached to some other process.
Cause: The user session is currently used by others.
Action: Do not switch to a session attached to some other process.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00020: maximum number of processes (string) exceeded
ORA-00020: maximum number of processes (string) exceeded
Cause: All process state objects are in use.
Action: Increase the value of the PROCESSES initialization parameter.
Cause: All process state objects are in use.
Action: Increase the value of the PROCESSES initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00019: maximum number of session licenses exceeded
ORA-00019: maximum number of session licenses exceeded
Cause: All licenses are in use.
Action: Increase the value of the LICENSE MAX SESSIONS initialization parameter.
Cause: All licenses are in use.
Action: Increase the value of the LICENSE MAX SESSIONS initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- 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.
Cause: All session state objects are in use.
Action: Increase the value of the SESSIONS initialization parameter.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00017: session requested to set trace event
ORA-00017: session requested to set trace event
Cause: The current session was requested to set a trace event by another session.
Action: This is used internally; no action is required.
Cause: The current session was requested to set a trace event by another session.
Action: This is used internally; no action is required.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00001: unique constraint (string.string) violated
ORA-00001: unique constraint (string.string) violated
Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
Action: Either remove the unique restriction or do not insert the key.
Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level.
Action: Either remove the unique restriction or do not insert the key.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00000- normal, successful completion
ORA-00000: normal, successful completion
Cause: Normal exit.
Action: None.
Cause: Normal exit.
Action: None.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00904: string: invalid identifier
Cause: The column name entered is either missing or invalid.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-06512: at stringline string
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-12154:TNS:could not resolve the connect identifier specified
Cause: | A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming method repository, or the repository could not be located or reached. |
Action: | - If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable. - If you are using directory naming: - Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Verify that the LDAP directory server is up and that it is accessible. - Verify that the net service name or database name used as the connect identifier is configured in the directory. - Verify that the default context being used is correct by specifying a fully qualified net service name or a full LDAP DN as the connect identifier - If you are using easy connect naming: - Verify that "EZCONNECT" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Make sure the host, port and service name specified are correct. - Try enclosing the connect identifier in quote marks. See the Oracle Net Services Administrators Guide or the Oracle operating system specific guide for more information on naming. |
Marcadores:
banco de dados,
database,
error oracle,
oracle
Error oracle- ORA-00056
ORA-00056: | DDL lock on object 'string.string' is already held in an incompatible mode |
Cause: | An attempt was made to acquire a DDL lock that is already locked. |
Action: | This happens if you attempt to drop a table that has parse locks on it. |
Marcadores:
banco de dados,
database,
error oracle,
oracle
Subscribe to:
Posts (Atom)