Troubleshooting of SQL plus logon failures caused by su switching in Oracle
Problem description:The Oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment suddenly fails
Troubleshooting of Logon failures when su switches to sqlplus in Oracle, oraclesqlplusProblem description:The oracle database in the production environment suddenly fails to log on, and the oracle database in the rlwrap production environment
This article uses the interface installation method, applies to the LAN Remote Installation Oracle and installs directly on the Linux server.
Through the Internet environment installation has not been tested, the Internet environment by silent
On the Linux platform, there are several steps to manually create a database: 1. Confirm the unique instance and database name; 2. Select the character set of the database; 3. Set the OS environment variables; 4. Create the initialization parameter
1. Prepare the environment 1.1.linux RHAS4: RedHatEnterpriseLinuxAdvanceServer4.01.2. check the environment HardDiskSpace [ro
1. Environment preparation 1.1.linux system installation version RHAS4: RedHat Enterprise Linux Advance Server 4.0. Check
A similar warning was found while looking at a client's database recovery log (File #N is offline, but was part of a online tablespace.), not previously noticed, this time by experimenting to reproduce the contentCreate a table spacesql> Create
I. Environmental preparedness
Install package:
1.vmware-workstation-full-11.1.0-2496824.exe
2.centos-7-x86_64-dvd-1511.iso
3.linux.x64_11gr2_database _1of2.zip
Linux.x64_11gR2_database_2of2.zip
The above feel is not the key, not to download the
RMAN replication and the same machine copy operation procedures are the same, the difference is that we need to copy the backup files to the secondary library
Experimental platform: REDHAT Linux 4.7 + Oracle 10g
Target Library Information:
Oracle_
One of Oracle asm kfed tools, asmkfed
[root@localhost db_1]# su - oracle[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ pwd/u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ ls -lrt
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.