Clients connect to the server reported that ORA-28547
Situation is as follows:
C: \> sqlplus "sys / oracle @ vm9i as sysdba"
SQL * Plus: Release 10.2.0.1.0 - Production on Thursday, January 7 13:41:20 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28547: connect to server fails, Oracle Net Manager may be an error
Please enter User Name:
ERROR:
ORA-01017: user name / password is invalid; login is rejected
Please enter User Name:
ERROR:
ORA-01017: user name / password is invalid; login is rejected
SP2-0157: After 3 times trying to can not connect to ORACLE, exit SQL * Plus
Local registry reported that ORA-03113 error.
[oracle @ PENG admin] $ sqlplus system / oracle @ vm9i
SQL * Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:16:08 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-03113: end-of-file on communication channel
Enter user-name:
ERROR:
ORA-01017: invalid username / password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username / password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL * Plus
The local operating system authentication login problem Quemei
[oracle @ PENG admin] $ sqlplus "sys / oracle @ vm9i as sysdba"
SQL * Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:19:12 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
[oracle @ PENG admin] $ tnsping vm9i
TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 07-JAN-2010 09:19:38
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.222) (PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = dbtest) (INSTANCE_NAME = dbtest)))
OK (10 msec)
Final inspection of the listener look at the configuration file found in the (PROGRAM = extproc)
[oracle @ PENG admin] $ vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = / u01/app/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = dbtest)
(ORACLE_HOME = / u01/app/oracle)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.222) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
)
Manually configure the monitor when the COPY down from above on the back that did not get rid of. Remove (PROGRAM = extproc)
Save exit.
Log on locally:
[oracle @ PENG ~] $ sqlplus system / oracle @ vm9i
SQL * Plus: Release 9.2.0.4.0 - Production on Thu Jan 7 09:24:59 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
Client Login:
C: \> sqlplus admin / admin @ vm9i
SQL * Plus: Release 10.2.0.1.0 - Production on Thursday, January 7 14:12:25 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connect to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL>
Related Posts of Clients connect to the server reported that ORA-28547
-
SGA extended the principle of 32bit oracle
SGA extended the principle of 32bit oracle From: http://www.itpub.net/247048.html Because the median 32bitrnoracle restrictions can only visit the oracle process 4g (2 of 32 power) following virtual memory address, the time at a lot of people this is ...
-
Using SQL TRACE and TKPROF
Can type in the operating system to obtain tkprof all available options and output options to sort a list of note has Sort Option Description call analysis prscnt execnt fchcnt the implementation of the number of extraction Analysis of the implementa ...
-
An example of the use of TKPROF
First, view and edit parameters SQL> show parameter max_dump_file_size NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- max_dump_file_size string UNLIMITED SQL> show parameter user_dump_dest NAME TYPE
-
Diagnosis and principles of order
SQL> select disk.value "Disk", mem.value "Mem", 2 (disk.value / mem.value) * 100 "Ratio" 3 from v $ sysstat mem, v $ sysstat disk 4 where mem.name = 'sorts (memory)' 5 and disk.name = 'sorts (disk)'; D ...
-
ORACLE 10G dataguard configuration Step by Step
oracle dataguard
Leave a Reply