Process record of an Oracle database mount migration

Source: Internet
Author: User
Tags chmod oracle database installation oracle database sqlplus

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.