Set oracle_home environment variable: Export oracle_home=/oracle/product/11202
Set PATH environment variable: Export path= $ORACLE _home/bin: $PATH
Switch to Lsnrctl directory: Cd/oracle/product/11202/bin
1. Launch Oracle under Linux
Su-oracle
Lsnrctl start
Sqlplus/nolog
Conn Sys/oracle@gps as Sysdba
Startup
Exit
Exit
2. Shut down Oracle under Linux
Su-oracle
Sqlplus/nolog
Conn Sys/oracle@gps as Sysdba
Shutdown immediate
Exit
./lsnrctl Stop
Exit
3, start the Listener
Oracle@suse92:~>./lsnrctl start
4, Stop the Listener
Oracle@suse92:~>./lsnrctl stop
5. View Listener Status
Oracle@suse92:~>./lsnrctl
lsnrctl> status
Lsnrctl> exit
Two problems were encountered during startup and shutdown:
Issue 1: Prompt for "The listener supports no services" when starting listening
The original Listener.ora is as follows:
LISTENER =
(Description_list =
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = 10.2.1.185) (PORT = 1521))
(address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
)
You need to add the following:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = ORCL)
(Sid_name = ORCL)
)
)
/dev/mapper/vgdata-lvdata
1610113 127374 1400951 9%/data Place Map
/dev/mapper/volgroup00-lvoradata
50397 17111 30727 36%/oradata location of files placed in the original GPS database
/dev/mapper/volgroup00-lvoracle
Location of 20159 14265 4870 75%/oracle Oracle Database Installation
/dev/mapper/volgroup00-lvapp
20159 421 18715 3%/app Utility Installation Location
/dev/mapper/vgdata-lvdatafile
1548185 386 1469157 1%/datafile file Database drop location
/dev/mapper/vgdata-lvoradata1
Temporary mount point for 1651398 23552 1543961 2%/oradata1 lvoradata1
To mount the Oradata to the LVORADATA1:
1, stop the database, make a backup of the database, export to other servers;
Set oracle_home environment variable: Export oracle_home=/oracle/product/11202
Set PATH environment variable: Export path= $ORACLE _home/bin: $PATH
Switch to Lsnrctl directory: Cd/oracle/product/11202/bin
Su-oracle
Sqlplus/nolog
Conn Sys/oracle@gps as Sysdba
Shutdown immediate
Exit
Set oracle_home environment variable: Export oracle_home=/oracle/product/11202
Set PATH environment variable: Export path= $ORACLE _home/bin: $PATH
Switch to Lsnrctl directory: Cd/oracle/product/11202/bin
./lsnrctl Stop
Exit
CD/;
Cd/oradata1;
RM-RF Gisap;
RM-RF GPS;
RM-RF Lost+found;
Rm-f test.trc;
Rm-f Full.log;
Rm-f full.dpdmp;
CD/;
Cd/oradata;
2, copy the/oradata directory, copy the data inside to the/ORADATA1 directory;
CP ' Ls-a '/oradata1-r;
3, uninstall two directories, the order is as follows:
CD/
Umount/oradata
Umount/oradata1
4, Mount storage to/oradata under
Mount/dev/vgdata/lvoradata1/oradata
Chmod-r 777/oradata/gps
Chmod-r 777/ORADATA/GISAP
5, start the database for testing
Set oracle_home environment variable: Export oracle_home=/oracle/product/11202
Set PATH environment variable: Export path= $ORACLE _home/bin: $PATH
Switch to Lsnrctl directory: Cd/oracle/product/11202/bin
Su-oracle
Lsnrctl start
Sqlplus/nolog
Conn Sys/oracle@gps as Sysdba
Startup
Exit
Exit