Jquest wrote:
> Hello Morgan,
> thanks for writing in ... I did what yuo said .... and it seemed like
> it worked ..
>
> however when ever I am trying to connect to the HR sample database ...
> its giving me the following error
>
> ERROR:
> ORA-12154: TNS:could not resolve service name
>
>
> Warning: You are no longer connected to ORACLE.
>
>
> . ok now I connect as a normal user into SQL Plus .
> then I connect as sysdba . It works fine .
>
> then I give the following commands .. which you mentioned below. works
> fine.
>
> now as connected as sysdba I try loggin in with sysdba uid and
> password....
> it gives the same error
>
> I also try loggin in with the user ID ... and password... nothing
> happens .. its gives that error. I know i am making a mistake some
> where ... Please advice..
>
> thanks
>
>
>
> DA Morgan wrote:
>> Jquest wrote:
>>> Hello All,
>>>
>>> Since I have installed personal oracle 9.2 with sample schemas to
>>> practice on.... when I see the enterprice manager ... I see the schemas
>>> locked and expired ... all I can do those is unlock not activate...
>>> need any ones help on activating and using the schemas.
>>>
>>> How do you connect to those schemas .... whats the uid and password for
>>> those ...
>>>
>>> thanks JQ
>> conn / as sysdba
>>
>> alter user <schema_name> account unlock;
>>
>> alter user <schema_name> identified by <new_password>;
>>
>> Documented in Morgan's Library at www.psoug.org on the Users page.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
- Please don't top post.
- 12154 is a common error. Look up the fix at metalink.com or get a DBA
to help you.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Aug 03 2006 - 12:04:07 CDT
