Upgrade and migration Flashcards
(169 cards)
Which file does the Database Upgrade Assistant (DBUA) obtain its list of databases from?
tnsnames.ora
glogin.sql
host_name.olr
sqlnet.ora
host_name.olr
tnsnames.ora
-tnsnames.ora is a configuration file in Oracle that contains network service names and their corresponding connection details.
-It is used by the Oracle client software to connect to an Oracle database.
-The file holds information such as the location of the database (hostname and port number), and the service name of the database.
-The tnsnames.ora file is typically located in the Oracle client software’s network/admin directory.
-It plays important role in connecting Oracle client software to the database.
what is glogin.sql
- glogin.sql is a file in Oracle that contains SQL commands that are executed whenever a user logs into the database.
-It allows to set up user-specific environment settings such as default date format, default number format, and default editor.
-It can also be used to define commonly used PL/SQL procedures, functions and variables.
-It is executed after login.sql and before login.sql
-It allows to customize the SQL*Plus environment for individual users
What is glogin.sql located
The file is located in the Oracle client software’s home directory, typically $ORACLE_HOME/sqlplus/admi
What is host_name.olr
host_name.olr is a file in Oracle that contains information about the performance of the Oracle database on a specific host
How is the host_name.orl created
The file is generated by Oracle’s Automatic Workload Repository (AWR) feature, which periodically collects and stores performance statistics in the database’s Automatic Workload Repository (AWR) tables.
What does the host_name.orl contani
It contains information such as statistics on database activity, resource usage, and performance metrics like wait events and SQL execution statistics
Where is the host_name.orl stored by defult
The file is stored in the $ORACLE_HOME/rdbms/log directory by default, but the location can be configured to be stored in a different location.
What is the host_name.orld used for
The file is used to diagnose performance issues and to identify the cause of performance problems
-It helps to troubleshoot performance issues and improve overall performance of the database.
How do you view the content of the host_name.orld
The content of the file can be viewed using the awrrpt.sql script which is located in $ORACLE_HOME/rdbms/admin.
Q: What is the sqlnet.ora file in Oracle?
A: The sqlnet.ora file is a configuration file in Oracle that contains settings for the SQL*Net networking protocol.
Q: What kind of information is contained in the sqlnet.ora file?
A: The sqlnet.ora file contains settings such as the location of the listener, the location of the directory service, and the protocols and services to be used for communication
Q: Where is the sqlnet.ora file typically located?
A: The sqlnet.ora file is typically located in the Oracle client software’s network/admin directory.
Q: What is the purpose of the sqlnet.ora file?
A: The purpose of the sqlnet.ora file is to configure the network communication parameters for the Oracle database, including the listener, the directory service, and the protocols and services used for communication.
Q: How does the sqlnet.ora file help in the communication between the client and the server?
A: The sqlnet.ora file contains the information that the client uses to communicate with the server, such as the location of the listener, the location of the directory service, and the protocols and services to be used for communication. These settings help the client and server to communicate with each other and establish a connection.
Which action updates a database from an earlier version to a newer version while the database remains online?
Using Oracle Golden Gate
Q: What is Oracle GoldenGate?
A: Oracle GoldenGate is a software product from Oracle that provides real-time data replication, data integration, and data migration capabilities.
Q: How does GoldenGate work?
A: GoldenGate captures changes made to a database and replicates them to another database, in real-time, using a set of pre-built or custom extract, transfer, and load (ETL) processes.
Q: What kind of use cases is Oracle GoldenGate typically used for?
A: GoldenGate can be used for a variety of use cases such as real-time data replication between databases, data integration, and data migration.
Q: How does GoldenGate differ from other data replication solutions?
A: GoldenGate is a real-time data replication solution that can replicate data at the transaction level, whereas other solutions may only replicate data at certain intervals, such as every hour or every day. Additionally, GoldenGate can replicate data across different platforms and different database versions, and can handle complex data structures and high-volume data.
Q: How does GoldenGate help in disaster recovery and high availability?
A: GoldenGate’s real-time data replication capabilities allow for the creation of a real-time disaster recovery solution. By replicating data to a secondary site, the secondary site can be used as a failover in the event of a disaster at the primary site. This allows for minimal data loss and minimal downtime.
Q: What is Oracle Universal Installer (OUI)?
A: Oracle Universal Installer (OUI) is a graphical user interface (GUI) based tool that is used to install Oracle software, such as the Oracle database, on a server.
Q: How does OUI work?
A: OUI guides the user through the installation process by providing prompts for information such as the location of the software, the type of installation, and the configuration options. Once the installation is complete, OUI creates a log file that contains information about the installation.
Q: What are the main features of OUI?
A: OUI provides a user-friendly interface that simplifies the installation process. It also provides the ability to install multiple products and options at the same time, and the ability to install and configure the software in silent mode. Additionally, it allows for easy management of multiple Oracle homes, and provide a rollback feature if something goes wrong during the installation process.