Lab environment, Oracle 11gR2 standalone test data software and database upgrade, operating system Linux6.3Oracle version 11.2.0.1 upgrade package 11.2.0.3After the database software and database are upgraded successfully, the following error is
The new server gave me a try. I simply recorded the installation and upgrade process and learned from the experts.
When installing Linux AS 4.7, you can choose LVM to easily manage the space, increase or reduce the size of the file system, and
ORA-12154 TNS cannot parse the specified identifier
Report on using pl/SQL developer to access a remote Linux database in WinORA-12154 TNS cannot parse the identifier, but SQLPLUS is normal under WinC: \> tnsping lin_hjj
TNS Ping Utility for 64-bit
Debian 6 sets Oracle 11g R2 to automatically start upon startup
Log On with the root account.
Step 1: Modify/etc/oratab
Orcl:/home/oracle/product/11.2.0/db_1: Y
Where
Orcl: sid
/Home/oracle/product/11.2.0/db_1: db_home
Y: Start Y (yes) or N (no).
1. Modify the/etc/oratab FileChange the number of databases that need to be started with the operating system from N to Y.Lis:/u01/app/Oracle/product/11.2.0/db_1: NTo:Lis:/u01/app/oracle/product/11.2.0/db_1: Y 2. Edit the dbstart and dbshut scripts
If the client has been installed, this problem occurs again, that is, the permission problem. Google attaches it========================================================== ==========================================================Recently, I am
I have just joined a new project recently. The requirements have been completed and will enter the detailed design stage. The project framework should use a multi-project system framework that is being developed by other project teams and use this
Purpose:
TuxedoApplications are the focus of Performance Testing. As a performance tester, we must focus on how to use them.LoadRunnerTestTuxedoApplication.
Tuxedo Introduction
TuxedoWhat is?
Tuxedo is BeaCompany (has
Three parts in total
Part 1 Oracle 10g Installation
Part 2 ORACLE Express Installation
Part 3 ora-12514 troubleshooting
Part 1 Oracle 10g Installation
Http://www.jb51.net/article/18038.htm
People who have just been familiar with Oracle will feel
Use SQL * Plus to connect to the database and sqlplus to connect to the database
About SQL * Plus
SQL * Plus is the primary command-line interface to your Oracle database. you use SQL * Plus to start up and shut down the database, set database
Auto-start Oracle 11gR2 in Linux
Oracle in Linux is running after installation. After the machine is restarted, Oracle does not add Oracle to the Windows service as in Windows. In linux, You need to manually start the Orcle service.
Run the
Configure the sid_name case for the static listener to cause logon failure.
Remote logon fails due to the Case sensitivity of SID_NAME during static listening configuration.
For Oracle databases, the same name is case-insensitive, indicating
PLSQL cannot identify ORACLE_HOME solution on 64-bit Oracle client
1. Problems
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. On 64-bit Windows, in most cases, the 64-bit Oracle client program
There is an automatic backup script program for rman. I have previously written an automatic backup case for exp backup specific solution (Oracle automatic backup case for Linux platform (using exp tool)
There is an automatic backup script program
When I got to the server, I tried it. I simply recorded the installation and upgrade process. I also learned from the experts how to install LinuxAS4.7. When I chose LVM
When I got to the server, I tried it. I simply recorded the installation and
Ora-12154:tns: Unable to resolve the specified connection identifier (original)I believe that as the Oracle database developers do not encounter "Ora-12154:tns: Unable to resolve the specified connection identifier", today I also encountered a
EXPDP encountered ora-31693&ora-00922Execution EXPDP encountered the following error:Ora-31693:table data Object "Hq_x1". " B3901_p "failed to Load/unload and was being skipped due to error:ora-00922:missing or Invalid optionOra-31693:table data
Method 1:
Is the server operating system windows? If yes, find "configuration and migration tools, administration assistant for Windows NT (AAW)", find the leaf node of your Oracle Home directory in the AAW tree, right click, select properties. In
2003 solution:
Find the installation directory of the Oracle client, right-click the electric shock ambush directory ora92, choose Properties> Security, click "add", and select "location" as the root directory, add the object name "Network Service"
After 64-bit oracle is installed, when plsql is used for connection, the database option is blank. To solve this problem, the following records are generated:1. Download and install oracle 11g r2Http://download.oracle.com/otn/nt/oracle11g/112010/win6
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.