RE: 10g - ASM
- From: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 11 May 2004 11:27:57 -0400
Hi Mladen, thanks for your response. =20
Here's what I've got. The ASM instance still does not like it. I am
beginning to think it has something to do with ASM.
Sqlnet.ora - This entry required for os authentication
# sqlnet.ora Network Configuration File:
d:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES=3D (NTS)
# listener.ora Network Configuration File:
d:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =3D
(DESCRIPTION_LIST =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D floex0cwdev01)(PORT =3D =
1521))
)
(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D EXTPROC))
)
)
)
SID_LIST_LISTENER =3D
(SID_LIST =3D
(SID_DESC =3D
(SID_NAME =3D PLSExtProc)
(ORACLE_HOME =3D d:\oracle\10g)
(PROGRAM =3D extproc)
)
(SID_DESC =3D
(GLOBAL_DBNAME =3D +ASM)
(ORACLE_HOME =3D D:\oracle\10g)
(SID_NAME =3D +ASM)
)
)
tnsnames:
+ASM =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D floex0cwdev01)(PORT =3D =
1521))
)
(CONNECT_DATA =3D
(SERVICE_NAME =3D +ASM)
)
=20
And the ASM init file. It started with an spfile, then spit up asking
for an init file. This was created by the gui (that later crashed). I
have no idea why asm_diskstring is what it is, but figure it's not a
problem because I can redefine it later. It also doesn't work with +ASM
surrounded by single quotes.=20
*.asm_diskstring=3D'SP2-0640:','Not','connected'
*.background_dump_dest=3D'D:\oracle\admin\+ASM\bdump'
*.core_dump_dest=3D'D:\oracle\admin\+ASM\cdump'
*.instance_type=3D'asm'
*.large_pool_size=3D12M
*.local_listener=3D+ASM
*.lock_name_space=3D'ASM'
*.remote_login_passwordfile=3D'SHARED'
*.service_names=3D'+ASM'
*.instance_name=3D'+ASM'
*.user_dump_dest=3D'D:\oracle\admin\+ASM\udump'
When I try to start up:
C:\Documents and Settings\lkoivu2>sqlplus "Sys as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Tue May 11 09:49:46 2004
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name '+ASM'
SQL>
I also tried adding the following entries to sqlnet.ora and changing the
listener.ora, . No luck.=20
NAMES.DIRECTORY_PATH=3D (TNSNAMES, ONAMES, HOSTNAME)=20
NAMES.DEFAULT_DOMAIN =3D ffci.com
Mladen, I measure appreciation with alcohol.. it has two 0's.
Unfortunately, beer has no 0's. If by some odd chance you are in the
area, I'd gladly buy you a beverage or lunch or something.
-----Original Message-----
From: Mladen Gogala [mailto:mladen@xxxxxxxxxxxxxxx]=20
Sent: Monday, May 10, 2004 5:21 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: 10g - ASM
Lisa, my name is neither Pete nor Byron, but I can help you out with
this
one. The name in the LOCAL_LISTENER is the name from tnsnames.ora file,
not the listener name or a fully qualified TNS address. On 9.2.0.5, it
looks
like this:
SQL>
SQL> select * from v$version;
=20
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Linux: Version 9.2.0.5.0 - Production
NLSRTL Version 9.2.0.5.0 - Production
=20
SQL> show parameter local_listener
=20
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
local_listener string compldb.wangtrading.com
SQL>
The tnsnames.ora entry looks like this:
# TNSNAMES.ORA Network Configuration File:
/pub/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
=20
COMPLDB.WANGTRADING.COM =3D
(DESCRIPTION =3D
(ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D tux925)(PORT =3D 1521))
)
(CONNECT_DATA =3D
(SERVER =3D DEDICATED)
(SERVICE_NAME =3D CMPL.wangtrading.com)
)
)
For you, it isn't necessary to have dedicated server. For me it is,
because of the nightmare
called JDBC thin driver and "connection pooling".
On 05/10/2004 05:00:36 PM, "Koivu, Lisa" wrote:
> Hi Pete and Byron,=3D20
> Also, for those of you who have created the +ASM instance - the
> LOCAL_LISTENER keeps crapping out. How did you configure the
> LOCAL_LISTENER parameter in the spfile or init.ora? I've tried the
> listener name, fully qualifying the listener address and port,
including
> +ASM in the sid_list_listener, and not, and it still doesn't like the
> LOCAL_LISTENER parameter.=3D20
>=20
> Any suggestions are appreciated.=20
With how many zeroes do you spell "appreciate"?
--=20
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission.
If you receive this message in error, please immediately delete it and
all copies of it from your system, destroy any hard copies of it and
notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the
intended recipient. Wang Trading LLC and any of its subsidiaries each
reserve the right to monitor all e-mail communications through its
networks.
Any views expressed in this message are those of the individual sender,
except where the message states otherwise and the sender is authorized
to state them to be the views of any such entity.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
"The sender believes that this E-Mail and any attachments were free of =
any virus, worm, Trojan horse, and/or malicious code when sent. This =
message and its attachments could have been infected during =
transmission. By reading the message and opening any attachments, the =
recipient accepts full responsibility for taking proactive and remedial =
action about viruses and other defects. The sender's business entity is =
not liable for any loss or damage arising in any way from this message =
or its attachments."
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
