Oracle RAC also have the HA (High Availiablity) and LB (LoadBalance). Which is the basis of its high-availability Failover (failover). It refers to any one cluster node failure will not affect the user, connect to the failure node Users will be autom ...
Connected to a tnsnames.ora file configuration When the sqlnet.ora exists NAMES.DIRECTORY_PATH = (TNSNAMES), that is the client connection string in parsing tnsnames only when using the file, provided to the host name or ip tnsname address resolution ...
Connected to a tnsnames.ora file configuration When the sqlnet.ora exists NAMES.DIRECTORY_PATH = (TNSNAMES), that is the client connection string in parsing tnsnames only when using the file, provided to the host name or ip tnsname address resolution ...
oracle logon experience "can not resolve connectivity descriptor specified sid" Time Solutions 1, see whether the instance of the service SID] [start OracleService 2, view the client configuration file network / admin / tnsnames.ora is conf ...
Start the instance to nomout state, rman should be able to connect, but when I connect it error: ORA-12528: TNS: listener: all applicable routines can not create a new connection. For the following reasons: ORA-12528: listen to the service using a dy ...
Using Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0401gupta/ If you are a interested in developing their own skills in the database DB2 ® 9 expert, you probably already h
Using Oracle 10g skills to learn DB2 9.1 for Linux, UNIX and Windows http://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0401gupta/ If you are a interested in developing their own skills in the database DB2 ® 9 expert, you probably already h
This article described as a RAC environment, create a STANDBY database. Due to space constraints and met a lot of bug, the article can only be split into multiple articles. This chapter describes STANDBY database preparation and creation process. STA ...
To connect to the RAC database often occur when the ORA-12545 error, in the METALINK query on a moment, is Oracle a small bug. In the remote client to connect RAC database, connect through a unified service names often appear ORA-12545 error. SQL> ...
To connect to the RAC database often occur when the ORA-12545 error, in the METALINK query on a moment, is Oracle a small bug. RAC connectivity problem ORA-12545: http://yangtingkun.itpub.net/post/468/273645 On a document has been given a solution of ...
10. Testing Transparent Failover (TAF) The Oracle TAF failover mechanism so that any failure to re-connect to the database connection to the other nodes in the cluster. Failover is transparent to the user. In the instance of Oracle failover to re-exe ...
oracle server installed the version 10.1, IP address 129.1.9.90 The backup machine to install oracle10.1, with IP address 129.1.9.91, turn off the firewall. And modify the tnsnames.ora file, add the following: JMYBJS = (DESCRIPTION = (ADDRESS = (PROT ...
A modified tnsnames.ora file on the local server to establish remote service connection $ ORACLE_HOME / network / admin / tnsnames.ora REPDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 168.168.211.122) (PORT = 1521)) (CONNECT_DATA = (SERVER ...
When I use the lsnrctl status query db port status, it was found that: [Oracle @ test admin] $ lsnrctl status testdb LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 01:27:27 Copyright (c) 1991, 2005, Oracle. All rights reserved. Con ...
The following documents from the Oracle. Routine surveillance of the use of diagnostic files: • There are the following: - AlertSID.log document - the background trace file - the user trace file Monitor the use of diagnostic files document routine di ...
STANDBY is also a RAC database environment, however, and the main database used VOLUMN CLUSTER MANAGER different, STANDBY database using ASM. Set in the source database initialization FORCE_LOGGING and the corresponding parameters: SQL> SELECT DBID, NA
Today: colleagues reported that can not connect Oracle, an error message is: ORA-00257 archiver error. Connect internal only, until freed Oracle documentation perspective, because the log file filled the disk, log on to the server, a look, really ful ...
rn TNSNAMES.ORA configuration file to use TCP to support a remote connection to the directory database. The client can use the oracle Net Configuration Assistant or the oracle Net Manager to configure their graphical configuration tool, you can use a ...
