Common errors and Workarounds for Oracle

Source: Internet
Author: User

ORA-12528:
TNS:listener:all appropriate instances is blocking new connections

The ORA-12528 problem is that the service in the listener uses the dynamic service, although the instance starts, but does not register to listen. The instance is registered to the listener through the Pmon process, and the Pmon process needs to be started in the Mount state. So it caused the above error.

There are three ways to solve this problem:
1, the monitoring set to static;
2. Append in Tnsnames.ora (ur=a);
3, restart the service;


Method 1, by modifying the parameters of the Listener.ora, the listener.ora Dynamic registration is set to static registration, and then restart the monitoring

# Listener.ora Network Configuration File: $ORACLE _home\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP) (HOST = [IP]) (PORT = 1521))
    )
  )
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Global_dbname = [DBNAME])
(Oracle_home = [$ORACLE _home])
(Sid_name = [SID])
)
)
risk of static registration: If Lisener restarts in instance, instance will not be found. Static registration requires that you start Lisener before you start instance. And in static mode, the Lisener status shows the unknown

Method 2, boot to the Nomount state, by modifying the parameters of the Tnsnames.ora
# Tnsnames.ora Network Configuration File: $ORACLE _home\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SYK =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = [IP]) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = SYK)
(ur=a)
    )
  )
then connect to the database
sql>alter database mount;
sql>alter database open;

Method 3, restart Oracle or restart Oracle Services
Execute the following commands sequentially under the Oracle account:
Sqlplus/as sysdba;//may error (ORA-01031) execution under other accounts (such as root) because these accounts are not in the DBA group

Shutdown immediate;
Startup

Http://blog.sina.com.cn/s/blog_636415010100x3lc.html

Oracle Instance Name: Error while loading shared Libraries:libskgxp10.so:cannot open Shared object file:no such file or directory

Is the problem of environment variable Ld_library_path.

after 10g, there is generally no need to set ld_library_path in environment variables, but once the oracle_home is migrated to a different directory, the variable needs to be added in the environment variable.

Linux and UNIX support tar mode migration Oracle_home, if there is a need to put oracle_home under other paths, then the entire path is generally copied to the target directory using tar.
However, if you try to start sqlplus directly after the migration, you may get an error:
[Email protected] ~]$ Sqlplus/as SYSDBA
Sqlplus:error while loading shared libraries:libsqlplus.so:cannot open Shared object file:no such file or directory
After setting Ld_library_path, the problem is resolved:
[Email protected] ~]$export ld_library_path= $ORACLE _home/lib
[Email protected] ~]$ Sqlplus/as SYSDBA
Sql*plus:release 10.2.0.4.0-production on Sun Mar 18 16:10:57 2012
Copyright (c) 1982, Oracle. All rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql>
There is a similar error:
[Email protected] ~]$ Sqlplus/as SYSDBA
Sql*plus:release 10.2.0.5.0-production on Sun Mar 18 16:12:03 2012
Copyright (c) 1982, Oracle. All rights Reserved.
Oracleorcl10g:error while loading shared libraries:libskgxp10.so:cannot open Shared object file:no such file or direct Ory
ERROR:
Ora-12547:tns:lost Contact
Enter User-name:
Oracleorcl10g:error while loading shared libraries:libskgxp10.so:cannot open Shared object file:no such file or direct Ory
ERROR:
Ora-12547:tns:lost Contact
Enter User-name:
Oracleorcl10g:error while loading shared libraries:libskgxp10.so:cannot open Shared object file:no such file or direct Ory
ERROR:
Ora-12547:tns:lost Contact
Sp2-0157:unable to CONNECT to ORACLE after 3 attempts, exiting Sql*plus
[Email protected] ~]$export ld_library_path= $ORACLE _home/lib
[Email protected] ~]$ Sqlplus/as SYSDBA
Sql*plus:release 10.2.0.5.0-production on Sun Mar 18 16:12:18 2012
Copyright (c) 1982, Oracle. All rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options
Sql>
Although the wrong table is different, the workaround is the same.

http://blog.itpub.net/4227/viewspace-718879/

ora-00204:ora-00202:ora-27091

Oracle database startup reported the following error:
Ora-00204:error in Reading (Block 3, # blocks 8) of Controlfile
Ora-00202:controlfile: '/app/oracle/orahome1/database/datafiles/control1.ctl '
Ora-27091:skgfqio:unable to queue I/O
SVR4 error:25:inappropriate IOCTL for device
Additional Information:3

Description Control1.ctl file There is a problem!
Want to put this file mv to another directory to do a backup, but I/O error, is really bad!
There are 3 general control files, unless the 3 are broken, or you can replace the bad with a good one:
RM Control1.ctl
CP Control2.ctl Control1.ctl
Re-start Oracle again OK!

Http://blog.sina.com.cn/s/blog_49c1dffa0100teu5.html

Ora-01031:insufficient Privileges

The scene of the error:

(1) Login with Sqlplus "/As SYSDBA"
(2) After the successful landing in the implementation of relevant operations

The second situation has nothing to say, no authority, the warp can be

The solution to the first case:
To Sqlplus "/as SYSDBA" must meet the following conditions:
(1) Linux/unix environment variable oracle_sid,windows not required
(2) Configuring the environment variable Oracle_home
(3) Linux/unix under the $oracle_home/bin/oracle file under U,g have S permissions (let non-Oracle users can have the equivalent of an Oracle account, the assignment method chmod u+s,g+s $ORACLE _home/bin/ Oracle
(4) The user performing this action must be in the DBA user group

Tips:

Linux/unix under Non-Oracle users is not recommended to use Sqlplus "/as SYSDBA" login, it is recommended to use Conn command after Sqlplus/nolog or sqlplus username[@sid] Login

Http://blog.sina.com.cn/s/blog_622a00690100zklx.html

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.