CONFIGURE LISTENER AND TNS SERVICE
----------------------------------
LISTENER SHOULD BE CREATED IN HRMS DATABASE AND TNS SHOULD BE CREATED IN CATDB
Target Database Side(hrms)
Catalog Database Side(catdb)
$export ORACLE_SID=hrms
$sqlplus / as sysdba
sql>startup
sql>archive log list
(should be enabled)
create listener.ora file manually
[oracle@mac1 admin]$ cat listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mac1.oracle.com)(PORT = 7777))
#(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=hrms)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
:wq
$lsnrctl start LISTENER
create password file
$cd $ORACLE_HOME/dbs
$orapwd file=orapwhrms password=sys force=y
Catalog Database Side
=====================
$export ORACLE_SID=catdb
$sqlplus / as sysdba
sql>startup mount;
sql>alter database archivelog;
sql>alter database open;
Create tnsnames.ora file manually
+++++++++++++++++++++++++++++++++++++++
[oracle@lnx02 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TO_HRMS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lnx01.oracle.com/or ip address of target database)(PORT = 7777))
)
(CONNECT_DATA =
(SERVICE_NAME = hrms)
)
)
$tnsping to_hrms
No comments:
Post a Comment