-
someone pls help....
SERVER :
OS=>SPARC SOLARIS 5.8
DB => 8.1.5
SVRMGR> connect internal
Connected.
SVRMGR> startup pfile=initabctst.ora
ORACLE instance started.
Total System Global Area 11333008 bytes
Fixed Size 64912 bytes
Variable Size 10059776 bytes
Database Buffers 1126400 bytes
Redo Buffers 81920 bytes
Database mounted.
Database opened.
SVRMGR> select * from v$database;
DBID NAME CREATED RESETLOGS_ RESETLOGS PRIOR_RESE PRIOR_RES LOG_MOD
E CHECKPOINT ARCHIVE_CH CONTROL CONTROLFI CONTROLFIL CONTROLFIL CONTROLFI OP
EN_RESETL VERSION_T OPEN_MODE
---------- --------- --------- ---------- --------- ---------- --------- -------
----- ---------- ---------- ------- --------- ---------- ---------- --------- --
--------- --------- ----------
3196858936 ABCTST 31/08/200 1 31/08/200 0 NOARCHI
VELOG 111676 111487 CURRENT 31/08/200 1395 111676 05/09/200 NO
T ALLOWED 31/08/200 READ WRITE
1 row selected.
SVRMGR>
in the client side
C:\ORAWIN95\NET80\ADMIN>tnsping abctst
TNS Ping Utility for 32-bit Windows: Version 2.3.4.0.0 - Production on 05-SEP-01
17:35:38
Copyright (c) Oracle Corporation 1995. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=190.200.8.112)(Port=1521))
OK (0 msec)
but when i connect
C:\ORAWIN95\NET80\ADMIN>plus80 system@abctst
SQL*Plus: Release 8.0.5.0.0 - Production on Wed Sep 5 17:36:22 2001
(c) Copyright 1998 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Enter user-name:
ERROR:
ORA-12203: TNS:unable to connect to destination
Enter user-name:
wat's wrong????
-
SHUTDOWN IMMEDIATE and STARTUP again.
Have you made the password file with orapwd?
I suppose that remote_login_passwordfile = exclusive.
-
Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
NAME
---------
ABCTST
INSTANCE
----------------
abctst
SQL> show parameter remote_login
NAME TYPE VALUE
------------------------------------ ------- --------------------
remote_login_passwordfile string NONE
SQL>
I already bounced my db.......
one of the workstation has a version of sqlplus 8.1.5
I created the same entry for the tns. and look what happened
C:\>sqlplus system@abctst
SQL*Plus: Release 8.1.5.0.0 - Production on Wed Sep 5 17:57:30 2001
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SQL>
-
Is everything in order now?
-
1. I think your problem is on client side.
2. the problem is a networking problem.
please try following:
1. make sure the tnsnames.ora, sqlnet.ora file are in the net80\admin directory instead of network\admin directory.
2. check if wsock32.dll file in \windows directory is 65k.
Please let us know how'd it go, and how you solve the problem!
Thank you!
