Database Administration (MOSC)

MOSC Banner

10.2.0 SID name length problem? dbassistant

edited Mar 31, 2010 8:00PM in Database Administration (MOSC) 4 commentsAnswered
 I created an instance using dbassist (the Java program) under 10g (10.2.0). It's name was ORABSP10G. It was created but after the dbassist process had finished I saw the service deactivated in Windows XP Service console.
After setting it to Automatic and starting it I could not connect to the database with an ORA-12154
(SQLPLUS SYSTEM/<passwd>@orabsp10g).

I'm a bit clueless at the moment.

--
Christoph

EDIT: I just noticed, that I could connect with ommiting the 9th character, e.g.

sqlplus system/<passwd>@orabsp10

Sigh.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center