Database Network Configuration

Global database name:
< database name >.< domain Name >
Eg:sales.oracleserver.com

Connection Descriptor: (CONNECTION Descriptor)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = oracleserver) (PORT = 1521))
(Connect_data =
(SERVER = sales.oracleserver.com)
(INSTANCE_NAME=SALES1)
(server=dedicated) | (server=shared)
)
)

To access the database server:
Use the full connection descriptor as the connection identifier:
CONNECT Scott/[email protected] (description= (address= (protocol=tcp) (Host=oracleserver) (port=1521)) (connect_data= (Server_name=sales. oracleserver.com)))

You can also identify the database server to access through the network server name (the network service name, SALES, configured in NETCA)
CONNECT Scott/[email protected]

Simple Connect Command:
CONNECT username/[email protected][:P Ort][/service_name]

Location where the network configuration file is saved:
$ORACLE _home/network/admin
/u01/app/oracle/product/11.2.2/db_1/network/admin

Opening and stopping of listeners:
Lsnrctl start|stop < listener name >
Lsnrctl Start LISTENER

To view the status of the listener:
Lsnrctl Status < listener name >
Lsnrctl> Service;

After the server name has been modified, to modify the host name of the listener, the listener will work correctly:
VIM Listener.ora
(ADDRESS = (PROTOCOL = TCP) (HOST = oracleserver) (PORT = 1521))
VIM Tnsnames.ora
(ADDRESS = (PROTOCOL = TCP) (HOST = oracleserver) (PORT = 1521))


The EM repository is re-created:
1. Delete the EM repository:
Emca-deconfig Dbcontrol Db-repos Drop
2. Delete a junk data:
DROP public synonym Setemviewusercontext;
Drop public synonym mgmt_target_blackouts;
Drop role Mgmt_user;
Drop User Mgmt_view Cascade
Drop User Sysman Cascade
3. Re-create the EM repository
Emca-config Dbcontrol Db-repos Create


To create a database chain:
The database link is an object in the local database that represents the connection to the remote database. The remote database can be either Oracle or other databases such as Db2,sql SERVER sysbase, which may be used to reference database objects on the remote database after it is created
CREATE [public] Database link < DB link name >
CONNECT to
[current_user]| [< User name >identified by < password;]
USING < Connection strings >


For example:
CREATE public DATABASE like SALESDB
CONNECT to Current_User
USING
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = oracleserver) (PORT = 1521))
(Connect_data =
(SERVER = sales.oracleserver.com)
(INSTANCE_NAME=SALES1)
(server=dedicated) | (server=shared)
)
)

Use: SELECT * from [email protected];

To delete a database chain:
DROP [public] Database link < DB link name >
DROP public DATABASE LINK SALESDB;

Database Network Configuration